Friday, March 9, 2012

Performance on wan

Hi,I have 2 server SQL 2000, 15 days ago everything worked well,

but days back, the performance on WAN is poor, it takes long time in login and make querys, in the local net everything work well, my problem is only on WAN, i dont have problem with Memory and CPU, the use of CPU never exceed 25 %, although i have poor performance on WAN local its fine, my bandwith is excelent, with other services i dont have problem(Terminal Services, Ftp, etc)

Some idea?

Thanks.

Javier Muro

When you connect, can you confirm your network library is TCP/IP? You can query against sysprocesses to find this out:
SELECT loginame, net_library
FROM sysprocesses
WHERE loginame = '<your login>'
If it's not, run cliconfg.exe and check the order of your enabled protocols. If you've got TCP/IP first, was the SQL Server restarted recently? If so, check the SQL Server log to ensure it was able to listen on TCP/IP.
If none of that, were any changes made on the networking equipment for the WAN? For instance, did the network engineers adjust QoS or anything of that sort?

No comments:

Post a Comment