There are so many different tools that come with SQL Server and Windows that DBAs can use to monitor database performance. Deciding on which tools to use, how often to collect data and then determining what to do with this data is often not very clear and therefore people either over collect data or donít do any data collection until a problem arises. The other issue DBAs face is how to interpret this collected data and how to use it to their advantage for a smooth running SQL Server environment.
In this webcast, SQL Server MVP Edwin Sarmiento, will explore the top things that every DBA should be monitoring to ensure a healthy SQL Server database environment. We will look at items such as memory, disk throughput, poor performing queries, wait stats as well as other key areas of SQL Server that should be monitored. Edwin will show us the native tools for both SQL Server and Windows, techniques for capturing this data and key things to investigate based on the collected data.
This will be a high level discussion for each of these components that should be monitored and the best practices to ensuring you have the necessary data to troubleshoot issues when they arise.
Edwin M Sarmiento is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology, but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
To access materials please fill out the form below.