August 11, 2008 at 2:31 pm
Is anyone having any stored procedure or query which can run against multiple servers(server names and connection info stored in centralized server database table) and can run some queries against them individually?
Please share it if you have any such template.
MJ
August 11, 2008 at 6:39 pm
For your 1st question...
I am in a banking industry and hadling 40+ branch servers. I made a script which will run 1 query to the entire branch servers so whenever i need to update, select, insert any data for all the branch server i will just use the stored procedure i made. What I did is that I link the branch server to the server which i created the stored procedure (using linked server).
For the second question..
My superior also requested me to get the HD (hard disk) spaces (total, used, left) of all the branch servers. What I did is that i created a table using the stored procedure i made, run a script of getting HD information to get the data of all the branch servers, store it to them individually then whenever I want to get the data I/'ll just select it and insert it to my local server.
I'm not saying this is the best idea. There are lots of ideas being used by other DBA's but this procedure fits my need on using 1 query to select, insert, update, delete lots of servers. Using linked server.
I am also seeking for any other ways of improving the things that I am doing in a daily basis o comments are also welcom for me 🙂
"-=Still Learning=-"
Lester Policarpio
August 12, 2008 at 8:25 am
Can you share the template code with me by sending it across at my personal id(manujaidka@rediffmail.com)?
What in case we need to run same query against different databases residing on different servers?
MJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply