Quote Originally Posted by gep13 View Post
Without seeing some of the code that you are using, it is going to be difficult to say. It sounds as though there is some sort of deadlock happening. Have you instrumented the site (i.e. added logging to the site)? It would be good to see at which point the bottle neck is happening.

Gary
The code that does all the basic log in stuff is identical to the code on half a dozen systems already running. The only difference is that this is the first site developed in VS2010 - Framework 4.0 - and deployed on a server running IIS 7.5.

All the other apps are on a Windows 2003 server running IIS 6. Logging ... every table in the database has an audit table which records every insert, update and delete - but I don't record each time a table is accessed.

I can't see there being a lock in the database - when the site is accessed the only thing that runs is a stored procedure which comprises one select statement - it either returns some user data or it doesn't.

I'm thinking this is some sort of permissions / authentication issue to do with IIS 7.5?