Page Splits/sec | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Page Splits/sec

I’m monitoring one of my load proccesses and I’m seeing ~4 pagespilts per second. Is there any easy way to deterime what table or index is causing this? several of my indexes are 100% fill factor but these are tables where there should be no inserts into only reads Also is it ok to set a fill factor to 100% if the only inserts are occuring at the end of the table(due to a clustered index) with no updates?? Thanks
Yes a 100% fillfactor on a table clustered on an incrementing key is fine. You can also get away with Update’s as long as you don’t change the clustered key or increase the size of data in column. This would cause SQL Server to delete the row and insert a new row and this would include a page split – this would be an expensive I/O operation.

]]>