Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrlasantha
Starting Member
1 Post |
 Posted - 2014-12-23 : 23:56:48
|
| Hi,I am using SQL Server 2005 Standard Edition on Windows Server 2003 64 bit environment. My problem is memory utilization is go to maximum and therefore the server performance is going down. Once I restart the SQL server service it is reducing but it again starts to increase the memory utilization gradually. Please help me to settle this issue permanently.My thanks,Lasantha. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-24 : 00:47:28
|
| have you configured max memory setting for sql server?Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-24 : 10:32:27
|
| SQL Server is a memory hog. If this is a dedicated server for SQL Server, set the maximum memory setting to a value that gives the OS and other processes 2-8GB. How much memory do you have on the server? Is it a dedicated box for SQL Server?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
High memory utilization