I am running NT 4 Enterprise Clustered Configuration Service Pack 6a. All latest Microsoft Hotfixes. SQL 7 with SP4 running Active\Passive configuration. I recently applied SQL sp4 and have now run into some real stabilty problems. It was running 2 years without a problem on sp2.

Recently the server has simply hung. Can not fail over or do anything when the problem occurs, simply power the machine off to recover. Now this has been happening in the middle of the night and i am on call all next week.

Each time the error occurs I get a DR Watson SQL Services exception and the machine hangs.

The connection method used is TCP/IP and clients connect to it using this method. The Default libary is TCP/IP.

The memory setting for the Server is set to dynamic

Otuput from the SQL error logs is as follows:

2003-10-05 02:16:52.88 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C29C0
2003-10-05 02:36:40.99 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C2780
2003-10-05 02:36:40.99 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C3AE0
2003-10-05 02:36:41.13 logon Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
2003-10-05 02:36:41.25 kernel LogEvent: Failed to report the current event. Operating system error = 1722(The RPC server is unavailable.).



2003-10-03 15:19:36.19 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C0E30
2003-10-03 15:22:44.23 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C1180
2003-10-03 15:22:44.23 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C3D80
2003-10-03 15:22:44.23 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x01893FA0
2003-10-03 15:22:44.38 logon Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
2003-10-03 15:22:44.40 kernel LogEvent: Failed to report the current event. Operating system error = 1722(The RPC server is unavailable.).
2003-10-03 15:36:43.92 ods Error: 17803, Severity: 17, State: 17
2003-10-03 15:36:43.92 ods Insufficient memory available..
2003-10-03 15:36:44.39 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:36:44.39 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:36:44.39 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C0C20
2003-10-03 15:36:44.39 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:36:59.53 ods Error: 17803, Severity: 17, State: 17
2003-10-03 15:36:59.53 ods Insufficient memory available..
2003-10-03 15:37:15.14 ods Error: 17803, Severity: 17, State: 17
2003-10-03 15:37:15.14 ods Insufficient memory available..
2003-10-03 15:37:30.75 ods Error: 17803, Severity: 17, State: 17
2003-10-03 15:37:30.75 ods Insufficient memory available..
2003-10-03 15:37:44.40 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:37:44.40 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:37:44.40 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C0C20
2003-10-03 15:37:44.40 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:37:46.37 ods Error: 17803, Severity: 17, State: 17
2003-10-03 15:37:46.37 ods Insufficient memory available..
2003-10-03 15:38:01.98 ods Error: 17803, Severity: 17, State: 17
2003-10-03 15:38:01.98 ods Insufficient memory available..
2003-10-03 15:38:44.40 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:38:44.40 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:38:44.40 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:39:44.42 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:39:44.42 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:39:44.42 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:39:44.42 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:40:44.42 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:40:44.42 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:40:44.42 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:40:44.42 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:41:44.44 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:41:44.44 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:41:44.44 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:41:44.44 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:42:44.44 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:42:44.44 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:42:44.44 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:42:44.44 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:43:37.56 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:43:37.56 ods Insufficient memory available..
2003-10-03 15:43:44.47 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:43:44.47 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018C09B0
2003-10-03 15:43:44.47 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:43:44.47 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:43:54.17 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:43:54.17 ods Insufficient memory available..
2003-10-03 15:44:10.78 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:44:10.78 ods Insufficient memory available..
2003-10-03 15:44:29.72 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:44:29.72 ods Insufficient memory available..
2003-10-03 15:44:44.48 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:44:44.48 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:44:44.48 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0
2003-10-03 15:44:46.34 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:44:46.34 ods Insufficient memory available..
2003-10-03 15:45:02.95 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:45:02.95 ods Insufficient memory available..
2003-10-03 15:45:19.56 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:45:19.56 ods Insufficient memory available..
2003-10-03 15:45:36.17 ods Error: 17803, Severity: 17, State: 14
2003-10-03 15:45:36.17 ods Insufficient memory available..
2003-10-03 15:45:44.48 ods The Scheduler 0 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D2690
2003-10-03 15:45:44.48 ods The Scheduler 1 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D09F0
2003-10-03 15:45:44.48 ods The Scheduler 2 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D3190
2003-10-03 15:45:44.48 ods The Scheduler 3 appears to be hung. PSS 0x00000000, EC 0x00000000, UMS Context 0x018D14F0


Now i have tried limiting the memory to a fixed value of 1200MB.

Not had much sleep this week. Any ideas guys??? Will see if the memory changes have any effect tonight??