All Questions
2 questions
7
votes
2
answers
1k
views
Is the Query Store's Overall Resource Consumption report telling me my database is doing terribly or are the numbers just whacked?
Recently we upgraded one of our production servers from SQL Server 2016 to SQL Server 2019 (CU 15).
This was a great opportunity for me to enable Query Store on our main application database.
It's ...
11
votes
4
answers
18k
views
SQL Server 2019 performance worse than 2012... am I missing something?
We have a SQL Server 2012 server which far outperforms a SQL Server 2019 database on (as far as I can see) the same infrastructure. We are hosting both databases on a cloud platform with the same SLAs....