If your SharePoint is having performance issues, one of the reasons could be SQL database index fragmentation.
Index fragmentation occurs when the logical order of pages in a table or index (as defined by the index key) differs from the physical order of the pages in the data files. It can also mean that the data density on data file pages is low, which results in wasted disk space, memory, and I/Os. Index fragmentation can be the result of many inserts, updates, or deletions to a table (https://technet.microsoft.com/en-us/library/cc262731.aspx).
Some index fragmentation is normal, but as fragmentation grows it becomes harder for SQL to perform queries. Fragmentation greater than 90% can hamper SharePoint performance by making common SharePoint database queries slow to perform.
Quest has a free tool that can help you monitor and pinpoint performance issues in your SharePoint server environment and with the help of Mike Watson of https://www.seriouslabz.com/ and @JMikeWatson, you can monitor and measure the level of database indices fragmentation and determine the appropriate action to take!
- Download Quest Software's FREE SharePoint Server monitoring tool called Server Administrator for SharePoint to monitor and analyze your SharePoint performance issues.
- Then download and importMike Watson's FREE SharePoint Celebrity Rule for Server Administrator for SharePoint entitled: Monitor for Database Index Fragmentationso you can quickly determine and measure the level of fragmentation in your database indices and take the appropriate action.
About Mike Watson (@JMikeWatson)
SharePoint architect, entrepreneur, and instructor
MOF, MCSE, MCSA, A+, i-Net+, Net+, CIW
Mike Watson is currently the co-founder and principal at www.SeriousLabz.com, a consulting firm based in Seattle and 100% focused on SharePoint products and technologies. Prior to SeriousLabz, Mike was a product manager at Quest Software and previously a technology architect at Microsoft. When not working, Mike enjoys spending time with his family and racing motorcycles.
Learn more about Server Administrator for SharePoint here: