DataAdapter.Fill performance anomaly
<p>I have two <code>DataBases</code> (<code>DB1</code> &amp; <code>DB2</code> : both DBs are same, <code>DB2</code> is created from the backup of <code>DB1</code>). When I run a stored procedure <code>SP1</code> on both <code>DBs</code> it takes approximately 2 seconds to give me an output (<code>select</code> statements) on both <code>DBs</code>.</p>

<p>Now the problem is when I point these <code>DBs</code> from  a <code>service</code> and try to use <code>DataAdapter.Fill</code> method, it gives me different time(<strong>54 - 63 seconds</strong> on <code>DB1</code> and <strong>42 - 44 seconds</strong> on <code>DB2</code>) on both <code>DBs</code> consistently. Noted that I'm using same service  to point <code>DBs</code> so it couldn't be service behave/performance. Now my question is:</p>

<p><strong>What could be the reason for this?</strong> Any suggestions are welcome that <strong><em>What should I look into</em></strong>?</p>

<blockquote>
  <p><strong><em>Helping Info:</em></strong> </p>
  
  <ol>
  <li><p>Both DB are on different <code>servers</code>(identical configuration) but since executing the <code>SP</code> on <code>SQL Server Management Studio</code> take the same time
  on both <code>DBs</code> so I ruled out the possibility of <code>DB</code> <code>server</code> performance. 
  Network delay could be a factor But higlly unlikely  as both <code>servers</code>
  are on same network and infact on same physical location. This is my
  last option to check.</p></li>
  <li><p>Some other services are using <code>SQLDependency</code> ON <code>DB1</code>. Which consistently fill <code>DataAdapter(s)</code>, could this be the reason for my 
  <code>DataAdapter</code> <code>fill</code> method to slow down? (less likely as I'm guessing)</p></li>
  </ol>
</blockquote>

<p>As requested in comments below is code that is filling the <code>DataSet</code>:</p>

<p><a href="https://i.stack.imgur.com/REYyY.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/REYyY.jpg" alt="DataSet Fill"></a></p>

<blockquote>
  <p><strong><em>PS: The time mentioned above is the execution time of the code line highlighted in the above image.</em></strong></p>
</blockquote>