How to capture taskmgr data ?
-
I would like to capture (snapshot) data shown by taskmanager on come of my sqlserver-servers. (NT4 with latest sp and sql7 sp4)
Because these are not dedicated sqlservers and they have only 512mb ram, I would like to take a momentum snapshot of memory total in use / available.
DOS MEM does not deliver the needed info and I don't want to use perfmon just to take a snapshot.
Anyone have any idea how to do this ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Couldn't you set up performance monitor to capture the data to a log file every 15 seconds?
I can't remember whether this was available on NT 4 so maybe it's not an option for you (the things I forget
) -
The "Print Scrn" key works well !!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
print screen on a stone plate ??
I've got 50+ servers to monitor.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I've used PSTAT.exe from the Wk2 resource kit to capture the data,
then transfered the intercepted output to a central place
, imported them into SQL and ran a filterquery to produce my report.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply