Troubleshooting From the Field Part 2 SQL DIAG
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/ahma dosama
Agenda SQL DIAG For Data Collection Perf. Stats For Data Collection SQL NEXUS For Data Analysis
SQL DIAG for Data Collection 1. What it Collects? 1. Server Side Tracing 2. Performance Counters 3. Event logs, Error Logs, dumps etc 2. How it Collects? 1. Command line tool 2. As a service 3. As a scheduler 4. Options as an XML file 5. Specific or All Instance
SQLDIAG Demo
Perf. Stats for Data Collection 1. Adds Custom diagnostic to SQL DIAG 2. New Configuration files 3. Waits Stats 4. Locking and blocking 5. Tightly integrated with SQL NEXUS
Perf. Stats Demo
SQL NEXUS For Data Analysis 1. What it does? 1. Loads data from SQL DIAG into a Database. 2. Wait Stat Analysis and Reports 3. Locking Blocking Analysis and Reports 4. Uses SSRS for reports 5. Uses Read Trace to Analyze server side traces. 1. Comes with RML Utilities 2. Used for analyzing and comparing traces
SQL NEXUS Demo
Summary Use SQL DIAG to Collect DIAGnostic Data Use SQL NEXUS to Analyze Data Troubleshoot remote systems with ease. Mar-2008 Microsoft Developer & 9
Links SQL NEXUS – http: //sqlnexus. codeplex. com Perf. Stats - http: //bit. ly/17 ZJ 1 j. P
Continue your learning… Be a member - www. SQLServer. Geeks. com www. Face. Book. com/SQLServer. Geeks Twitter @SQLServer. Geeks Presentation & Scripts uploaded on www. SQLServer. Geeks. com/files
Connect with Ahmad Osama Http: //www. sqlservergeeks. com/Ahmad. Osama @_ahmadosama https: //www. facebook. com/ahmad. osama 3 ahmad. osama 1984@gmail. com www. ahmadosama. net
Q&A
Thank you for suggestions, please email at admin@SQLServer. Geeks. com
- Slides: 14