Whenever someone logs on to my website they have to authenticate with a username / password through SQL Server. This is initially very slow (>5 seconds). However subsequent db requests or logins are almost immediate.
I believe my dedicated webserver needs to establish a connection to the SQL server which is initially costly, but then connection pooling kicks in. When I had my website on a shared webserver initial connections were much faster. is that because other poeple's websites on that server and initial connection could have been established earlier or is my new host just slower? Does each website in IIS and each server user have their own connection and pooling?
Could I fix this issue? Can my global.asa have a permanent connection to my website or some script run every minute and connect to the DB? How long is a default timeout to reconnect to a SQl database? Any ideas how I can overcome this costly intitial connection any other way, i.e. changing settings in SQL Server?