February 15, 2010 at 8:34 pm
Hi,
Using a query , how can i know what processes,which database, how much memory taken, and being idle for more than 10 mins????
How to generate such a report??
Thank You.
February 16, 2010 at 1:24 am
try sp_who4 active SP
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
February 16, 2010 at 6:03 am
sanketahir1985 (2/16/2010)
try sp_who4 active SP
What is sp_who4 ?:-)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 16, 2010 at 6:07 am
muthukkumaran (2/16/2010)
sanketahir1985 (2/16/2010)
try sp_who4 active SPWhat is sp_who4 ?:-)
I also want to know?
upgrade on sp_who3? which is an upgrade on sp_who2?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 17, 2010 at 10:46 pm
sorry for delay in reply
here is sp_who4 script attached
Sanket Ahir
Don't run behind the success, Try to be eligible & success will run behind u......
May 18, 2010 at 9:38 pm
Thanks so much.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply