See my responses On Tue, Nov 29, 2011 at 10:44 AM, geoffrey gitagia <ggitagia@gmail.com>wrote:
you my friend need something like Citrix ,
Does it always have to go the citrix way.......shld be the last result may be
well on the other hand check if the DB is well indexed (consult a MSSQL guru),
Ok
make sure your queries are optimized (i.e. there are cases you can use views instead of querying a whole table ) assuming you don't have them and finally get your server logs !!!! and analyse them
I'll need to further investigate the logic behind the queries. Thx
From an admin point of view
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
-- GG
_______________________________________________ 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