you my friend need something like Citrix , well on the other hand check if the DB is well indexed (consult a MSSQL guru), 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
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