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 these FREE tools today!
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: