MS03-031 Urgent

From: Mateo (m_leija_at_hotmail.com)
Date: 10/27/03


Date: Mon, 27 Oct 2003 12:54:27 -0700

We've installed MS03-031 on several SQL server 7 SP4 and 2000 SP3 production
instances running on both NT4 and W2K. We applied the HotFix on NT to
resolve the connection errors, but other than that we've haven't experienced
any issues. Last nite we installed the patch on our most critical high
volume production server and begain experiencing performance issues this
morning. We're seeing a high number of queries running over 2 secs, with
many taking over 20 seconds to complete and some over a minute. Normally we
see a few taking several secs, but not nearly this many. Because of this,
we're experiencing ODBC timeouts. The CPU (4x) on the server is running
50-100%, but there's little paging to the swap file. Several queries are
showing wait times with a 'CXPACKET' wait type.

Is anyone else experiencing this type of behavior? Feedback on this issue
would be appreciated. Thanks in advance.

~Mateo