How can you tune the performance of SQL Server by analyzing the past to predict the future?

by Nov 27, 2020

The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is not as complex a subject as many think it is and we can learn a lot from the earlier behavior of SQL Server. If we analyze the past behavior of SQL Server we can easily predict the future and keep it at optimal speed.

Watch the Geek Sync webcast “SQL Server performance tuning – Analyzing past to predict future with Pinal Dave to learn about the new features of SQL Server 2016 and 2017 and also get a glimpse of the same incremental features in SQL Server 2019.

Click here to watch the webcast.

The presenter, Pinal Dave, is a developer evangelist and SQL Server performance expert. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at “”. Along with over ten years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including Microsoft Certified Technology Specialist (MCTS), Microsoft Certified Database Administrator (MCDBA), and Microsoft Certified Application Developer (MCAD) (.NET).

SQL Doctor

SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments – including managed cloud databases. Unlike its competitors, it displays the health of all SQL Servers, generates ready-to-run SQL scripts to optimize and undo optimization, limits the analysis to specified databases, applications, and performance categories, and provides real-time, as-needed, and scheduled checkups.

For SQL Doctor:

Save almost 40% off the regular price when you purchase online. Take advantage of this limited time offer and pay only $400 per user with the first year of maintenance included! Hurry, this offer ends November 30th! Save Now!