"One of you clustered indexes is experiencing page splits ..." this seems like a straight forward question ... you want to decrease your "fill factor" .. i.e. more spare space and less page splits.
However do you do this via "sp_configure" or "rebuild index", this is specific detailed SQL Server knowledge.
You use "rebuild index" here as you are fixing an existing an existing "clustered indexes which is experiencing page splits".
NB sp_configure could be used to set the "fill factor" for new indexes, however in the above problem you need to correct a problem with an existing clustered index
No comments:
Post a Comment