Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Enabling HTTP keep alive
Message
De
06/10/2010 03:40:47
 
 
À
04/10/2010 17:04:07
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01483751
Message ID:
01484107
Vues:
32
>I think this is related to SQL Server. Basically, if I go in my Hit table, I see that this first hit takes 5 seconds instead of 0.2 second. That is the time the hit took to be processed. So, it went immediately in the hit but took longer to execute. I will activate a SQL trace and see how it goes the next time. So, on that particular SQL Server, there could be a setting that forces it to go to sleep if no hit against SQL Server has been done within two minutes. Could that be?

Doesn't this bring us back to the SQL Connection pool issue already discussed? Bear in mind that there will be a connection pool for each connection configuration. But even if you were not using pooling the delay seems excessive.

Do you have your own instance of SQL Server? If not then other sites using that instance may be affecting the workload....
Maybe it's just an intermitent networking problem?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform