Post reply

Initial SQL connection very slow

  • February 12, 2004 at 9:52 am

    #493838

    Hi,

    Have you considered DNS / name resolution problems?

    Do the database connection settings use an name or an IP address?  If it is a name, it maybe having trouble resolving it, and then finally it broadcasts - which is why you get an initial pause.

     

  • February 12, 2004 at 11:41 am

    #493858

    Thanks for your help,

    no, it's not DNS. I am using an IP and the ping is less than 1ms. Are there any settings in SQL serer I need to adjust, or can I somehow establish a permanent connection between my webserver and SQL Server?

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply