Index analysis does not work

yanning_carfield 2017-03-09 16:09:24

Hello,

I Use sql server 2012 and latest sql sentry.

click index analysis tab and wait for 10 mins

the command text is

select parentId, count(*) from dealerships group by parentId

Aaron Bertrand 2017-03-09 16:50:29
Is the table partitioned? Are you sure Plan Explorer is latest? What does Help > About say?
madisonquinn 2017-06-30 06:50:59
Hello,

There are several built in utilities in SQL Server that allow you to take a look at your indexes, but none offer a simple approach to list all indexes for all tables.

Enterprise Manager
Database -> Tables -> All Tasks -> Manage Indexes
The problem with this approach is that you have to look at one table and one index at a time
Using the sp_helpindex stored procedure
sp_helpindex products
The problem with this approach is that you can only see one table at a time
Querying the sysindexes table
SELECT * FROM sysindexes
The problem with this approach is that you need to write a complex query to make sense out of some of the data
Using sp_msforeachtable
sp_msforeachtable "sp_helpindex '?'"
The problem with this approach is that each group is segmented into its own result set and you can't tell which table the results are for

Hope this helps, Thanks.