Tagged: wait statistics

Check Log space utilization using dbcc sqlperf

DBCC & DMVs / Performance Tuning / Wait Types

January 8, 2018

4 Different Usages of DBCC SQLPERF in SQL Server

DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command provides transaction log space statistics and wait statistics information at instance level and we also use it to reset wait and...

DBCC & DMVs / Performance Tuning / SQL Server Interview Questions

December 28, 2017

Should We Clear Wait Statistics Data from DMV sys.dm_os_wait_stats in SQL Server?

Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends on case to case. Ideally, you should not clear your wait statistics data frequently. Best way is Do Not clear wait...

Tagged: wait statistics

4 Different Usages of DBCC SQLPERF in SQL Server

Should We Clear Wait Statistics Data from DMV sys.dm_os_wait_stats in SQL Server?

Like us on Facebook

Tags