Share via

Performance query

Vishal Garg 1,576 Reputation points
2021-06-20T16:15:14.987+00:00

Using the 2nd Last Query in the link :

https://dba.stackexchange.com/questions/83058/how-to-get-cpu-usage-by-database-for-particular-instance

Getting the below parameters for a database having performance issues. The Instance has other databases also :

CPU Percentage : 30%
Logical Read : 209990014
Rows Returned : 2721321
Execution Count : 872455
Physical reads : 296506
Logical Reads : 358689
Logical Writes : 299689
Logical IO : 365273133
CPU Time Sec : 2956183

Can it be a indicator of performance issues

Developer technologies | Transact-SQL
Developer technologies | Transact-SQL

A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator
    2021-06-20T21:08:48.903+00:00

    Haven't I already answered this: You know that you have a performance issue when you have users screaming and yelling at you. And I am not joking.

    Sure, you can monitor the system to be ahead of the users, but you need to know what you are looking for. The above is just some random numbers with no context. During how period were these values collected?

    Was this answer helpful?

    0 comments

Your answer

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