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 |
|
SarahBenjamin
Starting Member
4 Posts |
 Posted - 2009-05-01 : 14:25:28
|
| Hi I am running data warehouse stored procs on SQL 2008 and after a while I get this error messageAn error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown.If I run teh exact same process on Sql 2005, there is no such message taht comes..There is a lot of data and lots ofprocessing going onHow can I take care of this.Thanks-Sarah |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-05-01 : 19:57:06
|
maybe there is more data on the 2008 server you are fetching.are you loading into a datatable/dataset? those things are memory pigs.
elsasoft.org |
 |
|
|
SarahBenjamin
Starting Member
4 Posts |
Posted - 2009-05-18 : 12:27:54
|
| Actaully its the same amount of data when ran from SQL 2005. Everything is the same as far as the stored proc, data goes. Just one is running on SQL 2008 and other on SQL 2005.More thoughts, comments!Its still not resolved.Thanks-Sarah |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2009-05-18 : 13:39:20
|
| Are SQL 2005 and SQL 2008 on the same physical server or different servers? Are they configured the same way for available memory?--------------------------------------------Brand yourself at EmeraldCityDomains.com |
|
|
|
SarahBenjamin
Starting Member
4 Posts |
Posted - 2009-05-20 : 14:50:26
|
| No they are two different machines and memory is 8 GB for the one that those jobs are running fine adn 4 GB for this new machine that we are trying to run the same jobs. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-05-20 : 21:36:50
|
do you know whether the exception is being thrown on the server or the client? Is the proc you are calling a CLR proc, or does it call a CLR proc?
elsasoft.org |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2011-04-12 : 09:22:55
|
| I've got this error also in a simple SELECT * FROM MyTable WHERE Field1 = 1 in Management Studio.Where I have to investigate? Luigi |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-04-12 : 09:45:44
|
| show us the sproc. also run a profiler trace and what does it tell youIf you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Out of Memory exception in SQL 2008