April 11, 2008 at 12:28 pm
Hi, this is the first time I write here.
I have the next issue, let me explain. I made an application that triggers an sp on a "central" server, this store procedure seeks a table named server for servers online, for each server online triggers a "local" sp, these "local" sp's writes in a table.
After this the "central" server gets all the "local" servers data from the tables and adds its own results.
I get to do this by using linked servers. I.E.:
SET @sql = 'EXEC localSrvr01.bd.dbo.lsp_GetResults ' + @params
EXEC (@SQL)
It's something similar to that, but the program has to wait before the next "local" sp finishes. This means that the sp's are done one after another which increases the execution time.
The question is: Is there someway that the "central" server can execute all "local" sp's at the same time on the different servers?
Thanks for reading
Alberto
May 5, 2008 at 2:50 pm
Check the key word, master server. Using master server, you can control your jobs on multiple servers.
May 5, 2008 at 3:31 pm
What I want is to execute store procedures from several servers, all at the same time.... I've been thinking in one way that involves jobs but I wanted to know if there's a way to do it as a "direct" aproach.
The flow must be something like this:
> Local server executes procedure
/
user Central server
execute receives order
function -> & prepares -> Local server executes procedure
on an execution
application on local servers
> Local server executes procedure
(This execution must be happening at
the same time or with little time
difference)
May 5, 2008 at 7:29 pm
You can do this with Service Broker.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 5, 2008 at 7:31 pm
Oops, sorry. I just realized that this is not the SQL 2005 section.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 6, 2008 at 7:44 am
No prob. Either way I'm reading stuff on Service Broker. Perhaps I should try my idea using jobs.
🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply