This one never falls off a cliff. It is just slow, and it has always been slow, and that is exactly why nobody looks. A cliff gets investigated. A server that has been a bit sluggish since the day it went in just becomes the weather. People stop noticing it. New starters assume it has always been like this and was meant to be. They are half right. It has always been like this. Nobody meant it.
Nothing broke on this server, because nothing was ever right, and a thing that is always wrong does not look like a fault.
I have seen some version of this many times. The install ran with the defaults, because the defaults work, and working is not the same as good. Tempdb left as a single file on a busy box. Autogrowth set to creep up in tiny increments, so the files spent years growing a sliver at a time and fragmenting as they went. A memory setting still sitting where the installer left it, the server happily handing most of its RAM to everything except the database. None of it was broken. All of it was costing you, quietly, on every query, since the first hour it ran.
The team had done everything you are supposed to do. They tuned queries. They added indexes. They rebuilt them on a schedule. They had even bought more memory once, which helped for a while, the way a bigger fuel tank helps a car with the handbrake half on. The actual brake had been on since install, sitting in a setting nobody changes because nobody is told it is there. The default is invisible. That is its whole trick.
We found it the dull way, by reading what the server was actually doing instead of asking what people thought it was doing. The numbers had been saying it the whole time. Waits piling up on the one thing a single tempdb file makes them queue for. File growth events scattered through the logs like a slow leak. It was all on the record, going back years. No alarm ever fired, because nothing was failing. The server was just paying a tax, every second, that nobody had ever seen itemised.
The fix was an afternoon and a quiet maintenance window. No new hardware. The setting that had throttled the server since install got changed. The files got laid out the way they should have been on day one. The thing that had been the weather for years stopped being slow. The lesson is dull and it is the whole point. The defaults are a starting line, not a finish. A server can run wrong forever and never once tell you it is wrong, because to it, wrong is all it has ever known.
We run a free, read-only health check that reads what your server is genuinely doing and flags the settings that have been quietly costing you since the day it was installed. Fifteen minutes, no changes to anything, and you get a graded report in plain English you can act on. If your server has just always been a bit slow, that is worth a look. Always-slow is usually a setting, not a fact of life.
Want to know if this is sitting in your estate? We run a read-only check and hand you a graded report in plain English.
Get your free health check