Tag Archives: Performance

Be Careful with Missing Index Requests

Posted on December 4, 2023 by way0utwest

One of the things that has been interesting to watch over time is how the SQL Server platform has expanded the amount of information that we get back about the performance of the query optimizer and query processor. While it’s … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Be Careful with Missing Index Requests

The SPU

Posted on December 19, 2022 by way0utwest

Ever since I heard about the SQLOS and all the work that went into producing an operating system for SQL Server inside of the host OS, I’ve thought that perhaps there might be value in specializing the environment for a … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The SPU

The Growth of IQP

Posted on October 3, 2022 by way0utwest

When Microsoft started to talk about Intelligent Query Processing (IQP) before SQL Server 2017, I wasn’t sure what to think. There was a diagram with 20 things on it, and only 5 were highlighted (you can see that in the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Growth of IQP

The Need for 256GB

Posted on January 21, 2022 by way0utwest

I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019, Glenn Berry asked that the limit be raised to 256GB. In the … Continue reading →

Posted in Editorial | Tagged , , | 5 Comments