Helps in evaluating how applications are running on SQL Server. It helps to track CPU, memory and RAM.
In 2000, it was done by using the command DBCC SQLPERF (‘WAITSTATS’)
In 2005, it is replaced with DMV known as sys.dm_os_wait_stats.
It gives information about the columns wait_type, waiting_time etc.,
Different waittypes that are captured are:
1. Latches/Locks
2. Backups
3. Tlogs
4. Checkpoints
5. Lazy writer
It helps in troubleshooting query performance issues .
0 Comments.