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 |
|
poweron
Starting Member
4 Posts |
 Posted - 2008-06-16 : 04:03:59
|
| Hello, I have SQL Server 2005 64 bit on Windows Server 2003 Enterprise 64 bit on a server with 8GB of RAMTask Manager reports the process sqlserver.exe consuming 7GB of memoryIs this normal ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
poweron
Starting Member
4 Posts |
Posted - 2008-06-17 : 00:11:07
|
| Which counter should I be concerned with ?I have several databases with total size around 60GBs |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-17 : 13:57:06
|
| MSSQL$YourInstance:Memory Manager\Target Server Memory (KB)MSSQL$YourInstance:Memory Manager\Total Server Memory (KB)MSSQL$YourInstance:Buffer Manager\Buffer cache hit ratioMSSQL$YourInstance:Buffer Manager\Page life expectancyTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
poweron
Starting Member
4 Posts |
Posted - 2008-06-18 : 01:26:39
|
| Average ValuesTarget Server Memory (KB) : 7021800 (keeps counting)Total Server Memory (KB) : 6915584 (fixed)Buffer cache hit ratio : 99.867Page life expectancy : 125353 |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-06-18 : 01:44:28
|
| How much memory the SQL Server is dependant on the size of the dbs, queries etc. If there are resources free Windows will attempt to reclaim memory , using the Min Memory setting as the guidelineJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 22:48:22
|
| Or set max memory to 6gb in sql. |
|
|
|
|
|
|
SQL Memory Usage