We have a credit card prgram that runs on its own W2K server. It came with MSSQLServer 7 (or MSDE as it appears in the Program menu) as the backend DB.
Been working great for weeks. Put a firewall on the LAN last Friday and made sure ports HTTPS and tcp 1433 were allowed to this server. Changed the server's ip address from it's public to a private at time of firewall implementation (using NAT and PAT).
Still worked fine until.....yesterday evening. Since then it is extremely slow in response time - UNLESS - unless I unplug the server from the network. Then it runs great!
Monday evening I installed a syslog daemon on this machine to log the firewall's activity.
This morning I stopped and uninstalled the syslog service.
I opened up all protocols and ports to this server in the firewall, no change.
Another clue: after I unplug the ethernet cable from the server and test for normal response time (log into front end app on server) and see that it's fast as it should be, I reconnect the server to the network. It's still fast for 4 to 7 logins...then it clogs up. It makes me think that something "builds up" after it's back on the network that causes the slowness....
The vendor is not being that helpful yet. I reinstalled complete application 3 times today - no change.
1. Is this the correct forum for this flavor of SQL Server?
2. Can I post anything to give you any clues as to my problem?
3. How could I reindex any data files to see if this is the problem (oh yeah, BTW, the vendor's instructions were to copy the files in c:\MSSQL7\data off to a safe location, reinstall app, then copy these data files back into the data folder).
One more thing: all the other 13 servers on the network seem fine and working at normal speeds. There are no other SQL servers on the network.
Thanks in advance to everyone....
Been working great for weeks. Put a firewall on the LAN last Friday and made sure ports HTTPS and tcp 1433 were allowed to this server. Changed the server's ip address from it's public to a private at time of firewall implementation (using NAT and PAT).
Still worked fine until.....yesterday evening. Since then it is extremely slow in response time - UNLESS - unless I unplug the server from the network. Then it runs great!
Monday evening I installed a syslog daemon on this machine to log the firewall's activity.
This morning I stopped and uninstalled the syslog service.
I opened up all protocols and ports to this server in the firewall, no change.
Another clue: after I unplug the ethernet cable from the server and test for normal response time (log into front end app on server) and see that it's fast as it should be, I reconnect the server to the network. It's still fast for 4 to 7 logins...then it clogs up. It makes me think that something "builds up" after it's back on the network that causes the slowness....
The vendor is not being that helpful yet. I reinstalled complete application 3 times today - no change.
1. Is this the correct forum for this flavor of SQL Server?
2. Can I post anything to give you any clues as to my problem?
3. How could I reindex any data files to see if this is the problem (oh yeah, BTW, the vendor's instructions were to copy the files in c:\MSSQL7\data off to a safe location, reinstall app, then copy these data files back into the data folder).
One more thing: all the other 13 servers on the network seem fine and working at normal speeds. There are no other SQL servers on the network.
Thanks in advance to everyone....