Red Gate forums :: View topic - Out of Memory Exception on SQL Data Compare 9
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Compare Previous Versions
SQL Data Compare Previous Versions forum

Out of Memory Exception on SQL Data Compare 9

Search in SQL Data Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
smanning



Joined: 28 Feb 2012
Posts: 3

PostPosted: Tue Feb 28, 2012 2:57 pm    Post subject: Out of Memory Exception on SQL Data Compare 9 Reply with quote

I am running on a Windows 2008 R2 64 server with 4 GB of RAM. The RBTemp variable is set to the D drive which has 600GB of free disk space. I am comparing two databases (about 200GB each) on SQL 2008 and there are some varbinary fields, but they are all very small (less than 50K) in size. I am using version 9.1.0.365 of the SQL Data Compare tool
When I run the project via the GUI interface the project runs perfectly. But when I run the same project via the command line using the /project and /export parameters, I get the following error
Registering databases
Mapping
Comparing databases
Error: Exception of type 'System.OutOfMemoryException' was thrown.

I do not see any errors in the event log.
Can you let me know how I can resolve the memory problem when running the tool via the command line?
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Tue Feb 28, 2012 6:39 pm    Post subject: Reply with quote

Thanks for your post.

In theory there shouldn't be any difference as they're using the same engine.

Can you make sure you're using the exact same options in both the UI and the CL?

Just to make sure, the environment variable you need to set is RGTemp (I'm assuming RBTemp was a typo in your post)

SQL Data Compare really shouldn't be throwing OOM exceptions anyway, so could you check the SQLDataCompare process in task manager and see what it gets to before the OOM is thrown?
_________________
Chris
Back to top
View user's profile Send private message Send e-mail
smanning



Joined: 28 Feb 2012
Posts: 3

PostPosted: Tue Feb 28, 2012 9:56 pm    Post subject: Out of Memory Exception on SQL Data Compare 9 Reply with quote

I did miss type the env variable. It is rgtemp.

I ran the process explorer for both the console and GUI running exactly the same project and the console memory utilization just kept going up to 1.6 GB when it died. The GUI run kept the memory at about 95MB. I took screenshot of both runs and can email them to you if you want.

On the options, I am using the default options for a project. I selected about 200 tables and of a few of the tables, I unselected a column that should not be used in the comparison. The column was a “last modified” field which would never be the same between the respective tables.

For the console run, I am using the “project” parameter and pointing it to the same project that I am using in the GUI version.
Back to top
View user's profile Send private message
smanning



Joined: 28 Feb 2012
Posts: 3

PostPosted: Tue Feb 28, 2012 10:03 pm    Post subject: Out of Memory Exception on SQL Data Compare 9 Reply with quote

One more piece of information. Using the process explorer the counts for generation 0,1,2 heaps are the follow
Gen 0 heap size 5,242,880
Gen 1 heap size 22,940
Gen 2 heap size 1,348,823,532
Large Object Heap Size - 318,120,552

It does look like a memory leak in the console part of the app.
I can email you the project if that would help.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group