Você sabe quais consultas estão executando no tempdb do SQL Server? Você pode dizer quais consultas estão consumindo mais espaço em disco no tempdb?
A consulta abaixo lista quais são as consultas atuais no tempdb. Isso é muito útil para solução de problemas de uso de disco do tempdb e quais consultas estão criando contenção de recursos no tempdb do SQL Server.
Manter o desempenho do tempdb no SQL Server é fundamental para o desempenho geral do seu ambiente, o tempdb tem muitas utilidades como versionamento, ordenações grandes e etc.
USE tempdb SELECT ssu.session_id, (ssu.internal_objects_alloc_page_count + sess_alloc) AS allocated, (ssu.internal_objects_dealloc_page_count + sess_dealloc) AS deallocated, stm.TEXT FROM sys.dm_db_session_space_usage AS ssu, sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS stm, (SELECT session_id, SUM(internal_objects_alloc_page_count) AS sess_alloc, SUM(internal_objects_dealloc_page_count) AS sess_dealloc FROM sys.dm_db_task_space_usage GROUP BY session_id) AS tsk WHERE ssu.session_id = tsk.session_id AND ssu.session_id > 50 AND ssu.session_id = req.session_id AND ssu.database_id = 2 ORDER BY allocated DESC
Blackjack, additionally known as twenty-one, is just one of one of the most popular gambling…
If you are a fan of online gambling, then you must have come across gry…
On the internet online casinos have transformed the betting industry, enabling players to vegas.hu online…
Casinos online offer free spins to draw new customers. These bonuses are usually very profitable,…
In recent times, online casino sites have actually obtained enormous appeal among gamers, providing a…
Bitcoin, the most preferred cryptocurrency worldwide, has reinvented lots of industries, including the on baixar…