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
Last activity: Aug 22, 2014, 08:44 AM