scom 2012 sql server out of memory

Question

HI,

We just recently deployed scom 2012

and today the sql server is reporting (sql 2008 r2)

event id 6532 source mssqlserver .net frame work is out of memory,

with that we could not connect to none of the mangement servers.

a reboot of the sql server solved the problenm but it looks like SQL is taking all the resources

Answer 1

Is the SQL Server 32-bit or 64-bit? For SQL Server 2008 R2 (and anything below SQL Server 2012):

If it’s a 32-bit server, increase “memory to reserve” (-g switch on startup)

If it’s a 64-bit server, decrease “max server memory” to allow SQLCLR to have enough resources. If, as you suspect, if SQL Server is taking all the resources, there’s none left for memory allocations outside the buffer pool (e.g. SQLCLR).

 

Also, you might try reposting/cross-posting this question to the SCOM-specific forum, if it exists.

 

Hope this helps, Bob