Presented by: Andrew Kelly
Running Time: 198 minutes
These days, a good DBA needs to be well versed in many aspects of SQL Server. but there are a few areas that are essential to planning and maintaining a SQL Server instance that can scale and perform as the demand increases. We'll start with the fundamentals of proper configuration of the instance and the factors to consider when creating databases. We'll then see how proper query plan reuse is critical to peak performance and how to achieve it. And finally, we'll cover some of the core areas of SQL Server that you want to monitor on a regular basis to ensure your instance is performing the way you want or expect it to.
At the conclusion of the class you should have the tools and queries required to do the following:
- Create a database that will be maintainable and scalable
- Be able to find queries that are not reusing plans and identify why that is
- Identify the core areas of SQL Server to monitor using the supplied queries and techniques discussed
Andrew J. Kelly is a SQL Server MVP with more than 20 years experience with relational databases and application development. He specializes in performance, scalability, and maintainability of large scale SQL Servers. He is a regular speaker each year at IT/Dev Connections and is a contributing editor and writer for SQL Server Pro.
Need to be invoiced or interested in registering 2 or more people? Contact our customer service team directly for assistance.
Phone: 800-262-1954 or 913-967-1719