|
-
sqlserver.exe memory usage increasing
Would anyone have any suggestions/advice on how to determine what is causing the memory usage for sqlserver.exe to increase a dramatic pace in windows task manager? What would be a good resolution to slow down this memory usage?
Thanks!
-
sqlserver.exe memory usage increasing (reply)
Well, here's the deal. As you query and update and request more data from SQLServer, it continues to use memory as a cache for the data, in case you need it again. It will try to intelligently keep that data in memory so that it can more quickly retrieve it when the time comes.
If you need to limit the amount of memory you want SQLServer to use, you can do so in enterprise manager, under server properties. If you just let it manage itself, it will take up about 90% or more of the available memory. It is supposed to play nice with other applications, backing off and giving them memory if they need it, but if you know other apps will constantly be running, it's probably better to set a limit for SQL's memory.
Make sense?
------------
lisa at 9/20/01 11:15:25 AM
Would anyone have any suggestions/advice on how to determine what is causing the memory usage for sqlserver.exe to increase a dramatic pace in windows task manager? What would be a good resolution to slow down this memory usage?
Thanks!
-
sqlserver.exe memory usage increasing (reply)
yes it does ... thanks for the info!
------------
joe at 9/20/01 1:52:50 PM
Well, here's the deal. As you query and update and request more data from SQLServer, it continues to use memory as a cache for the data, in case you need it again. It will try to intelligently keep that data in memory so that it can more quickly retrieve it when the time comes.
If you need to limit the amount of memory you want SQLServer to use, you can do so in enterprise manager, under server properties. If you just let it manage itself, it will take up about 90% or more of the available memory. It is supposed to play nice with other applications, backing off and giving them memory if they need it, but if you know other apps will constantly be running, it's probably better to set a limit for SQL's memory.
Make sense?
------------
lisa at 9/20/01 11:15:25 AM
Would anyone have any suggestions/advice on how to determine what is causing the memory usage for sqlserver.exe to increase a dramatic pace in windows task manager? What would be a good resolution to slow down this memory usage?
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|
Reply With Quote