Wednesday, August 13th, 2014 @ 2:00pm ET
Monitoring is one of the most essential parts of SQL Server administration. SQL Server is a business critical component for most companies’ line-of-business applications and regular monitoring is essential to maintain optimal operation as well as troubleshoot performance issues. In this presentation you’ll learn about some of the essential SQL Server metrics that you need to track to maintain your SQL Server instance. First, you’ll learn about some of the essential tools you can use to monitor your SQL Server instances. Some of the important SQL Server facets to monitor include:
- Capacity planning
- Performance monitoring including performance baselines
Finally, we will discuss the importance of integrating health checks into your monitoring plan, and review the top issues uncovered during routine health checks and a prioritized three-step plan on how to resolve those issues.
If you have already registered, click here to access
Michael Otey, senior technical director for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several features articles showing how to take advantage of virtualization in the enterprise as well as reviewing all of the major virtualization products.
Andy McDermid is a Principal DBA who delivers and manages delivery of DBA services to many diverse clients. He enjoys helping his clients by finding and deploying pragmatic and practical solutions for their database issues. He has conducted dozens of health checks on a variety of client databases. Andy is always working to improve and expand his DBA skills and he likes to share the experience via writing. You can read more about his work here http://www.datavail.com/author/andy-mcdermid.