Regular Expressions to Generate Disable/Drop Index Scripts

[eliassal]

Hi alevyinroc, I went through your post mentioned in the title which is very interesting, when I run the sp_BlitzIndex against any DB I don't get what you refer to

Reads: 5,692 Writes: 8,683,633 on: dbo.tablename.indexname (10)

Here is the PS code I used
Invoke-DbaQuery -SqlInstance SQL2K12 -Query "exec admin.management.sp_BlitzIndex @DatabaseName=StackOverflow2013,@Mode=4;" | Export-Excel -Path ~\Documents\IndexAnalysis.xlsx
I get

No records for read/writes as yours for the indexes, in which column "Reads: 5,692 Writes: 8,683,633 on: dbo.tablename.indexname (10)" this phrase should appear?
Thanks in advance for your help

[alevyinroc]

Thanks for reading!

You aren't seeing that note in the sp_BlitzIndex results because you don't have any indexes with a high write-to-read ratio in their current usage stats. Based on your other usage stats, that's likely because you recently restarted the instance, just restored the database, or restored the database but haven't done a lot of work with it since. This is one of the sp_BlitzIndex findings that really needs a lot of "soak time" to get an accurate picture of usage.

If you point sp_BlitzIndex at a database that's got higher traffic, on an instance that hasn't been restarted in a while (at least a week), you'll probably get more results, including the one you're looking for here.

I recommend that you update the First Responder Kit - your screenshot shows that you're running a 3 year old version.