Sample Header Ad - 728x90

SQL Server 2000 Page Splits per second higher han 12 million?

0 votes
1 answer
105 views
I was reading about [index fill factors & performance](http://sqlmag.com/blog/what-fill-factor-index-fill-factor-and-performance-part-1) , and out on a whim I tried the query given by the webpage on the company's production SQL Server 2000 server: SELECT * FROM MASTER.dbo.sysperfinfo WHERE counter_name ='Page Splits/sec' AND OBJECT_NAME LIKE'%Access methods%' Imagine my shock when I saw the result is **12164778** (yes, that's _larger_ than _12 million_). Is it actually possible to have 12 million page splits per second? Or am I reading the numbers incorrectly? Or is there a mistake in the query?
Asked by pepoluan (187 rep)
Aug 22, 2014, 08:13 AM
Last activity: Aug 22, 2014, 08:44 AM