CodeProject.TV will close July 31. Remember to ensure you’ve watched or download your videos! Full details here.

SQL Server Performance Tuning with Wait Statistics (Introduction)

4m 52s
10cbf7a

aasim abdullah

Aasim Abdullah is working as SQL Server DBA with CureMD (www.curemd.com) based in NY. He has been working with SQL Server since 2007 (Version 2005) and has used it in... Read more

Follow on:

Wait Statistics is first power full tool which a DBA uses to find performance bottleneck. But first question is that WHY WAITS OCCUR?

When comes to performance tuning for a poor performing SQL Server instance, biggest question is WHERE TO START looking at to resolve this performance issue. Why queries are waiting for ??? Wait Statistics is the first place which should be explored to directly hit the problem. But Why Waits Occur ? Lets find out.