title: SQL Server simple Insert statement times out
body: <p>I have a simple table with 6 columns. Most of the time any insert statements to it works just fine, but once in a while I'm getting a DB Timeout exception:
  Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.</p>
  
  <p>Timeout is set to 10 seconds.</p>
  
  <p>I should mention that I'm using NHibernate and that the statement also include a "select SCOPE_IDENTITY()" right after the insert itself.</p>
  
  <p>My thought was that the table was locked or something, but there were no other statements running on that table at that time.</p>
  
  <p>All the inserts are very simple, everything looks normal in sql profiler, the table has no indices but the PK (Page fullness: 98.57 %). </p>
  
  <p>Any ideas on what should I look for?</p>
  
  <p>Thanks.</p>