Post reply

sql profiler monitor page splits per sec

  • September 19, 2011 at 5:09 am

    #390427

    Hi can sql profiler be used to monitor page split per sec on sql server 2000 and sql server 2008?

    any advise how to do it?

  • September 19, 2011 at 8:43 am

    #1383326

    I dont think you want to use SQL Profiler to monitor page splits per second. I think you will have more success using Performance Manager.

    Administrative tools> Reliability and Performance. Expand Data Colelctor Sets, then go to User Defined, right click- New>Data Collector Set> create manually> Peformance Counter>Add> SQL Server Access Methods: Page Splits/sec

    OK, NEXT, FINISH

  • September 19, 2011 at 9:00 am

    #1383345

    Just bear in mind that's not actually page splits (in the sense of SQL splitting a full page). Any page allocations into the index get counted against that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 19, 2011 at 9:09 am

    #1383347

    Hi

    thanks for your advise another question: can the system monitor be located on a different machine to where the sql server is located inorder to monitor the activities of the sql server

  • September 19, 2011 at 5:46 pm

    #1383594

    Yes you can do that..

    Connect to the computer ..

    Thank You,

    Best Regards,

    SQLBuddy

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply