SQL Server Performance

Monitoring Database disk activity

Discussion in 'Getting Started' started by hull_tiger, Jun 18, 2007.

  1. hull_tiger New Member

    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

  2. Luis Martin Moderator

    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.



  3. satya Moderator

  4. hull_tiger New Member

    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.


  5. satya Moderator

    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.

Share This Page