Detecting page split.

  • Hi all,

    how can i chk that a page split has occured or is occuring

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • If you just want to know if and how many page splits happen, there' s a performance counter SQL Server:Access Methods> Pagesplits per sec.

    If you want more detailed information, like which page has been split, that's not so easy.

    SQL Internals Viewer[/url] is a tool which gives you some insight into how data internally is stored, but I'm not sure it keeps track of page splits.

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

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