title: SQL Server running slow
body: <p>I have <code>SQL</code> job that runs every night which does various <code>inserts/updates/deletes</code>. The job contains 40 steps which mainly execute stored procedures. </p>
  
  <p>It's been running fine up until a week ago when suddenly the run time went up from <code>2.5 hours</code> to <code>over 5 hours</code>, sometimes even <code>8,9,10!</code></p>
  
  <p>Could one you please give me any pointers?</p>