Database, Data Engineering, Cloud & AI consulting since 2007
SQL Server
Performance problems rarely arrive as a new server. A query, a report or a job that used to finish now does not, and the application team is the one who hears about it.
Common causes are a plan that changed, statistics that no longer match the data, blocking that only shows up at peak, or an index that helped one screen and hurt another. Adding hardware first hides the cause and often does not last.
We start from the statement users are waiting on, then look at waits, Query Store where the version has it, and the indexes that query needs. Tuning sits inside SQL Server DBA services when you also want it watched after the fix.
The SQL Server version and when it got worse are enough to start. We will say if this is a query problem or a capacity problem.
