how to tell that X index on X database is above 80% fragmented

Question

Post reply

how to tell that X index on X database is above 80% fragmented

madhuu1905

Mr or Mrs. 500

Points: 556
More actions
October 6, 2011 at 6:25 am

#249259

hi Friends,
i need help on that X index on X database is above 80% fragmented.. here is my full requirement
Please provide script to check for indexes that are in need of maintenance. We’ll want a report to tell us that X index on X database is above 80% fragmented.
Example:
SERVER Database Index Fragmentation Rows in table
ciber Capone PK_latin 81% 10000

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Ninja's_RGR'us

SSC Guru

Points: 294069

October 6, 2011 at 6:26 am

#1391167

http://sqlfool.com/2011/06/index-defrag-script-v4-1

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Query sys.dm_db_index_physical_stats

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

madhuu1905 Mr or Mrs. 500 Points: 556 More actions · Answer 3

If possible can you please provide the query? I dont have developemnt experience

cindyaz Ten Centuries Points: 1229 More actions · Answer 4

Did you use the script mentioned in the link provided by Ninja's_RGR'us?

Ninja's_RGR'us (10/6/2011)
http://sqlfool.com/2011/06/index-defrag-script-v4-1

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

Ninja's_RGR'us (10/6/2011)
http://sqlfool.com/2011/06/index-defrag-script-v4-1

That'll find the problem indexes AND fix them. What else can you possibly need?