How do you use cloud databases? Take the survey.
Does sql monitor sometimes give the wrong query plan?
We have a situation where we applied some new indexes. We then ran our load test and I ran sql profiler as well. When I look at the query plans for the query in sql profiler, I can see that it is using the new indexes. However when I go to sql monitor (overviews, set the time window, top 50 queries, the query plans picked up there show it is not using the new indexes). Is it possible sql monitor is not picking up the right plan? sql profiler would definitely give me the correct plan, wouldn't it?
0 · Share on Twitter