title: Will Partitioned tables work same with Entity Framework
body: <p>I have a database with a Table <code>MonitoringRecords</code>, I am inserting data using Entity Framework.</p>
  
  <p>No the Problem is that I now have about 300,000 records in this table. </p>
  
  <p>And now the SQL-server CPU Utilization is about 98% with 3.6 GB RAM Utilization.</p>
  
  <p>I ran the script I found here: <a href="https://stackoverflow.com/questions/10319575/sql-server-2008-high-cpu-usage">SQL Server 2008 High CPU usage</a></p>
  
  <p>and found out the Inserting data to the Table <code>MonitoringRecords</code>, is using up all the CPU.</p>
  
  <p>So I looked for a solution, And I found Table partitioning.</p>
  
  <p><a href="http://technet.microsoft.com/en-us/library/ms190787.aspx" rel="nofollow noreferrer">http://technet.microsoft.com/en-us/library/ms190787.aspx</a></p>
  
  <p>I want to Partition my Table with Respect to Date.</p>
  
  <ol>
  <li>So I want to ask is that will this affect any part of my code?    </li>
  <li>Will i have to re-code my Entity Framework Insertion code?</li>
  <li>Will this increase the performance?</li>
  </ol>
  
  <p>Any other tips on how to solve this problem I am having? </p>