Managing many SQL Servers?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Rudy Panigas » Managing many SQL Servers?

Add to briefcase

28 posts, Page 1 of 3

Managing many SQL Servers?

Expand / Collapse

Author

Message

Posted Wednesday, January 14, 2009 10:49 PM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 306, Visits: 1,014

Comments posted to this topic are about the item Managing many SQL Servers?

Post #636833

Posted Thursday, January 15, 2009 6:34 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 306, Visits: 1,014

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

Post #637048

Posted Thursday, January 15, 2009 7:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:11 PM
Points: 143, Visits: 183

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

Post #637077

Posted Thursday, January 15, 2009 7:11 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 306, Visits: 1,014

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

Post #637081

Glen Moffitt-317424

Posted Thursday, January 15, 2009 7:13 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, December 30, 2010 5:33 PM
Points: 11, Visits: 116

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

Post #637086

Posted Thursday, January 15, 2009 7:17 AM

SSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:37 AM
Points: 35, Visits: 763

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

Post #637094

Posted Thursday, January 15, 2009 7:19 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 306, Visits: 1,014

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

Post #637096

Posted Thursday, January 15, 2009 7:32 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 03, 2010 11:30 AM
Points: 3, 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

Post #637115

Posted Thursday, January 15, 2009 7:52 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 306, Visits: 1,014

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

Post #637139

Posted Thursday, January 15, 2009 8:11 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 306, Visits: 1,014

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

Post #637184

« Prev Topic | Next Topic »

Add to briefcase

28 posts, Page 1 of 3

Permissions

Expand / Collapse