Show me the wait stats
'Using wait stats to identify pressure points on your SQL Server is a common method for troubleshooting. Unfortunately , it is very easy to jump to conclusions about problems on the basis of the highest wait stats.
My general approach is to use wait stats , but letting them guide me to extra analysis. There could be all sorts of reasons why a wait stat or a combination of wait stats appear .
The more you use wait stats , you develop methods for troubleshooting. Interpreting the initial findings will help you start to ask the right question.
These are some of the wait stats available categorised. This is where the waits are appearing, but there could be multiple reasons for their occurrence.'...
http://www.sqlserver-dba.com/2016/05/show-me-the-wait-stats.html
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt