Insufficient System Memory Issue [SE]

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Insufficient System Memory Issue [SE]

Author

Topic

elayaraja_apd
Starting Member

9 Posts

Posted - 2010-03-18 : 00:25:34

Hello,

Last week one of our sql server 2000 gone to insufficient system memory. Due to this our log shipping also failed.

After reboot the server, it was ok.

Now again today the same issue happen.

Can anyone help on this?

Thanks for an advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-18 : 00:27:02

The error is clear. You need to add more memory to your system.

Are you running service pack 4 for SQL Server 2000? Show us the output of SELECT @@VERSION.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-18 : 00:57:36

also, is SQL Server the only application running on the box?

elayaraja_apd
Starting Member

9 Posts

Posted - 2010-03-18 : 03:25:44

This is our version

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

elayaraja_apd
Starting Member

9 Posts

Posted - 2010-03-18 : 03:29:19

Yes, Only SQL Server application is running.

quote:
Originally posted by russell

also, is SQL Server the only application running on the box?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-03-18 : 11:04:45

how much RAM do you have? What is max server memory set to? What was exact error when log shipping failed?

elayaraja_apd
Starting Member

9 Posts

Posted - 2010-03-29 : 01:08:42

1. We have 8 GM of RAM.
2. Set dynamic sql server memory
3. [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 701: [Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient system memory to run this query.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP LOG is terminating abnormally.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-29 : 13:43:58

If you are getting this message on a BACKUP LOG event, then you've got performance issues on the server that need to be addressed. Perhaps 8GB is not enough for your system. What edition of SQL Server 2000 are you using?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

elayaraja_apd
Starting Member

9 Posts

Posted - 2010-03-30 : 01:32:24

I don't think we need to add more memory. 8GB is sufficient. Because Last couple of years we never had any problem. Recently we have installed antivirus in this system. I feel after that only it is causing some issues.

We are using SQL Server EE edition.

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Note: Current impact is backups are failing and secondary servers are not sync.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-30 : 01:39:05

Do you have all of this set properly?: http://support.microsoft.com/kb/274750

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

elayaraja_apd
Starting Member

9 Posts

Posted - 2010-03-30 : 02:19:22

Yes, We have set all in advanced.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2010-04-07 : 22:39:15

How much Memory SQL Server is using? Have you set AWE/PAE to allocate more memory for SQL Server?