Results 1 to 3 of 3

Thread: Page Splits

  1. 07-13-2004, 05:07 AM #1
    jamie.downs
    jamie.downs is offline Registered User
    Join Date
    Jul 2004
    Posts
    4

    Page Splits

    Hi,

    I want to check if I have excessive page splitting a for a certain table/index does anyone know if it is possible to monitor page splits for a certain table/index?

    Cheers
    Jamie
    Reply With Quote Reply With Quote
  2. 07-13-2004, 08:26 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Not as I aware of. Can try to query dpages for the index from sysindexes before and after data modifying on the table to get difference, but the result is not caused by page split only.
    Reply With Quote Reply With Quote
  3. 07-13-2004, 10:56 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try using Profiler.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules