Help reviewing memory consumption SQL Server 2008 R2
I'd appreciate help reviewing memory consumption on a production SAP CRM database server.
Attached is an export of Memory Consumption report from SQL. Does anything stand out to you?
Buffer Pages distribution appears to be huge.
This server was restarted early Saturday morning.
Memory-Consumption---10132014-349-PM---S
Attached is an export of Memory Consumption report from SQL. Does anything stand out to you?
Buffer Pages distribution appears to be huge.
This server was restarted early Saturday morning.
Memory-Consumption---10132014-349-PM---S
ASKER
Attached file is .xls. Attaching again as first one appears to be corrupt.
Agreed regarding SAP SQL server configuration. However, I have doubts about our support/implementation team's sql skills, so would like to learn more. Thank you for looking.
Memory-Consumption---10132014-349-PM---S
Agreed regarding SAP SQL server configuration. However, I have doubts about our support/implementation team's sql skills, so would like to learn more. Thank you for looking.
Memory-Consumption---10132014-349-PM---S
ASKER
Adding as JPEG.
Memory-Consumption---10132014-349-PM---S
ASKER
Memory usage by components:
I can't help you without knowing the configuration of your server.
It's MSSQL 2008R2 right? Which edition? 32bit or 64bit? And what about the Operating System?
How much RAM and CPU? It's physical or virtual machine?
It's dedicated to SQL Server? If not, what's running more on the box?
NOTE: Still can't read the Excel file.
It's MSSQL 2008R2 right? Which edition? 32bit or 64bit? And what about the Operating System?
How much RAM and CPU? It's physical or virtual machine?
It's dedicated to SQL Server? If not, what's running more on the box?
NOTE: Still can't read the Excel file.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Scott,
Results are below:
Results are below:
ASKER
Vitor,
MSSQL 2008R2, 64bit.
Virtual machine. 32768 MB Memory.
CPU: Quad 2.9 Ghz Intel
It's dedicated to SQL Server.
Regards,
Karen
MSSQL 2008R2, 64bit.
Virtual machine. 32768 MB Memory.
CPU: Quad 2.9 Ghz Intel
It's dedicated to SQL Server.
Regards,
Karen
How many vCPU's?
With that Max Memory set for SQL Server I think you won't have memory pressure for a while.
With that Max Memory set for SQL Server I think you won't have memory pressure for a while.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Scott - I didn't find that but did determine the root cause; as part of a restart of another server, the SQL server service on this server is being stopped and started.
Vitor - Quad 2.9 Ghz Intel vCPUs. Thank you for the input on the max memory setting.
Should I be at all concerned about the stolen buffer pages distribution?
Vitor - Quad 2.9 Ghz Intel vCPUs. Thank you for the input on the max memory setting.
Should I be at all concerned about the stolen buffer pages distribution?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As I know for SAP is that you should follow their recommendations for configuring SQL Server since they don't follow the best practices but their own engineers recommendations.