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.
| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-08-24 : 16:22:08
|
| Hi All,I have configured a Maintenance Plan of 25 steps it was running fine but later I got an error stating that at step 22 it’s getting revoked as “There is insufficient memory available in the buffer loop”. I’m unable to get what does it mean and why I got this error.Could any one help me about this error and more over where can I monitor step by step job activity when the maintenance job is going on?Thanks in advance. |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-08-24 : 23:08:09
|
| How did you come up with 25 steps for maintenance? My guess is you have way too many steps and the system is running out of memory to run all of them.In any sub-plan, for any maintenance plan - I have at most 6 steps. Not sure how you came up with 25 steps or what each step is actually doing - but that sure sounds like something is wrong.Jeff |
 |
|
|
manju3606
Yak Posting Veteran
78 Posts |
Posted - 2011-08-25 : 06:07:53
|
| Hi,Jeff is right, and ( “There is insufficient memory available in the buffer loop”") it means you don't have sufficient memory for your sql server 1.check your sql server memory if you have configured any min or max memory 2.if you are not configured min and max memory then check awe is enable or not if that disable then enable that.Only when you have more then 4Gb ram in your system 3.check your physical memory. If you have more then 4gb ram then check PAE is enable or not if that not enabled then enable that.This for only 32 bit system Manju |
|
|
|
|
|
|
Maintenance plan