CODEWITHSUNDEEP
sql-servermemoryram
ana ng
ana ng

Reputation: 107

Increasing max server memory to deal with System.OutOfMemoryException on SQL Server

I am not very experienced so please bear with me.

I have been attempting to import a 2500 MB and 3800 MB CSV into SQL Server 2016. Unfortunately I keep getting the System.OutOfMemoryException error. My computer has 8.00 GB RAM so I figured I would just increase the max server memory from the default up to 4000 MB. For some reason though each time I try to change the max server memory to make it higher it changes back to default. How do I fix this problem?

Upvotes: 0

Views: 181

Answers (1)

Mehrad Eslami
Mehrad Eslami

Reputation: 306

You can change it with :

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'max server memory', 4096;  
GO  
RECONFIGURE;  
GO

Upvotes: 1

Related Questions