

We can further group the main grid by any of the displayed columns. Results can also be filtered by fragmentation threshold, where the user can manually specify the percentage of index fragmentation threshold so indexes with the percentage below the specified won’t be shown: In the Grid filters group, the fragmentation grid view can be customized to show indexes based on their fragmentation level ( High, Medium or Low). The Main grid displays the result of the performed fast scan. Let us now select AdventureWorks 2014 database from the server panel, check the Index checkbox from the grid to include all its indexes, leave, by default Limited scan mode checked, click on the Analyze button and from drop-down menu choose the Fast analysis option: It is the slowest mode and takes the most resources when compared with other modes, but it returns the most accurate statistics Detailed mode – all pages are scanned and included in statistics.Sample mode – only 1% of all pages in an index or a heap get scanned.In limited mode, only the pages above leaf level of an index get scanned Limited mode – this is the fastest mode that scans the smallest number of pages.Choose between limited, sampled and detailed scan mode. The final result of index fragmentation analysis depends on the selected scan mode. In the Fragmentation tab Index, Job and Scan mode related options are presented as well as Grid and Treeview filters: Let’s group them by Database column which provides insight into index fragmentation percentage level by our databases: Here, this data can further be filtered by any of the presented grid columns. To add more SQL Servers, click on the Add button again, and repeat the same steps.Īfter connecting to a SQL Server, the main grid will appear, showing information like names of indexes, from which table indexes are and type of indexes, database they belong to Select the SQL Server and choose the authentication type:

To begin, let’s first connect to a SQL Server by clicking on Add button from Servers group in Home tab. In this video, we’ll demonstrate some of its features and capabilities: It’s wide range of features allows users to create and manage custom policies, monitor index fragmentation on multiple servers as well as to create index fragmentation reports. ApexSQL Defrag is a powerful application used for scheduled analyzing and defragmenting of SQL Server database indexes. Hello, and welcome to this ApexSQL Defrag DEMO introduction.
