title: TempInsertStateItemShort procedure on ASPState is taking more than 1 second to execute
body: <p>I'm working on a .NET website who runs in load balance within more than one server and because of that I need to have my session on SQL Server.</p>
  
  <p>In the last 2 weeks I've notice that the procedure <strong>TempInsertStateItemShort</strong> is taking more than 1 second to run.</p>
  
  <p>does anyone had experience that? How can I improve performance on ASPState database?</p>
  
  <p>Here some extra information
  - currently there is about 10k users on site
  - about 1k users simultaneous
  - ASPState database has size of 3mb only (we don't use much Session, only for few things)</p>
  
  <p>Thanks in advance!!!!</p>