On Tue, Nov 29, 2011 at 11:01 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
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
Noted
However, given @sobbayi comments, maybe you might want to bump network to number 2.
I clarified @sobbayi's network concern
Reports are generally data heavy, which equals increased database and bandwidth use.
Thx
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<http://www.quest.com/spotlight-on-sql-server-enterprise/>, 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