CXPACKET is a common wait type, resulted by parallel query execution. But does occurrence of CXPACKET wait is always a sign of performance problem???
A lot more written. But here is our second animated video to learn it in a very simple way.
Friday, May 2, 2014
Sunday, April 6, 2014
Video: SQL Server Performance Tuning with Wait Statistics (Introduction)
To investigate performance bottleneck, Wait Statistics is a power full tool which a DBA like to use on priority. Understanding waits is not that difficult but the way books and blog entries describe, makes it more complicated.
This is first out of 5 videos series. A simple way to understand internals of WAITS and how they can effectively be used to resolve SQL Server performance problems.
SQL Server Performance Tuning with Wait Statistics (Introduction) from aasim abdullah on Vimeo.
Subscribe to:
Posts (Atom)
