April 6, 2006 at 5:40 am
HI
My Sql server 2000 looks to be very busy and the buffer keeps over running, I have monitored this using Windows monitoring tools, is there a different way to monitor this and pin point why this is happening. Could this be memory leaks, and how would I know this?
Charlene
April 6, 2006 at 6:43 am
Well, there are n ways to monitor the performance.
The first choice would be the SQL Profiler.
Better go thru these articles which has worth of informations:
http://www.sqlservercentral.com/columnists/lPeysakhovich/performancetipspart1.asp
http://www.sqlservercentral.com/columnists/lPeysakhovich/performancetipspart2.asp
http://www.sqlservercentral.com/columnists/sjones/performancemonitoringbasiccounters.asp
Hope this helps !!
April 6, 2006 at 8:54 pm
What counter are u using to monitor ur SQL Server Performance with Perfmon.
HTH
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply