Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simondeutsch
Aged Yak Warrior
547 Posts |
 Posted - 2009-10-13 : 16:05:11
|
| A client is having a strange issue, that when their internet access goes down, my application seem to slow down considerably. It's a client/server app, with the data residing on SQL Server 7, listening on Named Pipes and TCP/IP, in that order. The clients connect using the server/SQL Server instance name.The application does not access the internet in any way. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-13 : 16:34:57
|
| Assuming the SQL Server and client app are located on the same network, my guess is their router(s) are causing both problems. |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2009-10-13 : 16:42:51
|
| The network guy claims it isn't a networking issue; he says LAN throughput is fine and copying a file from the server to a client computer works with proper speed.The only internet access utilized by SQL Server is using xp_Sendmail via Outlook automation several times a day to send out lists. Is it possible that when the internet is down Outlook hangs and the SQL process started by xp_Sendmail hangs in SQL Server as well, slowing it down? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-13 : 16:50:29
|
| It will definitely hang xp_sendmail and whatever processes use it, but it shouldn't slow it down too much. Are these lists going to external recipients? |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2009-10-14 : 00:09:07
|
| Yes, they are.There's a two-part job that runs several times a day. The first part generates a .csv file, the second part emails the .csv file as an attachment to some external email addresses. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-10-14 : 05:53:00
|
| 1. disable your email job(s).2. disable the internet connection.3. measure application performance. if step 2 hasn't affected you, then the problem is caused by your jobs in step 1. |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2010-03-17 : 14:27:36
|
| After much water under the bridge and LOTS of problems with Outlook and xp_sendmail using SQL Mail this solution was ditched in favor of a solution using SendEmail.exe, a Perl-based free SMTP email program. It's a whole lot less complicated and seems to actually work.Just thought I'd throw it out here. |
|
|
|
|
|
|
|
|
Clients slow when internet disconnected