March 1, 2011 at 7:07 am
Hello,
When my maintance plan was running for Reindex, my sql agent went down and error message in logs:
There is insufficient system memory to run this query.
Do I need to add more Ram? Thank you
March 1, 2011 at 7:11 am
You are definitely suffering from memory pressure. Hard to say beyond that with the information you provided though. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 7:18 am
I have 4GB of RAM, windows , enterprise edtion service pack 2.
SQL server 2005 service pack 3, what else you need? How can I find out how much more RAm I need to have enough, I don't know how much space reindex job takes,how to find out?
March 1, 2011 at 7:21 am
Is it a 32 bit or a 64 bit ?
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server
March 1, 2011 at 7:27 am
32
March 1, 2011 at 7:31 am
And how do you have memory configured? min server memory and max server memory? You don't really have much headroom on there so you really can't change too much.
Did the reindex job fail or was another query the one that suffered the out of memory condition?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
March 1, 2011 at 7:36 am
And how do you have memory configured? min server memory and max server memory?
min:250
max 2147483647
AWE is checked
You don't really have much headroom on there so you really can't change too much.
What is your recomendation?
Did the reindex job fail or was another query the one that suffered the out of memory condition?
Reindex job didn't fail, it was running and sql agent stopped. I was running this job in small portions, I have like 25 databases and I was running at that time for 3 db only
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply