Developers inform you about a query that's consuming way too much time and interfering with other transactions. Or, users contact the help desk stating that the database application is slow. You, as the DBA, review the database and see problematic transactions blocking queries and continuing to consume server resources and time.
Whether you're in an urgent situation, seeing a growing problem, or are seeing a recurring pattern, we will cover some performance tips you can use to improve the performance of your systems and queries.
In this webcast, we will take a look at various tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join us to learn how to optimize your systems.
About the Speaker: Tim Smith began working with technology in high school, helping his 1A Texas high school place and win in the TCEA competition. He continued his journey with a heavy interest in data, especially predicting future outcomes with the stock market, global resource use, and individual success markers. He works as a SQL Server database administrator and developer at Amherst Securities and as a Senior MongoDB database administrator and developer at RS Consulting Partners He also teaches Mastering ETL Development Through Automation on Udemy.
Topics: Database Performance, Database Monitoring, Database Diagnostics Products: SQL Diagnostic Manager for SQL Server