Script to list all the indexes in the Nimsoft Database

Discussion created by BryanMorrow on Oct 29, 2010

With the recent issues surrounding the data_engine performance and different versions of NMS having different indexes someone in support created a script to retrieve the index information. This is not my creation but it might save you some time in getting information to support in regards to slow data_engine performance.



USE NimsoftSLM GO   SELECT AS TableName       , AS IndexName       , si.type_desc AS IndexType FROM        sys.indexes si        JOIN sys.objects so ON si.[object_id] = so.[object_id] WHERE        so.type = 'U'     --Only get indexes for User Created Tables       AND IS NOT NULL ORDER BY, si.type