SQL Server Waits and Queues – Your Gateway to Performance Troubleshooting
Session Level: 300
Session Category: Regular Session (75 minutes)
Session Track: Enterprise Database Administration and Deployment
Just like a horoscope, SQL Server Waits and Queues can reveal your past, explain your present and predict your future. SQL Server Performance Tuning uses the Waits and Queues as a proven method to identify the best opportunities to improve performance. A glance at Wait Types can tell where there is a bottleneck. Learn how to identify bottlenecks and potential resolutions in this fast paced, advanced performance tuning session.
I have previously presented this session at TechEd India and it got very much appreciated by attendees: SQLAuthority News – TechED 2011 – Bangalore – An Unforgettable Experience – Day Next.
Reference : Pinal Dave (http://blog.SQLAuthority.com)