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 |
|
DBA007
Posting Yak Master
145 Posts |
 Posted - 2013-06-10 : 05:01:47
|
| Hi Everyone,One of our server in the production environment is hitting 93% of memory utilization and sqlserver is the only one installed in the server and takes almost 7gb out of total 8gb memory.we haven't configured any min and max settings as sqlserver is the only one installed.Does any one have faced these kind of issues,Please provide the steps for troubleshooting. |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-10 : 08:15:29
|
| SQL Server will indeed consume as much memory as it is allowed to, without regards to whether it is going to starve other applications and Windows OS of needed memory. To avoid that, you need to set the maximum memory that SQL Server is allowed to consume. You can set this from SSMS by right-clicking on the server, selecting Properties -> Memory tab. Set the maximum server memory to be what you want to allow SQL Server to use. Remember that it is to be specified in MEGABYTES. In your case, I would set it about 6000 MB, leaving 2GB for the Windows OS. This is a safe operation to do on production servers; the memory consumed by SQL Server may not come down immediately, but it eventually will. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
High Memory utilization