DBAs are often tasked with solving SQL Server performance issues that occurred in the past. Without a comprehensive SQL Server monitoring solution, you're left to rely on SQL Server’s native data collection, which has its limitations. In this on-demand webcast, you’ll learn how to leverage native SQL Server data collection for effective troubleshooting and optimization of SQL Server processes. Recognizing that native data alone isn't always sufficient, we’ll also guide you through designing and implementing an additional data collection process to gather critical information for historical troubleshooting. By the end of this session, you'll be equipped to troubleshoot and resolve even the toughest SQL Server issues that occurred during your absence.
Topics that will be discussed include:
- Leveraging native SQL Server data collection for performance troubleshooting
- Identifying the limitations of native data collection and how to overcome them
- Designing and implementing an additional data collection process
- Techniques for gathering important data useful in historical troubleshooting
Speakers:
- Janis Griffin, Oracle ACE Director at Quest Software
- Ben DeBow, Founder and CEO at Fortified Data