SQL Server Indexes
Microsoft SQL Server stores data in pages inside the database file. These pages are in 8KB blocks. If data is larger than 8KB it will span multiple pages.
MS SQL Server uses indexes to organize data, and those indexes can become fragmented over time. This fragmentation can cause slow performance when executing database queries and drag down your whole web application.
A SQL Server database can have Internal Fragmentation or External Fragmentation.
Internal Fragmentation occurs when a SQL Server page has too much free space. For example, throughout a day of use a SQL Server database could start with 40 pages that are 99% full and at the end of the day have 60 pages that are 70% full. This change happens after a period of deleting and inserting data throughout the day. This will decrease the performance of your system.
External Fragmentation happens when pages in the database are out of order. Pages can become out of order after heavy use.
To fix this, an admin will need to identify indexes that are broken and reindex them.
The Bit AI Indexer will run in the background for you and fix indexes when they pass a fragmentation level you set. It will also send you an email update when selected.
0 Comments