Without code it's hard to know what's happening, but if you're loading data into a temp table and then locking it in a second step, there's your problem. You need...

I'm not sure I'd compare Spotlight & Diagnostic Manager directly. Yes, both show you real time measurements of server performance, but DM also keeps historical information so that you can...

Logical order is the ordering of the index. Let's assume an index based on last name. The logical order would be:

Adams

Johnson

Smith

Williams

But, due to page splits, insertions, deletes and the other...

vaidehi.rajamani19 (10/27/2009)

---

Thanks for the response. We are using JMeter to find the response of the site.

But the client requirement is to find the percentage of time taken for DB to...

Feel better Barry.

Jeff Moden (10/26/2009)

---

Crap... I can say "crap" on this post, right? Crap, crap, crap... it's happened again same as last year and for the same reason. Started a...

Nuts, sorry to hear it.

I just started on the "good" plan, and it's all scans, not a seek in the process. There's missing index information:

/*

Missing Index Details from Clarks Unique Orders @ 26-OCT-2009 good.sqlplan

The...

Even before I look at the execution plan, why are you doing this instead of an equals?

s.CampaignID IN (53)

huston.dunlap (10/26/2009)

---

I feel I have learned enough SQL to start really looking at the optimization of my queries. One thing I have found hugely successful so far is breaking down...

Best thing you can do is get the actual execution plan for a good performing version and a bad performing version. The differences between the two are where the problems...

There are a lot of ways you can do it and a lot of different types of performance tests. Are you trying to do a performance test based on the...

Excellent introduction. Nice job Gail. Couldn't ask for better.

For an execution plan that large, a complete break-down and set of recommendations would become billable...

sarvesh singh-457805 (10/24/2009)

---

Thank you Grant for your response.

I did run sp_updatestats to update the statistics. Do i have to update the statistics again. As far as missing index is concerned...