intensive queries/users | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

intensive queries/users

Hi All, Does any one have a script to check for most resource
intensive queries/Users. Regards
Using Profiler you can group queries by duration.
Or using a standard profile, you can insert results into a file/table and then examine them, or query based on user
Thanks , but if there is 10 queries that is alredy running , and I have not started profiler, is there no way I can get the current top 5 users?
Run sp_who2. You can see CPU and I/O per user, but is better profiler.
Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.
And once you identify the SPIDs from the sysprocesses table that are using the most CPU/IO/Memory, if you are interested (why wouldn’t you [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]) in finding the actual queries that these SPIDsa re running, you can:<br /><br />1. Use DBCC INPUTBUFFER(SPID_NUMBER)<br /><br />- OR – <br /><br />2. Use fn_get_sql. A very good place to see how to use this new SQL Server 2000 SP3 system function is to look at an article written by Vyas at<a target="_blank" href=></a><br /><br /><br />Thanks,<br />– Sri
SQL Server Performance – Common Symptoms and Tools – an useful article. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks for all the help…