SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cluster resource 'SQL Server' failed


Cluster resource 'SQL Server' failed

Author
Message
inevercheckthis2002
inevercheckthis2002
Old Hand
Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)

Group: General Forum Members
Points: 397 Visits: 485
While troubleshooting why a query failed on our SQL Server 2005 cluster, I note in the SQL Server log that SQL Server seems to have shutdown and restarted.

Looking at the System Event Viewer, I see that "Cluster resource 'SQL Server' in Resource Group 'Group 0' failed"

Prior to this, there are hundreds of entries about "There is insufficient memory to run this query."

How can I find out more? What can the root of the problem be?
Gianluca Sartori
Gianluca Sartori
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22987 Visits: 13362
Is this a SQL Server 2005 or 2008?
I'm asking because you posted in the 2008 forums but you said it's a 2005 instance.

However, if you have many insufficient memory errors, you probably have run out of memory.
Which operating system is it running on?
If it's windows 2008, you should have an entry in your event viewer for resource exhaustion, to confirm this diagnosis.

--Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
inevercheckthis2002
inevercheckthis2002
Old Hand
Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)

Group: General Forum Members
Points: 397 Visits: 485
It is SQL Server 2005 on Windows 2003 R2.

Sorry if I posted in the wrong place - I did not see a SQL 2005 High Availability topic, so I thought that it made the most sense to post here.
Gianluca Sartori
Gianluca Sartori
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22987 Visits: 13362
Ok, so no resource exhaustion event.
You should monitor the memory counters in Windows and see if they get too low.
If this is a SQL Server only box, you could lower the Maximum Server Memory configuration parameter.

--Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
inevercheckthis2002
inevercheckthis2002
Old Hand
Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)

Group: General Forum Members
Points: 397 Visits: 485
spaghettidba (5/5/2014)
Ok, so no resource exhaustion event.
You should monitor the memory counters in Windows and see if they get too low.
If this is a SQL Server only box, you could lower the Maximum Server Memory configuration parameter.

Both hosts in the cluster have 16 GB RAM - with AWE enabled.
I have the maximum server memory set to 13500.
Gianluca Sartori
Gianluca Sartori
SSC-Insane
SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)SSC-Insane (22K reputation)

Group: General Forum Members
Points: 22987 Visits: 13362
2,5 GB for the OS might not be enough.
Also consider that you're controlling just single page allocations with Max Server Memory. All other allocations are not included in that figure.
See here for details: http://blogs.msdn.com/b/sqlosteam/archive/2012/07/12/memory-manager-configuration-changes-in-sql-server-2012.aspx

--Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)SSC Guru (51K reputation)

Group: General Forum Members
Points: 51570 Visits: 17663
inevercheckthis2002 (5/6/2014)
spaghettidba (5/5/2014)
Ok, so no resource exhaustion event.
You should monitor the memory counters in Windows and see if they get too low.
If this is a SQL Server only box, you could lower the Maximum Server Memory configuration parameter.

Both hosts in the cluster have 16 GB RAM - with AWE enabled.
I have the maximum server memory set to 13500.

I would err on the side of caution and allocate less then ramp up, not the other way around. Try setting max mem to 10 or 11Gb initially.
Is this 64 bit or 32bit OS\SQL?
Do you have LPIM privilege granted to the sql server service account?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" ;-)
MMartin1
MMartin1
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6939 Visits: 2033
Try the default trace to see what ran prior to your reboot.

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/


----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search