Index
-
all of a sudden I have found there are indexes missing for a production table which never happend before, what would be the reason and how can find the reason ?
-
How did you discover the indexes were missing in the first place?
-Grant Roles
-
Were the indexes removed or are you referring to "missing indexes" reflected in query plans or sys.dm_db_missing_index_details ?
Converting oxygen into carbon dioxide, since 1955. -
i believe the DDL statement DROP index would be captured in the default trace;
you can use the GUI filtered version and find out whodunnit if not too much time has passed:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
I looked at the schema change history but got only changes what i have made today (create index) but i did rebuild indexes month ago which is done from an automated jobs (rebuilds/re organize as per gragmentation level ), do you think that might caused to drop them ? but actually its a schduled job which run every month and wondering why it happend only last month which never happend before since a year.
-
Tara-1044200 (6/22/2010)
i did rebuild indexes month ago which is done from an automated jobs (rebuilds/re organize as per gragmentation level ), do you think that might caused to drop them ?in that case job would have been got failed.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
nope, the job was successfull.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply