I am using the Performance Dashboard to gather more information for my queries.
I have noticed that when I select the "On Duration" option under the Expensive Queries section I get a list of 20 queries ordered by the highest CPU time. I have been able to play around with the .rdl file (in particular the query_stat.rdl) and made it so that it displays more. The max seems to be 100 for display though.
I was wondering whether anyone knew of how to make it so that there is no max, and how to order the queries based on LEAST CPU time.
Thanks.
You might look at dm_exec_query_stat DMV in this case to get the result.|||
How did you change the number of queries returned from 20 to 100? I would assume you modified the .rdl file or the underlying stored procedure in SQL Server. You could do the same thing to change the sort order or the column on which you sort the result set. If you're just interested in the information, you could take Satya SKJ's advice and write your own query directly against the Dynamic Management Views.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
No comments:
Post a Comment