What is too high for th Page Splits/sec counter?

I was reading the Feb. 25 newsletter and in the first tip, Brad mentions that when monitoring the SQL Server Access Methods object: Page Splits/sec it might indicate that you have a high page split occurence. My question is "What exactly is high?"

I'm getting an average of 0.02 on my database and I'm assuming that this would be considered low. This database has mostly inserts happening, very few updates and many selects.

Thanks,

Francois

check outhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=240

I would say you have a very low value of page splits/sec

Yes, 02 would be very low. In fact, this is about what I am running now in one of my busier databases.

------------------
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com