Nice post Colin.

Yes, the DBA needs input on SAN setup/configuration if you desire optimum performance. However, the DBA needs to be knowledgeable to be able to provide...

Did you do a full update of all indexes/statistics after the upgrade? This is mandatory when moving databases from 2000 to 2005.

1) use nolocks to avoid blocking situations during the day. note there are issues with this giving 'bad' data.

2) if you do put it in a sproc and use...

1) what stripe size did you use for the RAID set?

2) you should use diskpart to force sector alignment of the NTFS partition.

Both of these carry significant performance...

I will once again agree with Jeff on this one - I too have seen exactly the same situation before.

Nicely done Jeff! The graphics will really help even neophyte SET-BASED devs to understand what is really going on.

1) Build your own recording mechanism which inserts records from sysprocesses or one of several DMVs on a scheduled basis and do analysis on that table over time.

2) Set up...

GilaMonster (12/4/2007)

---

I've seen worse. 38 indexes on...

Oh, one thing I forgot to mention. Just because DTA doesn't suggest any improvements, do NOT assume "that the index strategy is suitable". I personally have very little...

Not sure if I interpreted the message correctly but it seems like they are having a low cache hit ratio, which is generally indicative of either too little memory or...

I have a GREAT idea - don't shrink the file!! There are lots of bad things that come from this, and in this case nothing good that I can...

1) What possible need can there be for attempting to return 42M rows to the client?

2) Table scans are not necessarily a bad thing - especially in a...

The best thing you can do is to hire a professional to give your server/applications/databases a performance review. Amazing return on investment - no only in the performance of...

jbrewer (11/29/2007)

---

Thank you very much for your help. I did not know there was a problem with hyperthreading. Can you point me to a document concerning hyperthreading and...

Kevin Boles. Glad to meet you. You must be Jeff Moden, right?? 😉

BTW, do you LIVE on this forum or something?? I needed the link to...