This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 59%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hello ,
We are seeing the slow performance of the queries and wanted to know which performance counetsr we should focus on to get more info avout the the issues
Thanks
HImanshu
I tempted to say: None. Personally, I very rarely look at performance counters for troubleshooting bad performance.
Your best tool for troubleshooting query performance is Query Store where you find a wealth of information. Provided, that is, you have it enabled. It is on by default in Azure SQL Database, and also for new databases in SQL 2022. But for databases in older versions, you need to enable it.
Once you have enabled it, you will find a node Query Store in Object Explorer for the database. There are a couple of reports, that I am sure that you will find useful.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
I don't see this node in Object Explorer. I see the following for the database:
Does it mean it enabled? Do I have to have certain permissions to view it?
Also, is it bad that we have Optimizer Fixes = Off?
Hi @Himanshu Sinha，
This article describes how to handle a performance issue that database applications may experience when using SQL Server: slow performance of a specific query or group of queries. The following methodology will help you narrow down the cause of the slow queries issue and direct you towards resolution.
Troubleshoot slow-running queries in SQL Server
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.