Friday, March 9, 2012

Error moving sql server resources

Hi,
I am having a problem when I try to move resource (sql server service) from
one group to another. Moving other resources works fine but not SQL. I have
two SQL server s 2000 sp3a on two win 2003 servers on an active/passive
mode.
I got two error messages:
"Cluster resource SQL Server (inst01) timed out. If the pending timeout is
too short for this resource, consider increasing the pending timeout value"
"Cluster resource 'SQL Server(insto1)' in Resource Group "GroupSqlServer"
failed"
Any idea why this happen?
many thanks,
Miguel
So, you are running two instances on a single node, using the second node
merely as a warm standby server?
May I ask how much memory you have installed on this system and how much is
allocated to each SQL Server instance?
Also, are you using AWE configuration?
A couple of things, when you move resources, you are telling SQL Server to
come offline. It must checkpoint the system. If the system is active,
there will be a lot of dirty data pages that must be flushed to stable
media. Furthermore, if you are running AWE, then when SQL Sever comes
offline, not only do dirty data pages must be flushed, SQL Server will also
"zerro-out" the AWE memory as well. If this of any appreciable size, this
will also take some additional time.
To fix the problem, increase the Pending Timeout value in the SQL Server
cluster resource to avoid the failure. Basically speaking, this is normal
activity for a large and/or busy system.
FIX: The SQL Server cluster resource may be marked as Fail when you try to
take it offline
http://support.microsoft.com/default...b;en-us;834923
AWE-Enabled SQL Server 2000 May Take a Long Time to Start
http://support.microsoft.com/default...b;en-us;329914
Sincerely,
Anthony Thomas

"Miguel Henriques" <miguel.henriques@.gmail.com> wrote in message
news:ODkeXTgvFHA.1560@.TK2MSFTNGP09.phx.gbl...
Hi,
I am having a problem when I try to move resource (sql server service) from
one group to another. Moving other resources works fine but not SQL. I have
two SQL server s 2000 sp3a on two win 2003 servers on an active/passive
mode.
I got two error messages:
"Cluster resource SQL Server (inst01) timed out. If the pending timeout is
too short for this resource, consider increasing the pending timeout value"
"Cluster resource 'SQL Server(insto1)' in Resource Group "GroupSqlServer"
failed"
Any idea why this happen?
many thanks,
Miguel

No comments:

Post a Comment