title: SQL Server 2014 レスポンス不良
body: <h3>Premises / What you want to achieve</h3>
  <p>With the server replacement, the version of SQL Server was upgraded.</p>
  <p>At that time, an event occurred in which repetition worsened compared to the old environment. I am in trouble without improvement.</p>
  <h3>Problems and error messages that have occurred</h3>
  <p>Event①Response deteriorated in client-server system. Login etc. as a whole.</p>
  <p>Event ②</p>
  <p>Accessing a linked server configured with Oracle Provider for OLE DB deteriorates a simple select process of 30,000 records from a few seconds to two and a half minutes.</p>
  <h3>environment</h3>
  <p>&quot;Old environment&quot;</p>
  <ul>
  <li>Build on VMWare</li>
  <li>Windows Server 2008 R2 Standard SP1</li>
  <li>SQL Server 2014 32-bit version (12.0.5000.0)</li>
  <li>Link server consists of Microsoft OLE DB Provider for Oracle</li>
  </ul>
  <p>&quot;New environment&quot;</p>
  <ul>
  <li>Build on VMWare</li>
  <li>Windows Server 2012 R2 Standard</li>
  <li>SQL Server 2014 64-bit version (12.0.5000.0)</li>
  <li>Link server consists of Oracle Provider for OLE DB</li>
  </ul>
  <h3>Things I tried</h3>
  <p>I thought it was related to the network, but I couldn't find any noticeable phenomena by monitoring the performance monitor.</p>
  <p>The same applies to other CPUs, memories, disks, etc.</p>
  <p>Also, if data is obtained from an external DB without using a linked server, it can be obtained in a normal time, so it is speculated that this is a SQL Server problem.</p>
  <p>I would like you to teach me how to identify the cause.  Thank you</p>