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)