Viewing 9 posts - 1 through 10 (of 10 total)
The issue has been resolved by shutting down the service and restarting it on the same node. I am trying to figure out why it happened. I could not find...
crasc
August 30, 2005 at 9:06 am
The server experienced a scheduler problem with error 17833 and initiate a service restart. Per our configuration in the cluster admin, SQL will attempt to restart 3 times prior to...
crasc
August 30, 2005 at 2:10 am
Currently, Windows 2K SP4 and SQL 2K Ent - SP3a_997 (997 hotfix was added to resolve High Query Execution Plan management)
crasc
August 29, 2005 at 11:21 am
You need a tool that keeps track of your availability and registers it somewhere. Where I am we use FOGLIGHT from Quest. The SQL Agent has a table called Availability. ...
crasc
August 26, 2005 at 5:20 pm
Nothing in the Windows log.
The SQL log has the following entry:
2005-08-20 22:12:59.97 spid1 Warning: unable to allocate 'min server memory' of 6147MB.
Thanks
crasc
August 26, 2005 at 10:33 am
Find out which one of %Disk Write Time or %Disk Read Time is higher? This will indicate the type of operation that keeps spinning your disks.
How are any applications accessing your...
crasc
August 26, 2005 at 12:36 am
August 26, 2005 at 12:22 am
What are your settings for min and max memory?
You could try to set you Min as close to 2.0 gb and your max at 2.0 gb and make sure the...
crasc
August 26, 2005 at 12:07 am
Have you looked into the Cluster Log in C:\WINNT\Cluster\cluster.log
You will find a log in each server.
crasc
August 25, 2005 at 11:46 pm
Viewing 9 posts - 1 through 10 (of 10 total)