Performance counters

Himanshu Sinha 11 Reputation points
2025-03-03T20:29:36.13+00:00

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

SQL Server | SQL Server Transact-SQL
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 121.7K Reputation points MVP Volunteer Moderator
    2025-03-03T22:24:22.41+00:00

    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.


  2. ZoeHui-MSFT 41,491 Reputation points
    2025-03-04T05:22:10.9866667+00:00

    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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.