Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

high memory usage Expand / Collapse
Posted Monday, November 26, 2012 4:18 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 11, 2016 11:39 PM
Points: 219, Visits: 1,122

hello experts,
please go through the below configuration:-

sql server 2005 sp2
windows server 2003 R2 (64 bit)
CPU 2.13 GHz
RAM 128 GB
max server memory 100GB
min server memory 40GB

Today morning got an issue server was too slow and concernd team taken a screen shot of memory utilization till 102 GB, first concern, is any possibility that sql server can take more memory than what we have defined in max server memory??
Post #1388513
Posted Monday, November 26, 2012 4:24 AM



Group: General Forum Members
Last Login: Thursday, September 1, 2016 2:56 AM
Points: 5,969, Visits: 6,067
Do not cross posts it fragments replies

replies here

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1388517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse