Performance / Paging

Hi,
While monitoring one of my clients servers, I notice memory paging of
between 50 and 60 pages per second. However, the server has 4gb of memory
and it is currently only using 1.6gb. Why would the server have any
paging at all?
Thanks
Bill
Hi Bill,
Form your descriptions, I understood that your SQL Server was limited in
1.6 GB memory while you have 4 GB memory on the box. Have I understood you?
Correct me if I was wrong.
Based on my socpe, first of all, when using 4 GB memory, I would like to
confirm that you had followed the knowledge base article below to
confirgure your SQL Server
How to configure memory for more than 2 GB in SQL Server
http://support.microsoft.com/kb/274750
If it was not done, SQL Server will not be able to access more than 2 GB
memory.
Secondly, when paging still goes so high, you'd better try to trace what is
going on with SQL Server by Profiler. Please understood that Performance
issue tend to very complex and we are not able to go further in this topic,
anyway, the following knowledge base articles will help much
HOW TO: Troubleshoot Application Performance with SQL Server
http://support.microsoft.com/kb/224587
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hey Michael,
Thanks for the response. SQL Server 2000 is configured to dynamically
configure it's memory and the box has 4GB. Using both PerfMon and Quest's
Spotlight on SQL Server, I noticed that there was a lot of paging. But,
the server was only using 1.6gb.
After reading those articles, I am concerned and confused.
Am running SQL Server 2000 Standard on Windows 2000 Server
1st, I can't find anything anywhere on configuring Windows 2000 to use AWE.
And, the article says the /3GB and /PAE is not available on Win2000 Server.
This also comes from the article.
[[Normally, both the SQL Server 2000 Enterprise Edition and SQL Server 2000
Developer Edition can use up to 2 GB of physical memory. With the use of the
AWE enable option, SQL Server can use up to 4 GB of physical memory. ]]
Does this mean in my config, SS can only use 2GB?
(Can you run SS Standard on 2000 Advance Server?)
Thanks for helping out.
Bill
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:be88i9C2EHA.2732@.cpmsftngxa10.phx.gbl...
> Hi Bill,
> Form your descriptions, I understood that your SQL Server was limited in
> 1.6 GB memory while you have 4 GB memory on the box. Have I understood
> you?
> Correct me if I was wrong.
> Based on my socpe, first of all, when using 4 GB memory, I would like to
> confirm that you had followed the knowledge base article below to
> confirgure your SQL Server
> How to configure memory for more than 2 GB in SQL Server
> http://support.microsoft.com/kb/274750
> If it was not done, SQL Server will not be able to access more than 2 GB
> memory.
> Secondly, when paging still goes so high, you'd better try to trace what
> is
> going on with SQL Server by Profiler. Please understood that Performance
> issue tend to very complex and we are not able to go further in this
> topic,
> anyway, the following knowledge base articles will help much
> HOW TO: Troubleshoot Application Performance with SQL Server
> http://support.microsoft.com/kb/224587
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
|||Hi Bill,
Thanks for your prompt updates!
SQL Server 2000 Enterprise Edition is able to support 4 GB physical memory
in Windows 2000 Server. See Table "Maximum Amount of Physical Memory
Supported by the Editions of SQL Server 2000" under topic "Maximum Capacity
Specifications" in BOL or MSDN Online:
http://msdn.microsoft.com/library/de...us/architec/8_
ar_ts_8dbn.asp
Notice the words "With the use of the AWE enable option, SQL Server can use
up to 4 GB of physical memory. " in KB: Q274750, which means using 4GB
memory for SQL Server 2000 Enterprise in Windows 2000 Server, you are
required to open AWE enable option. Example:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 4096
RECONFIGURE
GO
Hope it clarifies and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||AWE uses memory differently. So, on a server with 4 GB of physical memory,
there are a couple of ways to configure its usage.
If you are running SQL Server 2000 Enterprise Edition, you can enable AWE
support and address up to 2 GB in the active memory and up to 2 GB in the
AWE memory pools, regardless of the Windows edition.
With Windows Advanced Server, you could specify the /3GB boot.ini file
parameter and address up to 3 GB in the active memory and up to 1 GB in the
AWE memory pools, again with SS Enterprise Edition.
With Windows Advanced Server, you could also specify the /PAE boot.ini file
parameter and address more than 4 GB if the server had more installed on it;
however, depending on the status of the /3GB parameter, the additional
memory would be relugated to the AWE pool.
If you are running SQL Server Standard Edition, you will be limited to the
USER MODE memory area only because it does not support AWE; however, if you
are running Advanced Server, you can still set the /3GB switch, which
changes the size of the USER MODE area. This would be available to SQL
Server Standard Edition. The question is: will SS SE address it? I do not
believe there is any sort of governor that would preclude it just the
inability to support AWE.
Sincerely,
Anthony Thomas

"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:KmtM69O2EHA.2732@.cpmsftngxa10.phx.gbl...
Hi Bill,
Thanks for your prompt updates!
SQL Server 2000 Enterprise Edition is able to support 4 GB physical memory
in Windows 2000 Server. See Table "Maximum Amount of Physical Memory
Supported by the Editions of SQL Server 2000" under topic "Maximum Capacity
Specifications" in BOL or MSDN Online:
http://msdn.microsoft.com/library/de...us/architec/8_
ar_ts_8dbn.asp
Notice the words "With the use of the AWE enable option, SQL Server can use
up to 4 GB of physical memory. " in KB: Q274750, which means using 4GB
memory for SQL Server 2000 Enterprise in Windows 2000 Server, you are
required to open AWE enable option. Example:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 4096
RECONFIGURE
GO
Hope it clarifies and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!