SQL Server Performance

Page Splits/sec

Discussion in 'T-SQL Performance Tuning for Developers' started by BigJimSlade, Feb 26, 2003.

  1. BigJimSlade New Member

    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??

  2. seasider New Member

    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.

Share This Page