SQL Server comes with a feature called Query Store, which provides some performance details, including wait information. For more deeper diagnostic information there are a handful of third-party ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't.

Know your SQL Server database KPIs A DBA is frequently challenged on how to improve, optimize, and maintain the performance of SQL server databases. SQL performance tuning is one of many ways to ...

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

SQL Server also has separate logs for the SQL Server Agent, as well as other components of the data platform, such as SQL Server Analysis Services. In each case, SQL Server keeps seven rolling log ...

That’s a long time ago. Even in the Price/Performance category, SQL Server is only 4 th behind Oracle 11g. Sybase SQL Anywhere 11 is making a notable 5 th. Has Microsoft been sitting on its hands?

Intel's Hyperthreading Technology (HT) is being blamed for server performance problems. With both SQL Server and Citrix Terminal Server installations, HT-enabled motherboards show markedly ...