September 2, 2013 at 12:15 am
This formula is given by microsoft to find out the index performance impact "user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 )".
But what is the unit to measure it. And if there is no unit to measure it then how can we say that index needs to be created. Like suppose if this column returns more then 100 then index needs to be created or if this value exceeds 1000 then this index needs to be created?
September 2, 2013 at 2:49 am
It's not a unit and you cannot tell just from the missing index DMV that an index should or should not be created. It's just a place to start.
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
September 2, 2013 at 9:23 pm
Hmmm.......ok..........So you are telling me that this missing index dmv's are useless :w00t:.
September 2, 2013 at 11:46 pm
I would not call it useless. I personally like to have a look at the columns "user_seeks" and "last_user_seek". High numbers are an indicator that I should have a look at the queries that use this table, these queries might run slower than they could.
September 3, 2013 at 12:37 am
Shadab Shah (9/2/2013)
So you are telling me that this missing index dmv's are useless :w00t:.
No. I didn't say they're useless. I said they're a place to start.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply