System Memory

Question

System Memory

goher2000

SSCertifiable

Points: 5477
More actions
March 25, 2019 at 8:44 am

#2031655

I have system (win2012 r2) with 32GB, out of which 26 is allocated to SQL Server 2014 EE, I ran system perfmance report that gives me warning of excessive paging, My question is how do I identify if it is in fact Sql server and not any other application causing this issue, I understand that adding memory may fix the issue, do I need to change max memory for sql server?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Thomas Rushton SSC-Insane Points: 22648 More actions · Answer 1

What else is running on the server? Is it dedicated to SQL Server, or are there other processes there such as SSRS, SSAS, your application, AV, endpoint protection, somebody logged into the desktop to run SSMS / do development work?

Any of those would require additional memory, and should have been taken account of when the SQL Server maximum memory configuration was considered.

Thomas Rushton
blog: https://thelonedba.wordpress.com

goher2000 SSCertifiable Points: 5477 More actions · Answer 2

there are no other applications on the box, other than symantec and vmware/backup tools for which I am sure 6GB is more then enough, there is no SSRS/SSAS on the box, nobody logon to this box directly it has very restricted access.

My question remains how do I identify which application is causing paging.
here is more information, not sure if it helps

goher2000 SSCertifiable Points: 5477 More actions · Answer 3

Thanks Guys,
Answering my own question,,

process explorer

Michael L John One Orange Chip Points: 27038 More actions · Answer 4

Unless the server is severely overpowered or mis-configured, I'm not sure I've seen SQL cause a paging issue.

Is Symantec configured to exclude the data and log files?
How big are the databases on this server? 32 GB is an awfully low amount of RAM these days.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

goher2000 SSCertifiable Points: 5477 More actions · Answer 5

I am sure database files are excluded but I will confirm, the biggest database is about 900gb, I will also see what I can find from Symantec,
any advise/guide lines to identify ' overpowered or mis-configuration' ?

Michael L John One Orange Chip Points: 27038 More actions · Answer 6

goher2000 - Monday, March 25, 2019 12:54 PM
I am sure database files are excluded but I will confirm, the biggest database is about 900gb, I will also see what I can find from Symantec,
any advise/guide lines to identify ' overpowered or mis-configuration' ?

900 GB database with 32 GB of RAM? Convince the powers that be to spend some money!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

goher2000 SSCertifiable Points: 5477 More actions · Answer 7

spending $$ is no issue, the question is what if adding memory to OS does not satisfy Symantec's urge to use page file