Server 2003 memory performance configuration

32960 pts.
Tags:
Microsoft Windows Server 2003
Server Performance
SQL
SQL Server
Windows Server Performance
We have a SQL application running in an n-tier environment. Some of the users are complaining about application performance. I am going through the environment looking at all of the elements involved in processing this application. The information below shows all of the server systems involved in the application and the page file and RAM configurations. What issues do you see with this configuration (if any) and what changes would you recommend to enhance performance? Thanks for your assistance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

The machines which have large page files probably need more RAM.

Have you identified which layer of the application the performance problems are coming from?

Is the database running slow, is the web server running slow, are the term servers running slow?

Without identifying which layer is causing the problem you won’t have much luck looking at the entire system.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Labnuke99
    Forgot the memory configuration in the question. Sorry for any confusion. Is it an issue when there is a discrepancy between the current allocation and the system recommended page file settings? Should the page file size be "hard set"? Each server is running Windows Server 2003 Server1 - SQL Page file: system managed, current allocation: 3.5GB, system recommended: 5GB installed RAM: 4GB Server2 - WEB Page file: system managed, current allocation: 14.3GB, system recommended: 5GB installed RAM: 4GB Server3 - terminal server1 Page file: system managed, current allocation: 4GB, system recommended: 3GB installed RAM: 2GB Server4 - terminal server2 Page file: system managed, current allocation: 4GB, system recommended: 6GB installed RAM: 4GB Server5 - terminal server3 Page file: system managed, current allocation: 10.7GB, system recommended: 5GB installed RAM: 4GB Server6 - terminal server4 Page file: system managed, current allocation: 16.1GB, system recommended: 6GB installed RAM: 4GB Server7 - data capture server Page file: system managed, current allocation: 8GB, system recommended: 6GB installed RAM: 4GB
    0 pointsBadges:
    report
  • Labnuke99
    Will adding memory above 4GB to a 32-bit machine really help? We were not planning on moving the servers to 64-bit architecture. Since it is an n-tier architecture, I am thinking that there could be problems at several points along the path creating the slow performance being reported by users. I am looking along the entire processing path and questioning items that seem out of place to be sure the configuration is as robust as possible. I am looking at some perfmon stats today that I have captured over the past few days on most of the servers to see if that will shed any light on resource problems. Any tips on looking at memory or processor utilization? I totally understand the network side of things and I am not seeing a network issue here. The traffic volume is low. There are no errors on the interfaces. There are not packet retransmits. I appreciate any guidance on the server side of things. Thanks for your time!
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following