SQL Server statistics logical reads negative number
This question was migrated from Stack Overflow because it can be answered on Database Administrators Stack Exchange. Migrated 17 hours ago. I am trying to understand and analyse a CPU intensive select query in SQL Server, however, I see something strange which is a negative number as logical reads. I wonder if it is a […]
SQL Server statistics logical reads negative number
This question was migrated from Stack Overflow because it can be answered on Database Administrators Stack Exchange. Migrated 17 hours ago. I am trying to understand and analyse a CPU intensive select query in SQL Server, however, I see something strange which is a negative number as logical reads. I wonder if it is a […]
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ??