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 |
|
CartesianJoin
Starting Member
11 Posts |
 Posted - 2004-05-26 : 18:31:54
|
| We run a 2 node, a/p cluster of SQL Server 2000 on a Win 2003 server platform. Previously to this, the same setup was running under windows 2000 server.We use xp_cmdshell to execute a "net send" command. This command is embedded within an insert trigger on a table. The trigger runs fine and we have no errors. Users that we expect to get the message are getting it no problem. We have run this setup for over a year now. Since the migration from windows 2000 to windows 2003 server, the trigger is taking substantially longer now and I have isolated the delay to be in the actual execution of the net send command. It was instantaneous before but now can take up to 30 seconds to complete. Since xp_cmdshell is synchronous, it locks up the users system who is performing the insert which triggers the net send.I was hoping someone else had run into this problem already? (and solved it :)--Doug |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-26 : 18:44:16
|
| Is the net send command fast outside of SQL Server or at least just as fast on the Win2k box?I'm curious as to why you would do a net send in a trigger. Could you provide some info. on this?Tara |
 |
|
|
CartesianJoin
Starting Member
11 Posts |
Posted - 2004-05-27 : 12:46:39
|
| Well, yes it does happen at a command prompt on the server. Obviously, it is an OS issue but I was just hoping someone might have seen this after an upograde from 2k to 2k3 as a platform.As to the need for a net send in a trigger, we have a CRM and sales agents. If an agent sends a to-do to another agent, our CRM will not refresh the target agents to-do list so we catch the new to-do and do a net send to the target agent to have him refresh his system to see the new activity. |
|
|
|
|
|
|
xp_cmdshell/windows2003 server