This two day workshop provides participants with the opportunity to learn about advanced SQL Server support topics in a very approachable way. Low-level SQL Server components are illustrated by following the “life of a query”. This helps to consolidate understanding of the architecture and provides a context from which to delve further. An iterative methodology is presented to help structure advanced concepts including:
- Memory grants and cache usage
- I/O considerations and diagnosing problems
- SQL Server waits and wait types
- Troubleshooting latch waits
- Query plan optimisation and execution
The following tools are demonstrated throughout the workshop that are key to fast analysis and resolution:
- PSSDiag and Perfstats for data collection
- SQLNexus for data analysis
Full instruction is given in how to configure and run these tools in your own environment.
Key benefits
This workshop provides attendees with a comprehensive understanding of key SQL Server troubleshooting tools and methods. Attendees will benefit from:
- Reduced time to resolution for production SQL Server problems
- Reduced occurrences of issues through proactive troubleshooting
- Established troubleshooting methodology
Details and Registration:
www.regonline.co.uk/sql-server-internals-and-troubleshooting
v