AR7 very slow with windows server 2012 reemote app

AR7 very slow with windows server 2012 reemote app

Posted by: paoloz on 14 September 2017, 9:32 am EST

• 

  paoloz

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 9:32 am EST

  [activereports_archive]Good day,
  
  I have a performance problem with a very easy windows forms application that use ar7 (last version) and is hosted on a windows server 2012 remote app. The report, that usually take 2 seconds, in this environment use 1 minute !

  My test with the same application and huge processor/ram environments:

  1. windows server 2008 remote app - 2 seconds
  2. windows server 2012 remote app - 1 minute !!!
  3. windows server 2008 remote desktop - 3 seconds
  4. windows server 2012 remote desktop - 3 seconds
  5. windows 8 desktop - 1 second

  What’s the problem with win server 2012 remote app ?

  PS: win server 2012 remote app, when the report is running, has low processor activity and ram usage

  [/activereports_archive]

• 

  wvdbroek

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 9:32 am EST

  [activereports_archive]A couple of weeks ago, one of my customers moved from Windows 7 PC’s to Windows 2012 server through RDP. ActiveReports performs terribly. But also loading grids (from Infragistics NetAdvantage) takes much more time. I have not yet found a solution, but - in my case - it seems the terrible performance is caused by SQL Server 2012 on Windows 2012 server.[/activereports_archive]

• 

  gskal

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 9:32 am EST

  [activereports_archive]Hello,

  I regret to mention but the issue was not replicable on loading and previewing a very simple report.
  
  Moreover, it does not seem to be a control specific issue.

  However, on further searching, I found the following links that might be helpful for you in resolving your problem :
  
  http://serverfault.com/questions/332622/find-out-the-bottleneck-for-windows-remote-desktop-server-terminal-server
  
  http://social.technet.microsoft.com/Forums/windowsserver/en-US/8b352070-8cdd-42f5-a0d7-13100e89c9c6/major-lag-performance-issues-win2k8r2-rdp?forum=winserverTS
  
  http://social.technet.microsoft.com/Forums/en-US/79eba10e-07b0-45a8-8eed-f0788ce0f2c0/rdp-performance-in-windows-8?forum=W8ITProPreRel

  Regards,
  
  Mohita[/activereports_archive]

• 

  mohita

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 9:32 am EST

  [activereports_archive]Hello,

  I regret to mention but the issue was not replicable on loading and previewing a very simple report.
  
  Moreover, it does not seem to be a control specific issue.

  However, on further searching, I found the following links that might be helpful for you in resolving your problem :

  http://serverfault.com/questions/332622/find-out-the-bottleneck-for-windows-remote-desktop-server-terminal-server

  http://social.technet.microsoft.com/Forums/windowsserver/en-US/8b352070-8cdd-42f5-a0d7-13100e89c9c6/major-lag-performance-issues-win2k8r2-rdp?forum=winserverTS

  http://social.technet.microsoft.com/Forums/en-US/79eba10e-07b0-45a8-8eed-f0788ce0f2c0/rdp-performance-in-windows-8?forum=W8ITProPreRel

  Regards,
  
  Mohita[/activereports_archive]

• 

  paoloz

  • Post Options:
  • Link
    Copy

  Posted 14 September 2017, 9:32 am EST

  [activereports_archive]Hi Mohita,
  
  I have other elements for you:

  Environment:

  1. windows server 2012 remote app and windows server 2012 remote desktop
  2. one page report
  3. last ar7 build
  4. access to remote app via internet (adsl relatively slow connection)

  From nothing to preview:

  1. Ar3 - 2 seconds
  2. Ar7 - 25 seconds

  From preview to print (with button ‘print’ of the vierwer)

  1. Ar3 - 1 second
  2. Ar7 - 20 seconds

  At this point I can imagine that Ar7 needs something for print and have to ask (and wait) to the os. I have put the lines before the Rpt.Run method:

  float TmpWidth = (Rpt.PageSettings.PaperWidth + Rpt.PageSettings.Margins.Left + Rpt.PageSettings.Margins.Right) * (float)100;
  
  float TmpHeight = Rpt.PageSettings.PaperHeight * 100;

  Document.Printer.PaperKind = System.Drawing.Printing.PaperKind.Custom;
  
  Document.Printer.PaperSize = System.Drawing.Printing.PaperSize(“Custom Paper Size”, (int)Math.Ceiling(TmpWidth), (int)Math.Ceiling(TmpHeight));

  Now Ar7 is very fast: 2 seconds from nothing to preview !!!
  
  From the viewer print button to print always 20 seconds …

  My conclusion: ar7 needs to know the paper size and kind and makes a call to os; this call is very slow in 2012 remote app. If I tell to ar7 paper related informations, it don’t need to call the os and for this reason is very fast. I’m wrong ?

  Now is very fast but I have problems with the paper width and height. Can you give me a code snippet with the right way to set the paper size and kind reading from the report ?

  Thank you, Paolo.

  PS: with citrix, everything work fine and very fast without any setting of paper size and kind.
  
  [/activereports_archive]

• 

  rderenko

  • Post Options:
  • Link
    Copy

  Posted 29 January 2018, 1:03 am EST

  Hello ActiveReports,

  Was this issue resolved ?
  
  If yes - what is the fix ?

  I have similar issue with moving to windows server 2012 R2…

  Thanks