Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Managing many SQL Servers? Expand / Collapse
Author
Message
Posted Wednesday, January 14, 2009 10:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:25 AM
Points: 312, Visits: 1,108
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:25 AM
Points: 312, Visits: 1,108
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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, February 25, 2014 11:28 AM
Points: 145, Visits: 193
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:25 AM
Points: 312, Visits: 1,108
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
Posted Thursday, January 15, 2009 7:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 12:49 PM
Points: 11, 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
Post #637086
Posted Thursday, January 15, 2009 7:17 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 8:46 AM
Points: 35, Visits: 869
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:25 AM
Points: 312, Visits: 1,108
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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 3, 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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:25 AM
Points: 312, Visits: 1,108
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

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 8:25 AM
Points: 312, Visits: 1,108
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 123»»»

Permissions Expand / Collapse