My 1st Blog – out of memory exceptions in SSDT… yes its technical

When unit testing a stored procedure in visual studio 2012 (SSDT); sometimes you can get a out of memory exception (especially if you’re retrieving over 1 million rows+). To resolve this, go to the TEST\Test Settings\Default processing Architecture menu and select ‘X64’, this will give you a massive increase in memory usage with in Visual Studio and testing.

.1stBlog

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s