The CXPacket block is caused by parallel processing. One thread in the process is waiting for another to complete, typically reads. What are the DISK performance counters like?

Some DBAs...

MIJ (7/12/2010)

---

But w/ respect to changing the fixed port number to somethign "nice and high" (rather than the default, presumably) isn't that sort of "security by obscurity"? I mean...

This is actually a really important and serious question, and here is some more for you to consider.

Disabled the SQL Browser also adds a layer of security. The browser does...

As a general rule I wouldn't put user functions into the master database. As soon as you upgrade you need to recreate everything. A more reliable and consistent option is...

I've recently had to support a 4 node cluster (all active) that was built and still is being built using your plan of adding nodes over time. In general administration...

This appears to be a fairly standard and simple update. A few questions I have is: Are any of the columns in the WHERE clause indexed? Particularly the first columns....

You may find this article handy

http://www.sqlservercentral.com/blogs/sqldbauk/archive/2010/06/25/lock-pages-in-memory.aspx

Leo

Ian Godfrey (7/9/2010)

---

If the AD account is deleted later the login is 'orphaned'. Then the SQL agent jobs stop working, and there are problems creating new tables etc...

Actually I remember going over this rercently and then when I replied to the post my brain search algorithim crashed and all it could find was the bit about log...

Jeffrey Williams-493691 (7/6/2010)

---

Leo, I believe you don't have to use a different filegroup to add a file on a different LUN. You can have multiple files per database -...

Switching to SIMPLE mode may not resolve your issues. SIMPLE mode only means the log space is made available for reuse after a transaction is committed. If you are reindexing...

To cycle the log you need to create a SQL Job that runs daily (like just after midnight) and runs the sp_cycle_errorlog stored proc.

To set the number of files to...

SQL doesn't have any way of directly addressing the SAN.

You would need to create multiple file groups, at least 2 so you have one on each LUN. And you would...

Are these AMD chips by any chance?

I know there is some technology that messes with the way SQL 2005 tracks time. This is typically AMDs Quite 'n Cool technology. I've...

After starting the select or delete have you done an sp_who2 from another MS conection to see if there is any blocking?

This is the most likely cause.

Leo