Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-03-14 : 02:41:20
|
| Hi All,I was used SQL server Doctor from Idera and suggested with the following.Finding:SQL Server is experiencing relatively high levels of page splits and its memory is not under stressRecommondation:It is recommended that the fill factor be lowered on indexes that are experiencing a high number of page splits. This will result in better insert and update performance. Impact ExplanationPage splits are currently accounting for 18.2% of all new page allocations.Pls help me how to address this issue,.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
|
|
|
help on this SQL doctor recommondation