Index analysis does not work
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
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.