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 |
|
peera
Starting Member
11 Posts |
 Posted - 2003-12-01 : 15:38:47
|
| Hi,db server memory 100% being used, using sql2000, 4gb ram, dbsize 700mb. almost have to stop and start the server. how do i proced with this.thxpeera |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-01 : 15:41:55
|
| Is this a dedicated SQL Server machine? If not, then there's your problem. If so, do you know that SQL Server needs more memory? If so, did you use Performance Monitor to see this? Which counters did you look at? Do not stop and start the server in order to fix this, it'll just happen again and restarting SQL Server causes a performance problem in the beginning. You need to do some performance analysis to see if you even need more memory. Take a look at Process:sqlservr Page Faults/sec for a start. Have a look at sql-server-performance.com for really good performance analysis information.Tara |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-12-01 : 18:58:06
|
Here is some good information from sql-server-performance.com:quote:
Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how much the mssqlserver service is currently using. The second counter, SQLServer:Memory Manager: Target Server Memory (KB), tells you how much memory SQL Server would like to have in order to operate efficiently. If your SQL Server has enough memory, then these two counters will be identical. But, if the SQLServer:Memory Manager: Total Server Memory (KB) counter is less than the SQLServer:Memory Manager: Target Server Memory (KB) counter, then this means that SQL Server does not have enough memory to run efficiently. If this is the case, you most likely need to add more RAM to your server. [7.0, 2000] Added 5-22-2002
Tara |
|
|
|
|
|
|
|
|
server memory 100%