May 22, 2003 at 8:38 am
How can i see what processes are running and howmuch memory being utilized on my sql server.
May 22, 2003 at 9:10 am
You don't mean Task Manager, do you?
If you mean something like Current Activity in EM there is a really good script for a sp here:
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=135&lngWId=5
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 22, 2003 at 9:16 am
IF its in task manager how to see the info?
May 22, 2003 at 9:29 am
In task manager there are three tabs. I think on the second you get a list of all running processes and what amount of memory they use.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 22, 2003 at 9:35 am
when i look at my pids sqlserver.exe is taking 90%of the memory,which is abnormal.What should i do in this case
Thanks
May 22, 2003 at 9:50 am
If SQL Server is set to 'Dynamically' manage the memory, then the fact that it is using 90% of the memory shouldn't be a problem, as SQL Server will release the memory if another process needs it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply