Multiple instances

If I installl 2 standard edition SQL 2K instances on a Server with 4 G RAM.
Does it mean each instance can can use its own 2G RAM without interfering
with other instance?
Yes, each instance can use up to 2GB. In practice, you'll need to consider
memory requirements for the OS and other apps as well. Monitor and adjust
SQL Server 'max server memory' as needed to avoid excessive paging. Also,
consider your licensing mode.
Hope this helps.
Dan Guzman
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
|||"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
Yes.
David
|||Hi,
Yes, it does by itself if both are standard edition. But still I will say to
make the memory static if you have multiple instances of sql server running
in a single machine. Measure the memory requirement per instance using
perfmon during the peak usage and fix the memory required.
Thanks
Hari
SQL Server MVP
"Aziz" <Aziz@.discussions.microsoft.com> wrote in message
news:9DB27D4B-B9F0-4B3C-84C8-08AFEF94DE80@.microsoft.com...
> If I installl 2 standard edition SQL 2K instances on a Server with 4 G
> RAM.
> Does it mean each instance can can use its own 2G RAM without interfering
> with other instance?
sql