1 / 9

SQL Server Performance and Analysis Tools

SQL Server Performance and Analysis Tools. Rob Carrol, SQL Server Premier Field Engineer, Microsoft. SQLdiag Utility. Collects the following information: Windows performance logs Windows event logs SQL Server Profiler traces SQL Server blocking information

erwin
Download Presentation

SQL Server Performance and Analysis Tools

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server Performance and Analysis Tools Rob Carrol, SQL Server Premier Field Engineer, Microsoft

  2. SQLdiag Utility • Collects the following information: • Windows performance logs • Windows event logs • SQL Server Profiler traces • SQL Server blocking information • SQL Server configuration information • Is located at <drive>:\Program Files\Microsoft SQL Server\90\Tools\binn • Uses the SQLDiag.XML configuration file • Sends the output to C:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLDIAG • Has several parameters

  3. SQL Diag Configuration Files Example syntax: sqldiag /I sd_general.xml /E +00:10:00

  4. SQL Nexus • SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. • It loads and analyzes performance, dramatically reducing the amount of time you spend manually analyzing data • Fast, easy data loading from Trace files • Visual representation of trace data via reports • Trace aggregation and summary • Wait stats analysis • Full-features reporting engine • Extensibility • Free to download from Codeplex: • http://www.codeplex.com/sqlnexus

  5. Performance Analysis of Logs (PAL) • VB-based tool to provide automated analysis of Performance counter logs • Includes threshold files to analyse systems based on their role (SQL, IIS, MOSS, etc) • PAL compares counters against threshold values and raises alerts if counters exceed these values • Provides an HTML based report once analysis has completed • Download free from Codeplex • http://www.codeplex.com/PAL

  6. PAL Output

  7. PAL Output

  8. Further Resources • SQLDiag • http://msdn.microsoft.com/en-us/library/ms162833.aspx • SQL Nexus • http://www.codeplex.com/sqlnexus • Performance Analysis of Logs (PAL) • http://www.codeplex.com/PAL

More Related