Memory Usage On SQL 2K

I have SQL 2000 running with 8GG of RAM and 8 procs. In Task Manager it is
showing well over 7GB in use but the processes do not add up to near that
amount. How can I determine what is grabbing all the memory on this server?
Thanks, Sean
Duplicate Post
"Sean" wrote:

> I have SQL 2000 running with 8GG of RAM and 8 procs. In Task Manager it is
> showing well over 7GB in use but the processes do not add up to near that
> amount. How can I determine what is grabbing all the memory on this server?
> Thanks, Sean

Memory Usage On SQL 2K

I have SQL 2000 running with 8GG of RAM and 8 procs. In Task Manager it is
showing well over 7GB in use but the processes do not add up to near that
amount. How can I determine what is grabbing all the memory on this server?
Thanks, SeanDuplicate Post
"Sean" wrote:

> I have SQL 2000 running with 8GG of RAM and 8 procs. In Task Manager it i
s
> showing well over 7GB in use but the processes do not add up to near that
> amount. How can I determine what is grabbing all the memory on this serve
r?
> Thanks, Sean

Memory Usage On SQL 2K

I have SQL 2000 running with 8GG of RAM and 8 procs. In Task Manager it is
showing well over 7GB in use but the processes do not add up to near that
amount. How can I determine what is grabbing all the memory on this server?
Thanks, SeanDuplicate Post
"Sean" wrote:
> I have SQL 2000 running with 8GG of RAM and 8 procs. In Task Manager it is
> showing well over 7GB in use but the processes do not add up to near that
> amount. How can I determine what is grabbing all the memory on this server?
> Thanks, Sean

Memory Usage on SQL 2000

Good Morning All,
I have a SQL server with 8GB of memory and 8 processors. The memory use in
Task Manager is showing over 7GB in use but the processes in Task Manager do
not add up to anywhere near that amount of RAM being used.
My question is how do I determine what is using all of the RAM on this server?
Thanks, SeanHi
Once you use PAE or AWE, task manager does not show the memory correctly.
You need to look at the Performance Counters presented in the OS perfmon
utility.
The see what is configured for SQL run the following in QA:
sp_configure 'show advanced options', 1
sp_configure 'awe enabled'
sp_configure 'min server memory'
sp_configure 'max server memory'
Regards
Mike
"Sean" wrote:
> Good Morning All,
> I have a SQL server with 8GB of memory and 8 processors. The memory use in
> Task Manager is showing over 7GB in use but the processes in Task Manager do
> not add up to anywhere near that amount of RAM being used.
> My question is how do I determine what is using all of the RAM on this server?
> Thanks, Sean

Memory Usage on SQL 2000

Good Morning All,
I have a SQL server with 8GB of memory and 8 processors. The memory use in
Task Manager is showing over 7GB in use but the processes in Task Manager do
not add up to anywhere near that amount of RAM being used.
My question is how do I determine what is using all of the RAM on this server?
Thanks, Sean
Hi
Once you use PAE or AWE, task manager does not show the memory correctly.
You need to look at the Performance Counters presented in the OS perfmon
utility.
The see what is configured for SQL run the following in QA:
sp_configure 'show advanced options', 1
sp_configure 'awe enabled'
sp_configure 'min server memory'
sp_configure 'max server memory'
Regards
Mike
"Sean" wrote:

> Good Morning All,
> I have a SQL server with 8GB of memory and 8 processors. The memory use in
> Task Manager is showing over 7GB in use but the processes in Task Manager do
> not add up to anywhere near that amount of RAM being used.
> My question is how do I determine what is using all of the RAM on this server?
> Thanks, Sean

Memory Usage on SQL 2000

Good Morning All,
I have a SQL server with 8GB of memory and 8 processors. The memory use in
Task Manager is showing over 7GB in use but the processes in Task Manager do
not add up to anywhere near that amount of RAM being used.
My question is how do I determine what is using all of the RAM on this serve
r?
Thanks, SeanHi
Once you use PAE or AWE, task manager does not show the memory correctly.
You need to look at the Performance Counters presented in the OS perfmon
utility.
The see what is configured for SQL run the following in QA:
sp_configure 'show advanced options', 1
sp_configure 'awe enabled'
sp_configure 'min server memory'
sp_configure 'max server memory'
Regards
Mike
"Sean" wrote:

> Good Morning All,
> I have a SQL server with 8GB of memory and 8 processors. The memory use i
n
> Task Manager is showing over 7GB in use but the processes in Task Manager
do
> not add up to anywhere near that amount of RAM being used.
> My question is how do I determine what is using all of the RAM on this ser
ver?
> Thanks, Sean

Memory usage

Win2K Advanced Server , SQL2K Enterprise Edition(SP3). 80 GB database, 3.7
GB RAM. Cluster Service is running but currently there is no failover
server. Currently the Perfmon counters Target Server Memeory and Total
Server Memory are about 1682534 KB with only slight flucuations. AWE is not
enabled nor is the /3GB switch. The server's memory setting is 'Dynamically
configure SQL Server memory'. Since this is a fairly active db I expect the
memory usage to be closer to 2 GB.
Why is it not maxing out memory up to 2 GB?
I eventually want to enable memory greater than 2 GB. I believe all I need
to do is enable AWE using sp_configure and restart the instance. Do I need
the /3GB switch also? Should I set the max memory setting or leave it
dynamic? If I set the max memory setting what should I set it to?
Buffer Cache Hit Ratio - 98%+
Average Page Life 20 - 1000 secs.
CPU - 20% - 50 %
It has been a while since I have worked on a server that has had memory =
config set to 2GB, but if I remember correctly the servers that I worked =
on that were limited to 2GB of usage showed less (somewhere between 1.6 =
and 1.8GB). I think what you are seeing is normal.
You will want to add /3GB to the boot.ini. Yes, you would need to use =
sp_configure to enable AWE. You will also want to set min and max =
server memory (MB). Try setting min/max server memory to 3GB. =20
To be honest, I don't know that you will see a large performance =
increase in going from 2GB to 3GB of RAM on a server with an 80GB =
database. Then again, it depends on how the database is used.
--=20
Keith
"Dean" <deann@.dtn.com> wrote in message =
news:eDKK2CGNEHA.640@.TK2MSFTNGP12.phx.gbl...
> Win2K Advanced Server , SQL2K Enterprise Edition(SP3). 80 GB database, =
3.7
> GB RAM. Cluster Service is running but currently there is no failover
> server. Currently the Perfmon counters Target Server Memeory and Total
> Server Memory are about 1682534 KB with only slight flucuations. AWE =
is not
> enabled nor is the /3GB switch. The server's memory setting is =
'Dynamically
> configure SQL Server memory'. Since this is a fairly active db I =
expect the
> memory usage to be closer to 2 GB.
>=20
> Why is it not maxing out memory up to 2 GB?
>=20
> I eventually want to enable memory greater than 2 GB. I believe all I =
need
> to do is enable AWE using sp_configure and restart the instance. Do I =
need
> the /3GB switch also? Should I set the max memory setting or leave it
> dynamic? If I set the max memory setting what should I set it to?
>=20
> Buffer Cache Hit Ratio - 98%+
> Average Page Life 20 - 1000 secs.
> CPU - 20% - 50 %
>=20
>

Memory usage

Win2K Advanced Server , SQL2K Enterprise Edition(SP3). 80 GB database, 3.7
GB RAM. Cluster Service is running but currently there is no failover
server. Currently the Perfmon counters Target Server Memeory and Total
Server Memory are about 1682534 KB with only slight flucuations. AWE is not
enabled nor is the /3GB switch. The server's memory setting is 'Dynamically
configure SQL Server memory'. Since this is a fairly active db I expect the
memory usage to be closer to 2 GB.
Why is it not maxing out memory up to 2 GB?
I eventually want to enable memory greater than 2 GB. I believe all I need
to do is enable AWE using sp_configure and restart the instance. Do I need
the /3GB switch also? Should I set the max memory setting or leave it
dynamic? If I set the max memory setting what should I set it to?
Buffer Cache Hit Ratio - 98%+
Average Page Life 20 - 1000 secs.
CPU - 20% - 50 %It has been a while since I have worked on a server that has had memory =
config set to 2GB, but if I remember correctly the servers that I worked =
on that were limited to 2GB of usage showed less (somewhere between 1.6 =
and 1.8GB). I think what you are seeing is normal.
You will want to add /3GB to the boot.ini. Yes, you would need to use =
sp_configure to enable AWE. You will also want to set min and max =
server memory (MB). Try setting min/max server memory to 3GB. =20
To be honest, I don't know that you will see a large performance =
increase in going from 2GB to 3GB of RAM on a server with an 80GB =
database. Then again, it depends on how the database is used.
--=20
Keith
"Dean" <deann@.dtn.com> wrote in message =
news:eDKK2CGNEHA.640@.TK2MSFTNGP12.phx.gbl...
> Win2K Advanced Server , SQL2K Enterprise Edition(SP3). 80 GB database, =
3.7
> GB RAM. Cluster Service is running but currently there is no failover
> server. Currently the Perfmon counters Target Server Memeory and Total
> Server Memory are about 1682534 KB with only slight flucuations. AWE =
is not
> enabled nor is the /3GB switch. The server's memory setting is =
'Dynamically
> configure SQL Server memory'. Since this is a fairly active db I =
expect the
> memory usage to be closer to 2 GB.
>=20
> Why is it not maxing out memory up to 2 GB?
>=20
> I eventually want to enable memory greater than 2 GB. I believe all I =
need
> to do is enable AWE using sp_configure and restart the instance. Do I =
need
> the /3GB switch also? Should I set the max memory setting or leave it
> dynamic? If I set the max memory setting what should I set it to?
>=20
> Buffer Cache Hit Ratio - 98%+
> Average Page Life 20 - 1000 secs.
> CPU - 20% - 50 %
>=20
>