November 4, 2004 at 4:14 am
I have a machine in the DMZ of a firewall that can connect to SQL Server inside the LAN. However the initial connection for Enterprise Manager takes nearly a minute to establish, once connected performance is pretty good. There is also a website that uses this method and as the connection drops when not used for a while it takes ages for users to reconnect. So can I improve the speed of the making a connection? or can I get the website to keep it's connection open?
November 4, 2004 at 12:34 pm
I've seen some minor latency with similar setups. If you're not or even if you're using the standard 1433 TCP/ 1434 UDP ports, you may want to go to SQL Server Client Network Utility on DMZ machines configuration and setup an alias and specify the Port number (uncheck Dymanically determine port). I didn't do any serious metrics but found the connectivity to be more reliable across the DMZ. Also, if you're not using Named Pipes and/or NW Link IPX/SPX, make sure those protocols are at least not active on the client. You may also want to uncheck Enable shared memory protocol; though, that would not route on the network.
Last, check the routers and firewalls between the DMZ and the MSSQL Server. If you have have a lot of traffic, it's possible that the router or firewall CPU/memory cannot keep up. I've seen that once.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply