...
Access the Tables & Indexes view
You can To open the Tables & Indexes view of the SQL Diagnostic Manager Databases tab by selecting , select the appropriate SQL Server instance, and then clicking Databases > click Databases, and select Tables & Indexes.
Use the Table Details section
...
The Tables and Indexes view allows you to see general table and index statistics for the database selected. You can also rebuild indexes for highly fragmented tables and update your statistics, which are displayed in the chart and tables in the Table Details section of the view. For more information, see the Microsoft document,
| Newtablink |
|---|
| alias | Tables and Indexes |
|---|
| url | https://msdndocs.microsoft.com/en-us/library/ms131037%28v=sql.100%29.aspx/css/sql/connect/oledb/ole-db-tables-indexes/tables-and-indexes?view=sql-server-ver15 |
|---|
|
.
| Note |
|---|
The Collection Service may not gather fragmentation data for a particular table because: - Table statistics collection has not occurred
- The database hosting the table was excluded from collection
- The table size does not meet the minimum size threshold
- The database hosting the table is not accessible
- The table is locked
|
| Scroll pdf ignore |
|---|
| Newtabfooter |
|---|
| alias | IDERA |
|---|
| url | http://www.idera.com |
|---|
|
|
|
...
| Newtabfooter |
|---|
| alias | Products |
|---|
| url | https://www.idera.com/productssolutions/sqlserver |
|---|
|
| | Newtabfooter |
|---|
| alias | Purchase |
|---|
| url | https://www.idera.com/buynow/onlinestore |
|---|
|
| | Newtabfooter |
|---|
| alias | Support |
|---|
| url | https://idera.secure.force.com/ |
|---|
|
| | Newtabfooter |
|---|
| alias | Community |
|---|
| url | http://community.idera.com |
|---|
|
|| Newtabfooter |
|---|
| alias | Resources |
|---|
| url | http://www.idera.com/resourcecentral |
|---|
|
| | Newtabfooter |
|---|
| alias | About Us |
|---|
| url | http://www.idera.com/about/aboutus |
|---|
|
| | Newtabfooter |
|---|
| alias | Legal |
|---|
| url | https://www.idera.com/legal/termsofuse |
|---|
|
|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...