<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic API Performance Issues in Report Server</title>
    <link>https://community.fabric.microsoft.com/t5/Report-Server/API-Performance-Issues/m-p/1180411#M14751</link>
    <description>&lt;P&gt;I am having a strange issue.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We have two servers, one with&amp;nbsp;&lt;SPAN&gt;Windows Server 2016 and the other with&amp;nbsp;Windows Server 2019. Both servers are running the latest May 2020 Power BI Report Server.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;When I make a simple API call:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="http://127.0.0.1/Reports/api/v2.0/System/AllowedActions" target="_blank" rel="noopener"&gt;http://127.0.0.1/Reports/api/v2.0/System/AllowedActions&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;On the Windows 2016 Server, it comes back in &amp;lt; 150 ms. Making the same call on the WIndows 2019 Server, it takes over 4+ seconds.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I wanted to rule out a first time run, or other issues, so I ran each command 10 times. It was consistent. &amp;lt; 150 ms for the 2016 Server and &amp;gt;4000ms for the 2019 Server.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I then ran some other tests, running the API call from various places to various endpoints:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;&lt;STRONG&gt;Ran From&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD&gt;&lt;STRONG&gt;API Endpoint&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD&gt;&lt;STRONG&gt;Time&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;Self&lt;/TD&gt;&lt;TD&gt;148ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;Self&lt;/TD&gt;&lt;TD&gt;4205ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;142ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;144ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Laptop&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;156ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Laptop&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;153ms&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As can be seen, calling the API from anywhere to anywhere gets fast response times, except for when I call the API from the Windows 2019 Server to itself.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I can't find any differences between the 2016 Server and the 2019 Server that might cause a difference. The only thing I know of off hand is that on 2016 we are running .Net Framework 4.7.2 and on 2019 it is running 4.8. But I doubt that would make the difference.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If anyone has any thoughts of ideas, i'm open. We have a simple web app that runs on the server to provide some details via the API. I know I coudl move it off to another server, but I'd rather keep it all together if possible.&lt;/P&gt;</description>
    <pubDate>Wed, 24 Jun 2020 19:53:16 GMT</pubDate>
    <dc:creator>BenMackin</dc:creator>
    <dc:date>2020-06-24T19:53:16Z</dc:date>
    <item>
      <title>API Performance Issues</title>
      <link>https://community.fabric.microsoft.com/t5/Report-Server/API-Performance-Issues/m-p/1180411#M14751</link>
      <description>&lt;P&gt;I am having a strange issue.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We have two servers, one with&amp;nbsp;&lt;SPAN&gt;Windows Server 2016 and the other with&amp;nbsp;Windows Server 2019. Both servers are running the latest May 2020 Power BI Report Server.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;When I make a simple API call:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="http://127.0.0.1/Reports/api/v2.0/System/AllowedActions" target="_blank" rel="noopener"&gt;http://127.0.0.1/Reports/api/v2.0/System/AllowedActions&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;On the Windows 2016 Server, it comes back in &amp;lt; 150 ms. Making the same call on the WIndows 2019 Server, it takes over 4+ seconds.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I wanted to rule out a first time run, or other issues, so I ran each command 10 times. It was consistent. &amp;lt; 150 ms for the 2016 Server and &amp;gt;4000ms for the 2019 Server.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I then ran some other tests, running the API call from various places to various endpoints:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE border="1"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;&lt;STRONG&gt;Ran From&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD&gt;&lt;STRONG&gt;API Endpoint&lt;/STRONG&gt;&lt;/TD&gt;&lt;TD&gt;&lt;STRONG&gt;Time&lt;/STRONG&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;Self&lt;/TD&gt;&lt;TD&gt;148ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;Self&lt;/TD&gt;&lt;TD&gt;4205ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;142ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;144ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Laptop&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2016&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;156ms&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Laptop&lt;/TD&gt;&lt;TD&gt;&lt;SPAN&gt;Windows Server 2019&lt;/SPAN&gt;&lt;/TD&gt;&lt;TD&gt;153ms&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As can be seen, calling the API from anywhere to anywhere gets fast response times, except for when I call the API from the Windows 2019 Server to itself.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I can't find any differences between the 2016 Server and the 2019 Server that might cause a difference. The only thing I know of off hand is that on 2016 we are running .Net Framework 4.7.2 and on 2019 it is running 4.8. But I doubt that would make the difference.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If anyone has any thoughts of ideas, i'm open. We have a simple web app that runs on the server to provide some details via the API. I know I coudl move it off to another server, but I'd rather keep it all together if possible.&lt;/P&gt;</description>
      <pubDate>Wed, 24 Jun 2020 19:53:16 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Report-Server/API-Performance-Issues/m-p/1180411#M14751</guid>
      <dc:creator>BenMackin</dc:creator>
      <dc:date>2020-06-24T19:53:16Z</dc:date>
    </item>
  </channel>
</rss>

