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 |
|
mdanwerali
Starting Member
30 Posts |
 Posted - 2002-11-26 : 06:12:41
|
| Hi,I have a problem with Memory Usage in my Server.After Running Sql Server the MEMORY USAGE WILL BE normal but after executing the Procedure my Memory usage is going up naturally, but after completion of my procedure it should come down right. but it is not coming. Some Times Even thought i am not using any procedures.. with simple select statements it is giving high Memory usage and my server is becomming slow.Is there any technique to solve from my side or any Sql Server statements or commands will be control the memory usage.please save me and my Server i cannot stop and start my server every time whenever it is showing high memory usage.Note: once i stop and start my server again the memory usage is becoming normal.md anwer ali |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-11-26 : 07:56:33
|
| SQL Server will not release memory unless, and until, other processes are screaming for it. This is perfectly normal behavior and ensures that SQL Server performs at peak efficiency. If you need to set an upper limit on the memory SQL Server uses, go into Enterprise Manager, right-click on the Server, choose Properties, and go to the Memory tab. You can set upper and lower limits on how much RAM SQL Server will use.This should not be an issue unless you are running other server apps on your SQL Server, like IIS, Exchange, etc., and you really shouldn't be running them on the same machine anyway. |
 |
|
|
|
|
|
Memory Usage