Tag Archives: Performance

When Do We Worry About Scalability?

Posted on September 18, 2024 by way0utwest

“We need to get the code written for feature X. Can you finish this query today?” We’ve all heard some variation of that request. We have a request or demand, and we need to get it done. We need to … Continue reading →

Posted in Editorial | Tagged , | 1 Comment

Invisible Downtime

Posted on May 22, 2024 by way0utwest

This article has a concept I’ve never heard about: invisible downtime. This is the idea that there are problems in your application that the customer sees. Your servers are running, but the application doesn’t work correctly or is pausing with … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Invisible Downtime

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