sql server - Dynamics GP 2010 Awful Report Performance -


we running dynamics gp 2010 on 2 load balanced citrix servers. past 3 weeks have had severe performance hits when users running fixed assets reporting. database large in size, when run reports locally on sql server, run great. sql server seems performing adequately when users seeing slow performance.

any ideas?

just because db seems un-stressed, not mean fine. contain other bottlenecks. typically, if db server not maxing-out cpus occasionally, means there bigger problem.

standard process troubleshooting performance problems on data driven app go this:

  1. tune db indexes. tuning wizard in ssms great starting point. if haven't tried yet, great starting point.
  2. check resource utilization: cpu, ram. if cpu maxed-out, consider adding/upgrading cpu or optimize code or split tiers. if ram maxed-out, consider adding ram or split tiers.
  3. check hdd usage: if queue length goes above 1 (more once per 10 seconds), upgrade disk bandwidth or scale-out disk (raid, multiple mdf/ldfs, db partitioning).
  4. check network bandwidth
  5. check problems on app (dynamics) server

Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more