Post reply

Page Splits exceeds a predefined value

  • July 3, 2013 at 6:14 am

    #279474

    Hi

    How can i get Page splits value

    Please provide sql query to find out Page splits value

  • July 3, 2013 at 6:38 am

    #1629499

    There is a counter in sys.dm_os_performance_counters for pagesplits/sec and as far as I understand, when querying sys.dm_os_performance_counters, any per/sec counter is actually a cumulative amount since SQL was started.

    select * from sys.dm_os_performance_counters

    where counter_name = 'Page Splits/sec'

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

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