Check out http://www.microsoft.com/sqlserver/2008/en/us/spotlight-on-cost.aspx for some information.

I would also happily mention that ROI will be instant the first time that you have an issue bearing in mind that you won't get...

Take it step by step. You've gone through things pretty well so far.

Eliminate one component at a time until you find the culprit.

Check that the AV is the latest version...

Take a look at http://support.microsoft.com/kb/918992. This works in 2008 as well as 2005.

J-F Bergeron (4/22/2009)

---

Ok, thanks guys for the link, I started reading the document, and it looks really interesting. I'll have probably have...

This could be an indispensable guide for interviews 😀

http://www.howtonailaninterview.com/%5B/url%5D

There are some awesome docs and whitepapers from Microsoft folks out there, the trouble is that they are almost impossible to find.

Wish they could have some kind of central repository...

There's a really great document on the SQL Server 2005 Best Practices page http://technet.microsoft.com/en-us/library/cc966413.aspx (Direct Document Link: http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc) This docs a keeper.

Indications are from that really it comes...

Just going by the comparisons that are shown there it appears as though the disk on the new machine is not as fast as on the old (or there is...

Can you compare those to another machine that is having better performance?

oops, sorry

DBCC SQLPERF(WAITSTATS, CLEAR);

Now can you run it against the other machine and see where there's a difference.

Free up the buffer cache and the proc cache and buffer cache

DBCC FREEPROCCACHE;

DBCC DROPCLEANBUFFERS;

Run your query, then look at the wait stats (this is a very basic version, but can...

Is there a difference in the execution plans on each machine? Also, have you checked the stats and what your major wait times are on the second server? You might...

Steve Jones - Editor (4/20/2009)

---

I think asking questions to better define a situation is a great response. As the interviewer, if you start answering, I start thinking "assumptions" and wondering...

That's on a par with a guy testing the sprinkler system who found out that his partner hadn't shut down the flow to that head....many thousands of gallons of water...