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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-08-25 : 01:55:16
|
| i have 8 giga memory, and i have 2 instance in sqlthe default instatnce take 1.7 gigaand the second instance take 3.7 gigaso, almost al my memory take to sql , can i work with that(that all my memory take to sql?)to solve that i need to restart the instance |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-25 : 04:30:12
|
| What is the edition of SQL Server? Standard or Enterprise?Do you have any other applications running on the same server?If not, then this setup is fine. You should set the max memory to be 2GB for the default instance and 4GB for the second instance.Then the OS has 2GB.The memory settings are dynamic, so it does not require a restart. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-08-25 : 06:54:42
|
| i have standart editioni have Reporting on this server, why i need 4 GB to the instance? i have more and important DB in the default. |
|
|
|
|
|
|
high memory