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 |
|
vivekjain
Starting Member
2 Posts |
 Posted - 2005-02-09 : 06:06:27
|
hi . I am facing a problem for excessive usgae of memory by SQL server. It slows down the performance. i mean to say the site runing using the Server is responding slowly. both IIs and SQL server are on same machine . Systenm has 2GB Of RAM and Max allocated to Sql Server is 2048 MB ith min 0 WIth Performance monitor wehen we monitor it gives the Cache Hit Ratio 99.96637 Cache Flushes 0.0 Free Page Scan (Avg) 0.0 Free Page Scan (Max) 0.0 Min Free Buffers 331.0 Cache Size 4362.0 Free Buffers 27193.0 the memory allocated to it is num Proc buffs 30 num Proc buffs used 30 num Proc buffs Active 25 proc cache size 24 proc cache Used 24 proc cache Active 19 the total Memory usage is almost 291 MB Is this could be the problem that max usage of memory allowed is 2048 MB ie 2 GB so whenever the SQL needs it uses it but doesn't frees it up as requd untill th os does .Or What could be the problem . Pls help me > Thanks & Best Regards, Vivek JainVivek Jain |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-09 : 12:51:53
|
| Sql server will grab any memory it can. Try limitting the amount of memory available to it.In enterprise manager right click on the server, propeties, memory.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vivekjain
Starting Member
2 Posts |
Posted - 2005-02-09 : 23:11:40
|
| hi thanks .i want to know one more thing how to find the MEM to leave space Used by the SQL server Pls Help me in this regard thanksVivek Jain |
|
|
|
|
|
|
SQL Server Slows Down