Insufficient Memory to continue the excution of the program

Question

Insufficient Memory to continue the excution of the program

balajisrm

Right there with Babe

Points: 723
More actions
September 8, 2010 at 12:58 am

#141720

For the past 1 week am facing his error in my Sql Server . Insufficient Memory to continue the excution of the program . It gets resolved when i restart the SQL Server Service . I cant find the in which case this error is occuring .

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

is this error you getting in some of your scheduled job and running queries?

If its on running queries then have you checked the bandwidth limitation with the server as well either the server is same domain or in different?

----------
Ashish

balajisrm Right there with Babe Points: 723 More actions · Answer 2

sir , i think it occurs on running queries only . i cant understand abt what you are meaning by domain . For your info , We have two 4 database servers . but we are facing this problem in only one Server which is a 64 bit server . Other 64 bit and 32 bit servers does not face any problem . The other Servers are also running on same Bandwith only .

crazy4sql SSCoach Points: 19590 More actions · Answer 3

1) Do you have disk space issue on that server?

2) Is the issue you gwetting on a specific query or any simple select statement as well?

3) Which version of sql server you have?

----------
Ashish

balajisrm Right there with Babe Points: 723 More actions · Answer 4

we are using SQL 2005 (64 Bit )Enterprise Edition . On thing i found was , Actually we are restoring a Database daily from our production Server to this server (Which is facing the problem as of now) which size is 86 GB . When i click Properties of Server it shows Size as 16 GB . But when i view the restored databse size it show a 86 GB . does this make any problem .

crazy4sql SSCoach Points: 19590 More actions · Answer 5

First of all why you are restoring database daily? You can configure log shipping for this or mirroring.

Also I am not able to understand what you mean by server size is 16 gb.

----------
Ashish

balajisrm Right there with Babe Points: 723 More actions · Answer 6

Actually this a reporting server . so to view reports we restore the production database from Production database to Report Server Daily . This is done to improve the performance of Prodcution Server and also we develop some simple applications in this Report Server for our MIS needs .

crazy4sql SSCoach Points: 19590 More actions · Answer 7

you can still do it by using log shipping. As its mainly used for reporting, it means database can be set to read only on secondary server and log can be restored on secondary server with every 10/15/20...... min of interval..

----------
Ashish

balajisrm Right there with Babe Points: 723 More actions · Answer 8

yes i have read this , but i dnt know hw to do it . but i will do it and tell you . will this be the reason for this error i have mentioned above . 16 GB i have mentioned is in SSMS when we right clickt the server name and go to Properties it will show Memory as Some xxxxxx MB. tats what i have mentioned .

crazy4sql SSCoach Points: 19590 More actions · Answer 9

restoring 86 gb on the server with 16gb of RAM should not be problem if, scheduled at the correct time when server is idle.

----------
Ashish