Hey all! I am fairly new using sql. I have been put in charge of managing our sql2005 databases. Currently we are having some deadlocking issues. I turned on the trace flag 1222 and found a couple of queries that were deadlocking, I ran both through the DTA. One was a SP and the other was a ad hoc, I copied the queries from the trace flag output into the dta, after receiving a few errors the queries went through...one at a time of course. The first one show nothing but the second query show that it needed to create about 9 indexes and 50 some odd statistics. I just couldn't believe it. Does this sounds right to anyone? Please let me know if you need more detail.
thanks,
Have you checked the current queries execution plan for such slower performance.
What is the index strategy on this table?
DTA one way its good and one way you should be cautious about what its referring, without performing any tests there is no such straight solution.
No comments:
Post a Comment