cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Former Member
Not applicable
Report Inappropriate Content
Message 1 of 11

Memory utilisation of sql server high

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! 

 

10 Replies
Hem
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 11

Re: Memory utilisation of sql server high

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
Not applicable
Report Inappropriate Content
Message 3 of 11

Re: Memory utilisation of sql server high

Hem, 

I don't see those extensions got installed. 

cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 11

Re: Memory utilisation of sql server high

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

Select name, version from orionextensions

 

 

 

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?

cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 5 of 11

Re: Memory utilisation of sql server high

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

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

 

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
Not applicable
Report Inappropriate Content
Message 6 of 11

Re: Memory utilisation of sql server high

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
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 7 of 11

Re: Memory utilisation of sql server high

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.

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
Not applicable
Report Inappropriate Content
Message 8 of 11

Re: Memory utilisation of sql server high

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
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 9 of 11

Re: Memory utilisation of sql server high

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?

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
Not applicable
Report Inappropriate Content
Message 10 of 11

Re: Memory utilisation of sql server high

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. 

 

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community