Your system configuration for one could be the problem. You have mentioned what hardware you have but you have not told us how the system is configured and what other software and services are running on that server and network

eg you might have 40 GB RAM but how much is actually reserved for the DB?
Then looking at your Bandwidth 256k (32KBps) for 100 users... thats a pushing it dont you think? For all intents and purposes your hardware should not be a problem with those specs especially on SQL Server 2005.

Steve

---

From: "muskiv" <kulebak@gmail.com>
To: "Skunkworks forum" <skunkworks@lists.my.co.ke>
Sent: Tuesday, November 29, 2011 10:34:16 AM
Subject: [Skunkworks] Performance degradation - Help sought

Skunkers,

Here's the scenario:

There is a core application that is build on a 2 tier client/Server architecture.

Total number of users at any one time over a WAN is approx 100.

The app runs on a MS SQL 2005 DB that resides on a Primary server whose specs are as follows:

1. RAM: 40 GB

2. CPUs - 8 Proliant QUAD Core E7320 2x2M cache processors

3. Network Interface: Gigabit ethernet card

4. RAID 5 config for the main DB drives - where the main DB files reside. 

5. RAID 1 + 0 config for the log files on a seperate disk

6. WAN traffic is on 256k/256k links from satellite locations

The problem: 

1. As users are being added into the WAN, performance has been deteriorating.

2. On report generation, everything seems to crawl to a halt.

What are the likely contributors to performance degradation?

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke