SQL Server Performance Forum – Threads Archive
intensive queries/usersHi 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.
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:<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=http://vyaskn.tripod.com/fn_get_sql.htm>http://vyaskn.tripod.com/fn_get_sql.htm</a><br /><br /><br />Thanks,<br />– Sri
SQL Server Performance – Common Symptoms and Tools –
http://www.sqljunkies.com/Article/D1B7C756-4725-4D31-A53D-C0A47976E6BB.scuk 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…