Skunkers,<div><br></div><div>Here&#39;s the scenario:<div><br></div><div>There is a core application that is build on a 2 tier client/Server architecture.</div><div><br></div><div>Total number of users at any one time over a WAN is approx 100.</div>
<div><br></div><div>The app runs on a MS SQL 2005 DB that resides on a Primary server whose specs are as follows:</div><div><br></div><div>1. RAM: 40 GB</div><div>2. CPUs - 8 Proliant QUAD Core E7320 2x2M cache processors</div>
<div>3. Network Interface: Gigabit ethernet card</div><div>4. RAID 5 config for the main DB drives - where the main DB files reside. </div><div>5. RAID 1 + 0 config for the log files on a seperate disk</div><div>6. WAN traffic is on 256k/256k links from satellite locations</div>
<div><br></div><div>The problem: </div><div><br></div><div>1. As users are being added into the WAN, performance has been deteriorating.</div><div>2. On report generation, everything seems to crawl to a halt.</div><div><br>
</div><div><b><font class="Apple-style-span" color="#990000">What are the likely contributors to performance degradation</font></b>?</div><div><br></div><div><br></div></div>