title: What options are there for caching SQL data?
body: <p>I have a SQL Server that is accessed by a simulation server.</p>
  
  <p>The simulation server runs 70 processes (C# instances) that each request the SAME large data table from SQL Server and run a simulation (with different parameters) on it.</p>
  
  <p>This slows down my SQL Server greatly, and I see CPU usage maxing out on the activity monitor. </p>
  
  <p>Several questions:</p>
  
  <ol>
  <li><p>So is this really causing SQL Server to slow down? I have created all the indexes my query suggested. I thought sql server had inbuilt smart caching that would alleviate such repeated requests. Perhaps I have not set it up correctly?</p></li>
  <li><p>If this is a problem, and I need to cache data locally on my simulation server. Is there some "SQL remote app" that could do this for me? Or do I need to create my own data caching app in C#?</p></li>
  </ol>