• Why not use the system dmvs? e.g.

    SELECT TOP 100 [Average IO] = (total_logical_reads + total_logical_writes) / qs.execution_count,

    [Total IO] = (total_logical_reads + total_logical_writes), [Execution count] = qs.execution_count,

    [Individual Query] = SUBSTRING(qt.TEXT, qs.statement_start_offset / 2,

    (CASE WHEN qs.statement_end_offset = - 1

    THEN LEN(CONVERT(NVARCHAR(MAX), qt.TEXT)) * 2

    ELSE qs.statement_end_offset END - qs.statement_start_offset) / 2),

    [Parent Query] = qt.TEXT, DatabaseName = DB_NAME(qt.dbid)

    FROM sys.dm_exec_query_stats qs

    CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt

    ORDER BY [Average IO] DESC;

    SELECT TOP 100 [Average CPU used] = total_worker_time / qs.execution_count,

    [Total CPU used] = total_worker_time, [Execution count] = qs.execution_count,

    [Individual Query] = SUBSTRING(qt.TEXT, qs.statement_start_offset / 2,

    (CASE WHEN qs.statement_end_offset = - 1

    THEN LEN(CONVERT(NVARCHAR(MAX), qt.TEXT)) * 2

    ELSE qs.statement_end_offset END - qs.statement_start_offset) / 2),

    [Parent Query] = qt.TEXT, DatabaseName = DB_NAME(qt.dbid)

    FROM sys.dm_exec_query_stats qs

    CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt

    ORDER BY [Average CPU used] DESC;


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/