January, 2009

Posts

| |

|

Vijay

List all the statements in the Plan Cache along with the counts and CPU usage

Posted over 3 years ago

by Vijay Korapadi
- 1 Comments
SELECT t . [text] AS [Adhoc Batch or Object Call] , SUBSTRING ( t . [text] , ( qs . [statement_start_offset] / 2 ) + 1 , (( CASE qs . [statement_end_offset] WHEN - 1 THEN DATALENGTH ( t . [text] ) ELSE qs . [statement_end_offset] END - qs...
Vijay

Query to list all the databases in the order of CPU usage

Posted over 3 years ago

by Vijay Korapadi
- 0 Comments
USE master SELECT a . [value] AS [dbid] , ISNULL ( DB_NAME ( CONVERT ( INT , a . [value] )), 'Resource' ) AS [DB Name] , SUM ( qs . [execution_count] ) AS [Counts] , SUM ( qs . [total_worker_time] ) / 1000 AS [Total Worker Time (mSecs)] ...