Link to home
Start Free TrialLog in
Avatar of Vires_PtyLtd
Vires_PtyLtd

asked on

List SQL Indexes, which table they are on, and their fragmentation level

I need to find a script (or scirpts) that

a. Lists the Indexes in an SQL Server, and which table they are indexing

b. List the fragmentation level of each Index

System is using Microsoft SQL Server 2008 R2

While I have found examples via websearch I havent found anything that matches exactly these requireemnts.

For instance "SELECT * FROM sys.indexes" lists a lot of data but it does not make much sense and does not tell you which table any given index is atached to.

Please Help.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Aaron Shilo
Aaron Shilo
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vires_PtyLtd
Vires_PtyLtd

ASKER

Thankyou this worked perfectly.