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 |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2004-01-22 : 15:22:15
|
| Hi,In very short period SS2k become almost asleep - EM respond time is infinite.Changing the memory allocation from dynamic to firm and back to dynamic changes nothing.Sqlsvr.exe uses 50 MB RAM and 50-MB page.Please help!Dobby |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-22 : 15:25:30
|
| How do you know that SQL Server needs more memory? Have you checked the target server memory in Performance Monitor to find out that it does?Tara |
 |
|
|
nemohm
Yak Posting Veteran
69 Posts |
Posted - 2004-01-22 : 15:30:29
|
| Enterprise Manager is responding after hours!!!I have privious readings and thing like this never happend before.Dobby |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-22 : 15:32:51
|
| What do you mean responding after hours? SQL Server will only use more memory if it needs it. If Enterprise Manager is slow, that doesn't mean that SQL Server needed more memory.What are you trying to do in EM?Tara |
|
|
|
nemohm
Yak Posting Veteran
69 Posts |
Posted - 2004-01-22 : 15:43:37
|
| Response time is the time needed something on the tree to gets open after click on it!Which counters do you need?Dobby |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-22 : 15:46:53
|
| Why are you using Enterprise Manager though? The slowness of Enterprise Manager has nothing to do with the database server. It has to do with how EM works and how fast your own machine is. Use Query Analyzer instead.But to view target memory (which isn't going to help you since you are using EM), select the SQL Server:Memory Manger object, then select Target Server Memory (KB) and Total Server Memory (KB) counters. Total is how much it is consuming at that moment. Target is how much it wants to consume. These numbers should be equal if SQL Server has enough memory.Tara |
|
|
|
|
|
|
sqlsvr.exe uses 50 MB of RAM...