SQL Server Performance Forum – Threads Archive

Monitoring Database disk activity

Hello I am in a new DBA role and I need to quantify the amount of data change (writes,deletes etc) in bytes etc in my sql 2000 databases. We are looking at a Unisys Safegaurd 30M replication for disaster recovery but I need to monitor the exact amount of change so we can calculate the amount of bandwidth required etc. What is the best way to do this? Are there any basis instructions for a beginner.
Thanks for your help. Regards JD

You can use Performance Monitor. Choose disk counters and store in csv file. After some time you can export to excel and see what is going on.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

http://msdn2.microsoft.com/en-us/library/ms175903(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms345109(SQL.90).aspx
http://www.sql-server-performance.com/sg_sql_server_performance_article.asp Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Thanks Does the perfmon sampling show the exact amount of data writes? For example if I chosed the sample every 15 seconds, is this a snapshot every 15 seconds or does it display the amount of change in the last 15 seconds. I am trying to obtain the exact amount of database changes in bytes on our overnight processing on our SQL Server 2000 databases.

Yes, it will be and by default it is 15 seconds. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

]]>