April 13, 2009 at 2:38 pm
We have two servers, one is SQL SERVER 2005 and the other one is SQL SERVER 2008 and they have the same databases.each transaction is being applied to both Databases in SQL SERVER 2005 and SQL SERVER 2008.Today,we face a problem with our SQL SERVER 2008.The transaction in SQL SERVER 2008 failed(but it didnt fail in SQL SERVER 2005).The failure reason was 0x8007000e (E_OUTOFMEMORY). Is this kind of SQL SERVER 2008 problem.I mean has anybody face with OutOfMemory issue in SQL SERVER 2008.Actually in our SQL SERVER 2008 server we have 10GB RAM,which 7.5 GB is being used by SQL SERVER 2008 and we have 2.5GB free Memory also in C: drive ,we have 185GB freespace.
April 13, 2009 at 4:03 pm
First, please format your post into paragraphs so it's a bit more readable.
If it's a large transaction, it's possible that there are memory issues with that transaction. Adding more memory would help, but perhaps there's something else.
What is this transaction? What does it do?
April 14, 2009 at 9:47 am
Thanks.for your reply,but my question is:Is this a kind of bug for SQL SERVER 2008,Because as I said the same transaction did not fail in SQL SERVER 2005?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply