February 14, 2008 at 1:49 pm
Hello everyone
I have 3 servers that handle replication to a central server, but one of them has about 500 active processes and the remaining 50.
They connect to DataExchange and RSLinx software to extract data from a PLC.
How finish processes automatically as the other servers?
Thanks for your help 🙂
DB SQL Server 2000 Standard Edition; SP4; Version 8.00.2039; 1Gb Memory; 4 Processors; Windows 2000 Server SP4
February 14, 2008 at 3:37 pm
espinfire (2/14/2008)
Hello everyoneHow finish processes automatically as the other servers?
Can't understand this. You have a merge replication setup and in one of your server the processes are numbering 500. IS this your problem?
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 14, 2008 at 8:09 pm
Kumar
Yes, my problem is the difference the activity processes, in a server. This server has the same HW than the other 3 servers, the only difference is a more data of the PLC.
Server 1 --> data from 25 presses --> 50 processes per this server
Server 2 --> data from 32 presses --> 500 processes per this server
Server 3 -- >data from 28 presses --> 50 processes per this server
HOST --> Receives data from some tables of the other servers
PRESS (send-receive data) PLC (send-receive data) RSLINX (send-receive data) DATAEXCHANGE (send-receive data) (triggers) SQL (no has relations in tables of DB)
thks for your support
February 14, 2008 at 9:30 pm
How are you viewing the data? Is there a resource problem or are you just intrested in finding out where the extra processes are coming from?
If you are just intrested in where the processes are coming from, you could set up a trace to run during the processes or just run the sql profiler and look through the trace logs.
Hope that helps. (information on how to set up a trace can be found in books online)
February 15, 2008 at 12:58 am
If DBCC opentran shows open transactions, these will be rolled back if you kill the connections !!!!
In that case you will loose data.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply