SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Managing many SQL Servers?


Managing many SQL Servers?

Author
Message
Rudy Panigas
Rudy Panigas
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 1311
Comments posted to this topic are about the item Managing many SQL Servers?



Rudy Panigas
Rudy Panigas
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 1311
Hello Everyone,

Hope you like the article and I am hoping to write more showing how to use the remote management to help do other tasks.

If you have any ideas as to what can be done, I would love to hear about them.

Thanks,

Rudy



Mike DiRenzo
Mike DiRenzo
SSC Veteran
SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)SSC Veteran (273 reputation)

Group: General Forum Members
Points: 273 Visits: 210
Very nice article. It sound as if this util grew and grew and became what it is over time. Those are the best kind of tools. And whats more, you sharing it. Good job!

-Mike
Rudy Panigas
Rudy Panigas
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 1311
Thank you very much for all the kind words. I feel that I've been a DBA long enough (8 years) and that it's time to share with all the people on this great site!

Rudy



Glen Moffitt-317424
Glen Moffitt-317424
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 120
Hi Rudy,

I scanned the article, looks intriguing. I have about 80 instances, with more to add, that I have to monitor, and have had thoughts along the same lines. I would want to be monitoring not only for success/failure of routines but performance measurement and database health as well.

Keep up the good work!

Glen
SequelDBA
SequelDBA
SSC Journeyman
SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)SSC Journeyman (84 reputation)

Group: General Forum Members
Points: 84 Visits: 1063
Rudy,

Nice work! The time you took to document this and share it are what makes this site what it is - A Valuable Resource!

Thank you!
Kevin


KU
Rudy Panigas
Rudy Panigas
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 1311
Hello Glen,

Sounds like that I was going through when I first started this code. For example, I only wanted to know when a job failed so that I could review and resolve the problem. This setup will do that for you. It really will cut down the time need to review failed jobs.

I think my next article will be the SQL error log analysis report. Using the code from this article and some additional steps, I can quickly review any SQL server's error log without have to connect to the server/instance and without have to view all the successes in that log file. It helps to review failed jobs.

Rudy



paramejunk
paramejunk
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 85
Rudy,

If I am not mistaken, this connection would be a linked server connection to the other server.
If so, can you create objects (i.e. Tables, SP's, Views, Jobs, Functions) remotely via a linked
server connection?

Can you modify Schema of objects via a linked server connection?

If not, do you know how to "Create Objects" and "Modify Schema" via a linked server
connection?

Thanks,
PMJ
Rudy Panigas
Rudy Panigas
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 1311
Good question. Not sure if this can be done but I believe (not tested this) that you could. Best to try it on a test server first. Up to now I have only used this technique to pull information. Link server connection documentation is very limited so that best way to know for sure is to test.

Sorry that I couldn't help more and let us know what you find.

Thanks,

Rudy



Rudy Panigas
Rudy Panigas
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1008 Visits: 1311
Hello Everyone,

Just wanted to mention that this ability is available in SQL 2008 but does not work against older versions of SQL server. Also you have to create groups in order to execute code remotely. Other DBAs find that this is a preferred way of executing code remotely as most business have a mix of SQL server versions.

I'm am currently making new remote execute code and reports for our Oracle servers. Yes, we have Oracle servers too and the pilot so far is working well. Soon our Oracle DBA can get web based reports on the Jobs statuses of the Oracle servers. Oracle's reporting is not as easy to use/create/modify as Microsoft's Reporrting Sercvices.

Just thought you might wanted to know.

Rudy



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search