February 2, 2009 at 2:41 pm
Hello!
Our server, SQL Server 2005 Standard 32-bit on Windows Server 2003 R2 with 4GB, is experiencing problems. At some random point, CPU goes above 90% and server becomes unusable. I come across following errors in the log right before CPU comes to a stall:
...
2008-12-21 21:20:20.36 spid262 Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824
2008-12-21 21:20:20.42 spid262
Memory Manager
VM Reserved = 1779104 KB
VM Committed = 1681860 KB
AWE Allocated = 0 KB
Reserved Memory = 1024 KB
Reserved Memory In Use = 0 KB
2008-12-21 21:20:20.42 spid262
...
2008-12-21 21:20:20.59 spid262 Error: 701, Severity: 17, State: 123.
2008-12-21 21:20:20.59 spid262 There is insufficient system memory to run this query.
...
Currently, we do not have /3GB switch enable. It looks to me that CPU issues are result of aforementioned errors.
I did disable CLR integration and disable a couple of maintenance jobs (index and database integrity checks) as some people mentioned this could be a culprit, but problem still there.
I am going to add /3GB switch to make SQL Server use more memory.
Any advice on this matter is greatly appreciated.
Igor
February 2, 2009 at 3:22 pm
Hi Igor,
We need to see when the problem appeared and more background, is it a misconfiguration, or a result of bad code being sent to the server, this could be for any number of reasons from a process external to sql server through to excessive recompilations...
Mike
February 2, 2009 at 3:28 pm
mikefle (2/2/2009)
Hi Igor,We need to see when the problem appeared and more background, is it a misconfiguration, or a result of bad code being sent to the server, this could be for any number of reasons from a process external to sql server through to excessive recompilations...
Mike
I am trying to figure it out myself 🙂 By the way this SQL Server 2005 SP2 (9.00.3073.0). I have disabled all jobs I thought might have caused this problem (DBCC CHECKDB, etc.).
Thanks,
Igor
February 2, 2009 at 4:44 pm
Are you using linked servers or OLE Automation (sp_OACreate) on that server?
February 2, 2009 at 5:13 pm
Todd Engen (2/2/2009)
Are you using linked servers or OLE Automation (sp_OACreate) on that server?
Linked servers - yes, OLE Automation - no.
February 2, 2009 at 5:55 pm
What providers are being used for the linked servers?
February 3, 2009 at 4:42 pm
Todd Engen (2/2/2009)
What providers are being used for the linked servers?
Only Microsoft OLE DB Provider for SQL Server
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply