Collecting and Analyzing File and Wait Statistics
Since Microsoft SQL Server 2000, we have had the ability to collect statistics on two key areas in terms of performance directly from within SQL Server. More specifically, these are the File and Wait statistics and the information that can be gleaned from these has increased dramatically with each new release. SQL Server 2008 currently has over 480 wait types so far. This session shows you how to efficiently capture and analyze the information provided by a set of DMVs in SQL Server 2005 and SQL Server 2008. This knowledge will dramatically decrease the amount of time spent looking for bottlenecks in your system and ensure that you troubleshoot the root cause and not the symptoms.