On Tue, Nov 29, 2011 at 10:43 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:

What platform is your app built on?

Making a guess here, you need to identify and isolate your potential bottlenecks, here are my suggestions in order of culpability:

1. Database:- Watch that database like a hawk! I would bet my money on it being the culprit. There's this app called Spotlight on SQL Server, see if you can get your hands on one.

2. Application Platform:- Is it .Net, Java etc, each comes with its own "environment" which could be the culprit

VB. Form based not web based app

3. Operating System

WIN2k3

4. Network

No sure I understand this bit of the qstn

On Tue, Nov 29, 2011 at 10:34 AM, muskiv <kulebak@gmail.com> wrote:

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
------------
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

--
Regards,
Peter Karunyu
-------------------

_______________________________________________
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