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 |
|
david32
Starting Member
15 Posts |
 Posted - 2008-08-13 : 21:47:28
|
| I have 13 instances (most aren't used yet but planning to) on a 64 bit XEON (8 CPU) machine with 16 GB. Presently the %Committed Bytes in Use is exceeding 80% and the PF usage is 14 GB. I have turned off all the instances except the one that are being used - 5. The avialable memory is 100%, Disk Time is 0The target server and total server memory (for one point of time) are as follows Target Server Memory Total Server Memoryinstance1 110592 4552224instance2 4552224 2913792instance3 6928840 5296640instance4 4936736 3298304Why are these so high + committed bytes when all other indicators are low (disk and avialable memory)? Does it have something to do with minimum and maximum memory on server?How can I go about determining if I need more memory or just a config tweak?thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 23:49:39
|
| How come Total Server Memory is bigger than Target Server Memory for instance1? |
 |
|
|
david32
Starting Member
15 Posts |
Posted - 2008-08-14 : 01:27:25
|
| sorry instance 1 is:Target Total 1661216 110592I noticed over the last few hours the values have been increasingfor target.. does that mean anything? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-14 : 23:57:07
|
| You can look at perfmon memory counters for each instance, and get memory usage report in ssms for each instance. Put 13 instances on one server sounds too much to me. |
|
|
|
|
|
|
page file problems