• First: Great article, interesting replies.

    My question:

    This query does not work in MsSql 2000:

    SELECT text, total_worker_time/execution_count AS [Avg CPU Time], execution_count

    FROM sys.dm_exec_query_stats AS qs

    CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st

    ORDER BY execution_count DESC

    Is there some kind of alternative for MsSql2000?

    (Sorry if this has been asked before, I have read the replies rather quickly)