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
SQL-Server-Performance.com 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: 1. Use DBCC INPUTBUFFER(SPID_NUMBER) - OR – 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=http://vyaskn.tripod.com/fn_get_sql.htm>http://vyaskn.tripod.com/fn_get_sql.htm</a> Thanks, – Sri

SQL Server Performance – Common Symptoms and Tools –
http://www.sqljunkies.com/Article/D1B7C756-4725-4D31-A53D-C0A47976E6BB.scuk an useful article. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks for all the help…

]]>