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 |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-02-01 : 15:25:13
|
| how to check the memory usage other than performance monitor for the server?When I execute the SP_WHO2 on the server, it showing each user have 5 connections there and the status is sleep. what is that means?Does it takes up memory?why have so many connection or entries for the same user, they all are using the same db with same application.Thanks! |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-02-01 : 16:33:38
|
| Each connection takes some memory...I don't remember it at this time...You can the memory information by running DBCC MEMORYSTATUS...http://support.microsoft.com/Default.aspx?id=271624May be your application is not closing the connections once it gets the data.. or may be you have multiple servers connecting to the db sever with same userid..MohammedU |
 |
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2007-02-01 : 17:13:30
|
| Just check that DBCC MEMORYSTATUS, it shows use 1.6GB memory.Our server is running on SQL 2005 in Windows 2003 server box. 200GB space with 2GB Memory, nothing running on that server except the sql server 2005.We are test by just have 5 users connected to one database ( about 700mb)and check the memory usage in task manager, it shows already use up 1.6GB memory. But only 5 users connected and we have to connect 30 users to use that database. Does it means I need a lot more memory? or 2GB of ram is just minimum for SQL Server 2005Thanks! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-01 : 17:29:33
|
| SQL Server does not release memory unless it no longer needs it and some other process is requesting it. So it's normal for SQL Server to use almost all of the available memory. To see if you need additional memory added to the system, you can use the SQL Server Memory Manager:Target and Total Server Memory performance objects in Performance Monitor. As long as Target is less than or equal to Total, you are okay.I believe each connection uses 2k of memory. It's around that number at least, so very small.Tara Kizer |
|
|
|
|
|
|
Memory usage