To my surprise, I have been seeing storage performance results reported using server benchmarks and their associated server metrics. Server benchmarks are specifically designed to measure the maximum ...

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 ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...

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 degraded ...