..and in the clouds…When I first saw early builds of SQL Server 2017, one of the features that caught my eye immediately was Automatic Tuning with an option called Automatic Plan Correction. SQL ...

Thomas LaRock: "Without a basic understanding of wait events and how the occur, you will waste a lot of time trying and guessing at how to improve the performance of a query." Optimizing SQL Server ...

Whether you’re an experienced DBA with multiple certifications or just starting on your SQL Server DBA journey, you face challenges constantly for putting your organization’s data to work. To turn the ...

Database Engine Tuning Advisor provides a graphical user interface (GUI) based way to view tuning sessions and tuning recommendation reports. This lesson shows you how to start the tool and how to ...

Tweaking the performance of your SQL server can provide a host of advantages, but unless you know exactly what perks your tinkering will unlock, you might not be that eager to dedicate the time to ...

SQL Sentry, Inc., a developer of software products that optimize the performance of Microsoft SQL Server environments, and DBSophic, a provider of performance management products for database-centric ...

DBCC statements DBCC (Database Console Command) statements enable you to check performance statistics and the logical and physical consistency of a database. Database Engine Tuning Advisor (DTA) ...

Database professionals agree – SQL Server performance tuning is hard. And on top of that, it never stops because complex database environments are always changing with upgrades, application updates ...