February 12, 2004 at 1:13 pm
Anyone have an idea on this?
February 12, 2004 at 1:13 pm
is your database set to autoclose?
Cheers,
- Mark
February 12, 2004 at 5:41 pm
no, i checked that. autoclose is turned off. is there maybe a way to establish a permanent or cached connection between the web server and SQL server or set SQl server up differently?
February 12, 2004 at 10:24 pm
If your webserver and database were on same machine initially, they would have used named pipes for communications, which is a bit faster them TCPIP. try switching to named pipes connection in your web server.
refer to BOL for details on Named Pipes vs. TCPIP
-- Amit
February 13, 2004 at 12:12 pm
no, they are on different machines and use tcp/ip.
February 13, 2004 at 12:47 pm
Do you notice any improvement from specifying port number (1433?) rather than dynaically determining the sql server port?
Cheers,
- Mark
Viewing 6 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply