Friday, March 9, 2012

how can sql server see more memory

Win 2003 Enterprised Edition
Sql Server Per Proc licence
sql server 2000 standard edition
10 GB Ram
Is it possible for my SQL Server 2000 Std to see more than 2GB of memory? If
so, how? If I install two instances of sql server, will that help?Each instance can use up to 2GB of memory but that does not do you any good
if a db in one instance needs more than 2GB. If you do then you need
Enterprise Edition.
Andrew J. Kelly SQL MVP
"anna" <anna@.discussions.microsoft.com> wrote in message
news:E2DE692E-9CF6-4EEF-A5B1-BAC15A2FD8A2@.microsoft.com...
> Win 2003 Enterprised Edition
> Sql Server Per Proc licence
> sql server 2000 standard edition
> 10 GB Ram
> Is it possible for my SQL Server 2000 Std to see more than 2GB of memory?
> If
> so, how? If I install two instances of sql server, will that help?
>

No comments:

Post a Comment