Sorry, I wasn&#39;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<br>
<br>However, given @sobbayi comments, maybe you might want to bump network to number 2.<br><br>Reports are generally data heavy, which equals increased database and bandwidth use.<br><br><br><div class="gmail_quote">On Tue, Nov 29, 2011 at 10:54 AM, muskiv <span dir="ltr">&lt;<a href="mailto:kulebak@gmail.com">kulebak@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><font color="#cc0000">See my responses</font><br><br><div class="gmail_quote"><div class="im">On Tue, Nov 29, 2011 at 10:43 AM, Peter Karunyu <span dir="ltr">&lt;<a href="mailto:pkarunyu@gmail.com" target="_blank">pkarunyu@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">What platform is your app built on?<br><br>Making a guess here, you need to identify and isolate your potential bottlenecks, here are my suggestions in order of culpability:<br>

<br>1. Database:- Watch that database like a hawk! I would bet my money on it being the culprit. There&#39;s this app called <a href="http://www.quest.com/spotlight-on-sql-server-enterprise/" target="_blank">Spotlight on SQL Server</a>, see if you can get your hands on one.<br>

</blockquote></div><div><font color="#cc0000">ok</font> </div><div class="im"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
2. Application Platform:- Is it .Net, Java etc, each comes with its own &quot;environment&quot; which could be the culprit<br></blockquote><div><br></div></div><div><font color="#cc0000">VB. Form based not web based app</font></div>

<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">3. Operating System<br></blockquote><div><br></div><div><font color="#cc0000">WIN2k3 </font></div>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">4. Network<br><br></blockquote><div><font color="#cc0000">No sure I understand this bit of the qstn</font> </div><div>
<div></div><div class="h5">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br><div class="gmail_quote"><div><div></div><div>On Tue, Nov 29, 2011 at 10:34 AM, muskiv <span dir="ltr">&lt;<a href="mailto:kulebak@gmail.com" target="_blank">kulebak@gmail.com</a>&gt;</span> wrote:<br>


</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div></div><div>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 color="#990000">What are the likely contributors to performance degradation</font></b>?</div><div><br></div><div><br></div></div>
<br></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><font color="#888888"><br><br clear="all"><br>-- <br>Regards,<br>Peter Karunyu<br>-------------------<br>
</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div></div></div><br>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br><br>