Index Operational Stats

Question

Index Operational Stats

manodak

SSC Enthusiast

Points: 186
More actions
August 20, 2010 at 6:17 am

#222767

Does a rebuild of a clustered index reset the DMS table values?
I'm tracking a thrid party application and the insert values on a particular table suddenly went from 23,000 to 63, without a clearing the stats or a restart. The Vendor has access to the box, but shouldn't ever mess with the stats.
Thanks in advance for any replies
Mark

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

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

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

Shouldn't

Dropping the index will remove that index from the DMV, but shouldn't clear it. Taking the DB offline, closing it, detaching it, restoring it will all reset that DMV.

Did they rebuild or drop/create the index?

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

manodak SSC Enthusiast Points: 186 More actions · Answer 2

My normal processes will do a rebuild or reorg, but not a drop and recreate.

This application (from a significant vendor in a niche market) is the absolute worst use of SQL Server I've seen in 25 years in the business, so I'm very mistrusting of the Vendor. The program manager has to allow them access to the actual database because after only 10 years of developing the app, it still requirers manual data corrections within the database.

Thanks for your reply

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

Maybe try running a trace, see what's happening.

Is autoclose enabled?

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

manodak SSC Enthusiast Points: 186 More actions · Answer 4

Autoclose is disabled. Unfortunately the vendor's front-end connection pools, all this the same login name. I appreciate your answer, since it appears that nothing I control would have caused it. If they messed with it, at least they didn't change the cluster to their standard idea of a cluster (which we have changed) of multi-columns, at least one of which is a status field with values that change. Very knowledgable SQL people.