On Tue, Nov 29, 2011 at 10:48 AM, Steve Obbayi <steve@sobbayi.com> wrote:

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

The server is NOT running AD or any other of those services. Its dedicated to the DBMS. Any other specific services that you'd like to highlight?

eg you might have 40 GB RAM but how much is actually reserved for the DB?

From the little understanding that I have, SQL intelligently reserves memory for itself even without intervention.

Then looking at your Bandwidth 256k (32KBps) for 100 users... thats a pushing it dont you think?

Let me correct that. The 100 users are acros 13 sites with each having roughly 8 - 10 users. Each of these sites has a 256K link

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

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke