1 / 14

Troubleshooting From the Field – Part 2 SQL DIAG & SQL NEXUS By Ahmad Osama

Troubleshooting From the Field – Part 2 SQL DIAG & SQL NEXUS By Ahmad Osama SQL Server Geeks - Editor In Chief and Regional Mentor(Delhi & NCR) www.ahmadosama.net www.sqlservergeeks.com/people/ahmadosama. Agenda. SQL DIAG For Data Collection PerfStats For Data Collection

giona
Download Presentation

Troubleshooting From the Field – Part 2 SQL DIAG & SQL NEXUS By Ahmad Osama

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. Troubleshooting From the Field – Part 2 SQL DIAG & SQL NEXUS By Ahmad Osama SQL Server Geeks - Editor In Chief and Regional Mentor(Delhi & NCR) www.ahmadosama.net www.sqlservergeeks.com/people/ahmadosama

  2. Agenda SQL DIAG For Data Collection PerfStats For Data Collection SQL NEXUS For Data Analysis

  3. SQL DIAG for Data Collection • What it Collects? • Server Side Tracing • Performance Counters • Event logs, Error Logs, dumps etc • How it Collects? • Command line tool • As a service • As a scheduler • Options as an XML file • Specific or All Instance

  4. SQLDIAG Demo

  5. PerfStats for Data Collection • Adds Custom diagnostic to SQL DIAG • New Configuration files • Waits Stats • Locking and blocking • Tightly integrated with SQL NEXUS

  6. PerfStats Demo

  7. SQL NEXUS For Data Analysis • What it does? • Loads data from SQL DIAG into a Database. • Wait Stat Analysis and Reports • Locking Blocking Analysis and Reports • Uses SSRS for reports • Uses Read Trace to Analyze server side traces. • Comes with RML Utilities • Used for analyzing and comparing traces

  8. SQL NEXUS Demo

  9. Summary Use SQL DIAG to Collect DIAGnostic Data Use SQL NEXUS to Analyze Data Troubleshoot remote systems with ease. Microsoft Developer & Platform Evangelism

  10. Links SQL NEXUS – http://sqlnexus.codeplex.com PerfStats - http://bit.ly/17ZJ1jP

  11. Continue your learning… Be a member - www.SQLServerGeeks.com www.FaceBook.com/SQLServerGeeks Twitter @SQLServerGeeks Presentation & Scripts uploaded on www.SQLServerGeeks.com/files

  12. Connect with Ahmad Osama Http://www.sqlservergeeks.com/AhmadOsama @_ahmadosama https://www.facebook.com/ahmad.osama3 ahmad.osama1984@gmail.com www.ahmadosama.net

  13. Q & A

  14. Thank you  for suggestions, please email at admin@SQLServerGeeks.com

More Related