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 |
|
afhughes
Starting Member
2 Posts |
 Posted - 2012-07-04 : 05:30:46
|
| HiI have just installed an evaluation copy of sql server 2012 on my (6gb) machine. I'm running some queries on a table with only 17000 rows but with some complex spatial data.Almost anything I do results in using all 6gb of of memory. Once the process ends the memory is not released, even when I close management studio. I have to kill the sql service and then reboot my machine to get things back to normal.Any one had a similar issue or know a fix? |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-07-04 : 06:31:05
|
| That's the standard behavior. Sql Server will take all the memory it can get. This is because it's almost always set up on it's own server and be the only task the box will run.Have a look here to tune ithttp://support.microsoft.com/kb/321363Transact CharlieMsg 3903.. The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-07-05 : 01:54:01
|
| Is there enough memory left for the OS and any other utilitoes on the server? You can use the MAX memory setting to limit the amount of memory used by SQL ServerJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
afhughes
Starting Member
2 Posts |
Posted - 2012-07-05 : 10:36:24
|
| Thanks for the info, it seems this is normal behaviour and that memory is released as it is needed. If it becomes a problem I will look at limiting the max memory setting. |
|
|
|
|
|
|
SQL Server 2012 memory problems