0

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.

In the last 2 weeks I've notice that the procedure TempInsertStateItemShort is taking more than 1 second to run.

does anyone had experience that? How can I improve performance on ASPState database?

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)

Thanks in advance!!!!

nozari
  • 504
  • 4
  • 8
  • If memory serves, the TempInsertStateItemShort SPROC indicates that your session is less than 7,000 bytes in size; otherwise it would be using the TempInsertStateItemLong. I think you need help on profiling/optimizing the SPROC involved and I suggest you post this question to [DBA StackExchange](http://dba.stackexchange.com/) – Karl Anderson Jun 24 '13 at 15:00
  • Thanks Karl, I will post this question there. – nozari Jun 24 '13 at 16:15
  • for the record: http://dba.stackexchange.com/questions/45172/tempinsertstateitemshort-procedure-on-aspstate-is-taking-more-than-1-second-to-e – nozari Jun 24 '13 at 19:56

0 Answers0