Memory utilisation of sql server high

[Former Member]

Hi Team, 

Good day!

SQL server memory is high, 5k machines managed with ePO 32gb RAM.

Regardless to the task which is running or not running. Memory usage spike out. 

Sp_who2 shows lot of sleeping and suspended entries for ePO. 

Thank you! 

[Hem]

Do you have support center extension installed?

Please look at #: https://kc.mcafee.com/corporate/index?page=content&id=KB92201

Do you have MV migration extensions installed?

Please look at #: https://kc.mcafee.com/corporate/index?page=content&id=KB92716&locale=en_US

Was my reply helpful?

If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

[Former Member]

Hem, 

I don't see those extensions got installed. 

[cdinet]

Please get output of following query - it will not return any sensitive company information.

Select name, version from orionextensions

[cdinet]

Additionally, make sure you have the proper AV exclusions for an sql server.

https://kc.mcafee.com/corporate/index?page=content&id=KB67211

[Former Member]

readonly 5.0
ui 5.10.0.893
console 5.10.0.893
scheduler 5.10.0.893
rs 5.10.0.893
ldap 5.10.0.893
help 5.10.0.893
report 5.10.0.893
ldapsync 5.10.0.893
CertificateManager 5.10.0.893
EPOCore 5.10.0.2428
dr 5.10.0.893
response 5.10.0.893
commonui-core-common 1.10.0.364
logonprotection 5.10.0.893
DataChannel 5.10.0.2428
epoLicEnt 5.10.0.2428
RepositoryMgmt 5.10.0.2428
ProductDeployment 5.10.0.2428
SoftwareMgmt 5.10.0.2428
CommonEvents 5.10.0.2428
AssetCore 5.10.0.2428
epolicensing 5.10.0.2428
GuidedConfig 5.10.0.2428
SystemSortAPI 1.0.0.139
Issue 5.7.0.0
EPOAGENTMETA 5.6.6.104
EEPC 7.2.9.14
ENDP_ADR 1.0.0.371
catalogFramework 2.0.4.128
JTIClientMETA 10.7.0.562
commonui-core-rest 1.10.0.364
ComputerMgmt 5.10.0.2428
MessageCenter 5.10.0.2428
PolicyMgmt 5.10.0.2428
AgentMgmt 5.10.0.2428
Notifications 5.10.0.2428
epoMigration 5.10.0.2428
ServerInformation 5.10.0.2428
InstallHelper 5.10.0.2428
SyslogMgmt 5.10.0.2428
contentfeed 1.0.0.135
EndpointUpgradeAssistant 2.1.0.39
ENDP_GS_1000 10.7.0.566
mhd_help 2.0.0.130
mcc_help 2.0.0.011
EEADMIN 7.2.9.14
EEGO 7.2.9.14
de_help 7.2.2.010
userdirectory 2.0.2.7
EEFF 5.1.0.209
ENDP_AM_1000 10.7.0.585
mcp_help 2.3.2.010
coreCatalog 2.0.4.128
dlp_help 11.0.2.030
ENDP_FW_META 10.7.0.541
ENDP_WP_1000 10.7.0.550
UDLPSRVR2013 11.4.0.17

[cdinet]

You don't have any of the extensions that are known to cause sleeping connections.  What specific sleeping queries do you see and how many?  

Also, one thing to be aware of, sql by nature will use all available memory on a system - that's just the way sql behaves.  You can limit the memory sql uses to reserve at least 2g for the OS or as desired, but the question would also be how high is high and for how long?  Is anything occurring specifically that might cause it to spike (server task running, maintenance, queries running, etc).  Any errors in sql error logs?  Did you validate the AV exclusions?  That can cause high memory and cpu.  You also need to identify the exact processes running high to make sure you are looking at the right thing.

[Former Member]

Hi Team, 

Good day!

I have completely unistalled AV product got the server rebooted, still I could see the spike. 

Error log, I could the entry that say explicitly unable to open the database for my sa account. 

Any help! 

[cdinet]

If you can't open the database, is it suspect, in recovery, or any other errors?  Can you even view it?  Does any other account access it?  Are you running sql express?  Is the drive or database out of space?

[Former Member]

I am able to access DB, sql is standard. Free space is available. There is only one account we use in sql which is nothing but a SA account to have full previlages.