- Date:Dec. 15, 2020
- Time: 1:00 PM – 2:00 PM EST
DBAs are often asked to solve SQL Server performance issues that occurred in the past. And unless you’ve installed a SQL Server monitoring solution, you’re forced to rely on SQL Server’s data collection.
As you’ve probably discovered, SQL Server data collection has many limitations in terms of what it stores historically, what data exists and how data is not integrated together across the various areas of the product and its features.
What you will learn
In this session, you’ll learn how to leverage native SQL Server data collection for troubleshooting and optimizing SQL Server processes. And because native data alone is not enough, we’ll also show you how to design and implement an additional data collection process. You’ll see how to gather other important data that’s useful in historical troubleshooting efforts.
By the end of the session, you’ll be able to troubleshoot and solve some of the toughest SQL Server issues that occurred while you were on vacation or just not around for the production outage.
Janis Griffin has more than 30 years of DBA/database experience, including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business-to-business applications. Janis also held positions as a principal architect and senior manager, mentoring other DBAs on best practices in database performance tuning.
Ben DeBow is an experienced consultant who works with customers of all sizes on their mission-critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also the Founder and CEO of Fortified Data and can be reached at www.fortifieddata.com.