June 1, 2005 at 2:21 pm
Hi All,
I have this strange problem. Indexes in some of my tables got dropped sometimes that I had no clues why it happened that way. Please someone give me some ideas to track down the causes for this kind of problem. I talked to developers, and none of them had any statements run against the database that specifies dropping indexes at all. Thanks a lot.
Minh
June 1, 2005 at 3:35 pm
I would run a trace to track this down.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 2, 2005 at 9:37 am
I tried, but if the indexes dropped, the queries run a lot longer that can take 100% of CPU. Therefore, when I turn on a trace, it even lows down the server performance more, which prevents other users have time out issue when they try to execute any queries.
Minh
June 2, 2005 at 12:03 pm
1) First do a quick scan of syscomments checking for any drop index command. For example, select * from syscomments where text like '%drop%'
2) Create a stored procedure to check sysindexes for the missing indexes. Create a log of this information to try to track down a time of when this is happening. See if there is any pattern to when the index disappears.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply