SQL Server Performance Tools - Boise Code Camp Presentation

  • Article

Today I am presenting about SQL Server Performance Tools at the Boise Code Camp. You can download the slides and supporting files here on this blog (at the bottom it says Attachment(s): PerformanceTools.zip ). The basic agenda of items covered is:

¢ Methodology

¢ SQLDiag

¢ PSSDiag

¢ SQLNexus

¢ Profiler

¢ PerfMon

¢ References

The perfstats script I discussed can be found at:

https://blogs.msdn.com/psssql/archive/2007/02/21/sql-server-2005-performance-statistics-script.aspx

And the perfstats analysis tools are at:

https://sqlnexus.codeplex.com/wikipage?title=Sql2005PerfStatsScript&referringTitle=Home

PerformanceTools.zip