Memories

I've got Sql Server 2000 SP2 on a Windows 2000 Advanced Server SP4. Here's
what the various stats are telling me:
Enterprise Manager Min Memory: 0 M
Enterprise Manager Max Memory: 6000 M
Computer Management Tot. Physical Memory: 7863 M
Computer Management Avail. Physical Memory: 5501 M
Performance Monitor Total Server Memory: 1673 M
Performance Monitor Target Server Memory: 1673 M
And, finally, here is what I believe is in our boot.ini file:
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced
Server" /fastdetect /12gb /pae
This leads to a couple of questions:
1. Why does Perf Monitor say we are using so little memory? Is this
because it can't detect the extra memory or because it's truly not being used?
2. How can I check for sure that Sql Server is using up to the 6G of
memory, i.e. what is the final word?
3. Is our boot ini file set up correctly for our situation?In your Boot.ini the error is /12GB this parameter doesn't exist.
The correct configuration for you boot.ini in machine with above the 4GB is:
multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced
Server" /fastdetect /3GB /pae
In SQL Server enable the AWE support:
sp_configure 'awe enabled', 1
go
reconfigure with override
go
After restart your SQL Server.
Look at:
http://www.sql-server-performance.com/awe_memory.asp
When you want limit the SQL Server memory use, configure the "max server
memory" parameter:
sp_configure 'max server memory', 6144
go
reconfigure with override
go
--
** * Esta msg foi útil pra você ? Então marque-a como tal. ***
Regards,
Rodrigo Fernandes
"CLM" wrote:
> I've got Sql Server 2000 SP2 on a Windows 2000 Advanced Server SP4. Here's
> what the various stats are telling me:
> Enterprise Manager Min Memory: 0 M
> Enterprise Manager Max Memory: 6000 M
> Computer Management Tot. Physical Memory: 7863 M
> Computer Management Avail. Physical Memory: 5501 M
> Performance Monitor Total Server Memory: 1673 M
> Performance Monitor Target Server Memory: 1673 M
> And, finally, here is what I believe is in our boot.ini file:
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced
> Server" /fastdetect /12gb /pae
> This leads to a couple of questions:
> 1. Why does Perf Monitor say we are using so little memory? Is this
> because it can't detect the extra memory or because it's truly not being used?
> 2. How can I check for sure that Sql Server is using up to the 6G of
> memory, i.e. what is the final word?
> 3. Is our boot ini file set up correctly for our situation?
>
>
>|||Thx for the help.
Another question for you: can list some of the good Sql Server links that
are in spanish? I'm trying to learn Spanish and would like to start reading
those.
"Rodrigo Fernandes" wrote:
> In your Boot.ini the error is /12GB this parameter doesn't exist.
> The correct configuration for you boot.ini in machine with above the 4GB is:
> multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced
> Server" /fastdetect /3GB /pae
> In SQL Server enable the AWE support:
> sp_configure 'awe enabled', 1
> go
> reconfigure with override
> go
> After restart your SQL Server.
> Look at:
> http://www.sql-server-performance.com/awe_memory.asp
> When you want limit the SQL Server memory use, configure the "max server
> memory" parameter:
> sp_configure 'max server memory', 6144
> go
> reconfigure with override
> go
> --
> ** * Esta msg foi útil pra você ? Então marque-a como tal. ***
> Regards,
> Rodrigo Fernandes
>
> "CLM" wrote:
> > I've got Sql Server 2000 SP2 on a Windows 2000 Advanced Server SP4. Here's
> > what the various stats are telling me:
> >
> > Enterprise Manager Min Memory: 0 M
> > Enterprise Manager Max Memory: 6000 M
> > Computer Management Tot. Physical Memory: 7863 M
> > Computer Management Avail. Physical Memory: 5501 M
> > Performance Monitor Total Server Memory: 1673 M
> > Performance Monitor Target Server Memory: 1673 M
> >
> > And, finally, here is what I believe is in our boot.ini file:
> > multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced
> > Server" /fastdetect /12gb /pae
> >
> > This leads to a couple of questions:
> > 1. Why does Perf Monitor say we are using so little memory? Is this
> > because it can't detect the extra memory or because it's truly not being used?
> > 2. How can I check for sure that Sql Server is using up to the 6G of
> > memory, i.e. what is the final word?
> > 3. Is our boot ini file set up correctly for our situation?
> >
> >
> >
> >
> >
> >