Page History
...
Another common use of the Files view is to identify the fragmentation percentage on an index. Once identified, you can click Rebuild Indexes to reduce the fragmentation on the selected index.
Access the Files view
You can To open the Files view of the SQL Diagnostic Manager Databases tab by selecting , select the appropriate SQL Server instance, and then clicking Databases > click Databases, and select Files.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >