Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sp-blitzindex]

sp_BlitzIndex is a stored procedure that checks the performance and usefulness of the indexes in a single Microsoft SQL Server database.

0
votes
0answers
22 views

Do database restart affect create Index suggestion/statistic?

Do database restart affect create Index suggestion? If I restart database then right after running the sp_BlitzIndex @GetAllDatabases = 1 is it going to give an accurate index statistic? If no, how ...
2
votes
1answer
54 views

SQL Server 2016, temporal tables and compressed indexes

We use temporal tables in our database, and I have just run Brent Ozar's sp_BlitzIndex on it with @mode=0 (urgent issues only). It has come up with 33 issues, all of which are "Abnormal Psychology: ...
1
vote
0answers
21 views

sp_blitzindex randomly fails when run through invoke-sqlcmd

I'm using sp_blitzindex v6.7 on Sql Server 2016(13.0.4451.0), I am intermittently having issues with running it through powershell using invoke-sqlcmd. It happens consistently with the same databases ...
0
votes
1answer
142 views

Insert results of spBlitzIndex stored procedure into table

I would like to create a weekly to monthly job to execute sp_BlitzIndex during the night and insert the results into a table so that I can consume the results. Here's what I've tried: INSERT INTO ...
1
vote
0answers
180 views

sp_BlitzIndex — 'High value" vs 'High Impact'

Sorry, I may be missing something super-obvious here, but I've googled this and asked some colleagues and am not finding a satisfactory answer. I've been using sp_BlitzIndex for a few months now ...
2
votes
1answer
440 views

How to investigate “aggressive indexes”

Having run sp_BlitzIndex on my database I've found a number of "Aggressive Indexes" (https://www.brentozar.com/blitzindex/sp_blitzindex-aggressive-indexes/). Not only but I am finding that the number ...
0
votes
1answer
107 views

Unexpected (not helpful) result on first run of sp_BlitzIndex [closed]

I just ran sp_BlitzIndex for the first time and got 1 row: Priority=-1, Finding=sp_BlitzIndex(TM) v5.7 - September 01, 2017: All Databases, Database Name=NULL, Details: schema.table.index(indexed)=...
1
vote
1answer
109 views

sp_blitzindex Index Evaluation Results

Need some help with the results from the sp_blitzindex. Below is one of the suggestion but not able to understand the comment. http://BrentOzar.com/go/AbnormalPsychology dbo.ACCT_RECV_ADDRESS ...
0
votes
2answers
699 views

sp_blitzindex output

I have latest version of sp_blitzindex. Would like to store results in table. Runs no output, anyone doing this already? Running with parameters below: EXEC dbo.sp_BlitzIndex @databasename = '...
3
votes
1answer
128 views

sp_BlitzIndex gives self-contradictory recommendations

I've used the Brent's sp_BlitzIndex and received the interesting results. For the first run it advises me to create an index. I've done it and executed it again. This time it has told that the newly ...
5
votes
1answer
1k views

Indexes with High Lock waits - how to fix

I've been running dbo.sp_BlitzIndex and have 4 somewhat similar indexes on the main table in my database. Each one has a high number of waits and escalation attempts. I'm not sure where these are ...
3
votes
1answer
196 views

sp_BlitzIndex compilation

I currently use SQL Server 2012 and have BlitzIndex 4.4 not infrequently the execution plan will say I have a missing index on a table. BlitzIndex will often not say any indexes are missing on that ...
0
votes
1answer
224 views

sp_BlitzIndex only results in one row (with priority -1)

Not sure why, but when I run sp_BlitzIndex (v4.5), it always results in only one row (even if set @GetAllDatabases = 1). This is the "header" row that shows Priority = -1. What am I doing wrong? I ...
4
votes
1answer
123 views

sp_BlitzIndex v 4.5 (2016-11-15) failing with collation error [closed]

Posting this in case anyone else runs into this issue... (fix below) After updating to SQL 2016 SP1, I also updated to the latest version of the sp_Blitz procs. Unfortunately, sp_BlitzIndex now blows ...
4
votes
1answer
218 views

“Syntax error or access violation” error with nested square brackets in column alias

When trying to create sp_BlitzIndex I got the error "Syntax error or access violation" I narrowed this down to column alias names like: SELECT ..., index_definition AS [Definition: [...
0
votes
2answers
284 views

Database failed to process. Divide by zero error encountered running sp_BlitzIndex

I am seeing a divide by zero message while running sp_BlitzIndex. I am running Microsoft SQL Server 2008 (SP3) - 10.0.5775.0 (X64) Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service ...
3
votes
1answer
117 views

Error while running stored Proc sp_BlitzIndex (TM) v4.2 - September 03, 2016

I am getting below error while running "sp_BlitzIndex(TM) v4.2 - September 03, 2016". My SQL server version is: Microsoft SQL Server 2012 - 11.0.5058.0 (X64) May 14 2014 18:34:29 Copyright (c) ...
2
votes
1answer
143 views

sp_BlitzIndex finding “Unknown” index

I am going through cleaning up one of our databases, and after deleting an unused index and adding a primary key to the ARPayments table, sp_BlitzIndex is now reporting an index dbo.ARPayment.Unknown (...
3
votes
1answer
513 views

sp_BlitzIndex - “Cannot Insert the value null into column 'index_sanity_id'…”

Hi I'm getting this error message from the latest version of sp_BlitzIndex on one of my test servers: database failed to process. Cannot insert the value NULL into column 'index_sanity_id', table ...
3
votes
1answer
367 views

Filter sp_BlitzIndex output

Is it possible to filter results of sp_BlitzIndex to show only unused and duplicate indexes? If so, how? I haven't tried anything yet. Was just giving a thought of inserting sp output in a table ...
3
votes
1answer
315 views

Why are Op Stats all 0's and yet Usage Stats show 29 seeks

Why are Op Stats all 0's and yet Usage Stats show 29 seeks. This was returned from Brent Ozar's sp_blitzindex. Usage Stats Op Stats Reads: 29 (29 seek) Writes:14 0 ...
2
votes
1answer
878 views

How to start indexing a new data warehouse

I am building a data warehouse (SQL Server 2012, Kimball Dimensional modeling, 750GB) that will supply data to reports (SSRS), cubes (SSAS) and various datafeeds. I plan to use an index tuning tool (...
11
votes
2answers
1k views

How do I get Brent Ozar's sp_BlitzIndex to run on Azure?

I downloaded the SQL Server First Aid Kit from Brent Ozar's website. When I tried to run the sp_BlitzIndex script against my master database via Microsoft Sql Server Management Studio while logged in ...
1
vote
1answer
268 views

Index cleanup/usage help

My question is this: When running sp_blitzindex, I get a lot of these 2 warnings/suggestions: Index Hoarder: Unused NC index and Feature-Phobic Indexes: Potential filtered index (based on ...
4
votes
2answers
901 views

Are scripts like sp_BlitzIndex and the others accurate on restored backups?

I am a developer trying to get a better grasp of things. I am wondering if using the scripts from BrentOzar.com will work on restored backups? For example if I have the DBA give a backup of ...
4
votes
2answers
2k views

Using sp_BlitzIndex - Diagnosed as “Index Hoarder: Addicted to nulls”

Context: MS SQL Server 2012 In using Kendra Little's awesome tool, sp_BlitzIndex, a number of tables were diagnosed as "Index Hoarder: Addicted to nulls". I'm not looking for a debate over NULLs and ...