April 25, 2011 at 2:57 pm
I have a
I have recently applied the post SP4 2187 hot fix onto a SQL Server 2000 machine. I would like to monitor the memory usage of the SQL Server.
Can anyone advise on how I can do this?
April 25, 2011 at 3:30 pm
Run perfmon (performance monitor/server monitor) and then feast your eyes on this: http://www.quest.com/backstage/promotion.aspx.
This poster/PDF by Kevin Kline @KEKline shows the relevant counters and what values they should be at.
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
April 25, 2011 at 3:35 pm
[Jim].[dba].[Murphy] (4/25/2011)
Run perfmon (performance monitor/server monitor) and then feast your eyes on this: http://www.quest.com/backstage/promotion.aspx.This poster/PDF by Kevin Kline @KEKline shows the relevant counters and what values they should be at.
Jim
Good advice and that is where I would start on SQL 2K
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply