June 11, 2004 at 1:53 pm
Hello,
I'm getting reports of performance issues with my SQL DB. Having recently replaced the hardware hosting the DB's, I really don't think the problem is on my end. These users are accessing the DB from outside our corp network via VPN as well as connecting to a CITRIX server front end.
My question is can someone tell me what performance monitor counters I should use to get a complete scope on the performance of my DB? And is there any documentation that I can use as a template or scale to determine if the results from the selected counters are in line?
Thanks in advance,
Ronnie
June 14, 2004 at 12:22 am
http://www.sqlservercentral.com/columnists/sjones/performancemonitoringbasiccounters.asp
will put you on track.
- There are # of articles/forumthreads concerning performance monitoring.
this is also very usefull :
http://www.sql-server-performance.com/performance_monitor_tips.asp
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply