August 19, 2008 at 6:18 am
Does SQL 2000 offer anything similar to SQL 2005 DMV's?
I've been tasked (from our CTO) to:
----> Begin collecting the following performance statistics (for 15 SQL Servers -- all 2000), and render reports for weekly Performance Management meetings.
----> Performance Object: Processor; Counter: % Processor Time, % User Time (collect for all CPUs in system) Performance Object: LogicalDisk; Counter: % Disk Read Time, % Disk Write Time, Avg. Disk Queue Length (collect for all logical disks on system) Performance Object: Memory; Counter: % Committed Bytes in Use, Available MBytes, Cache Bytes Performance Object: System; Counter: Processor Queue Length, Threads
SQL 2005 offers DMV's. For SQL 2000, I've historically run server side traces w/ filters on class and event, used the SQL function to extract from the .trc file and store into a SQL table, cleanse the table, load into reporting tables, and use RS to render reports. (we do have Idera's SQLdm but w/ limited licenses)
August 19, 2008 at 6:38 am
There are no DMC's for SQL 2000. Another option is the SQL Health and History Tool (SQLH2) available from MS for free. I have not used it in a while, but it can monitor many of the things you have mentioned and it creates a database you can query for reporting. It is probably easier that server-side traces.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply