--Page Split/Sec using DMV
SELECT ms_ticks FROM sys.dm_os_sys_info;
Select * from sys.dm_os_performance_counters where object_name = 'SQLServer:Access Methods' and counter_name = 'Page Splits/sec'
Example how to calculate page spilts/sec
Page Splits/Sec = (854,521 – 852,433)counter_value/(621,366,686-621,303,043)time = 2,088 / 63,643 ms
= 2,088/63 sec = 32.1 /sec
Comments