Sorry, I wasn't really asking you a question, I was giving my opinion on where you should start looking for the source of your problems, i.e. start by checking if the database is the culprit, then move to the platform etc

However, given @sobbayi comments, maybe you might want to bump network to number 2.

Reports are generally data heavy, which equals increased database and bandwidth use.

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

See my responses

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.

ok 

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

_______________________________________________
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

_______________________________________________
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