Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OUt of memory Expand / Collapse
Author
Message
Posted Wednesday, November 13, 2013 2:50 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 6:31 AM
Points: 215, Visits: 444
I have a development 2012 instance that is used for testing. After running IS packages to populate a data warehouse I am unable to remote desktop to it and SQL gives out of memory errors.

I did load SP1 and SP1 CU2. Is this a SQL bug (wouldn't be surprised) or should I search elsewhere.



>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I see stupid people
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Post #1513755
Posted Wednesday, November 13, 2013 6:23 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 1:17 PM
Points: 4,474, Visits: 6,407
There are indeed memory leaks in SQL 2012 SP1+. I don't know that your dev box would be open to them tho.

Did you set the max memory for SQL Server? That is a MANDATORY setting. Also, I would consider bouncing the ssis service just in case that wound up eating too much memory.

And what else is running on the box?


Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1513836
Posted Wednesday, November 13, 2013 10:53 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 6:31 AM
Points: 215, Visits: 444
Hi

I found the problem. I changed to a new blade(all new hardware) and now the problem does not come up anymore. I did not test what it was exactly but the last error I got on that server was for memory parity so I presume it was memory or motherboard.


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
I see stupid people
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Post #1514146
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse