admin multiple servers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

admin multiple servers

Author

Topic

ulyss
Starting Member

10 Posts

Posted - 2002-12-11 : 08:29:44

If I have a lot of servers,and I want to do a check on all of its services,jobs and alerts,can I do that without having to go to each server and to expand it in the Enterprise Manager???Is there an existing tool for this purpose?
I know I could do it with Sql Mial and alerts,but I don't think it is very reliable as when the Agent is not running,I won't get feedback.
Thank you very much.

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2002-12-11 : 08:36:22

quote:

If I have a lot of servers,and I want to do a check on all of its services,jobs and alerts,can I do that without having to go to each server and to expand it in the Enterprise Manager???Is there an existing tool for this purpose?
I know I could do it with Sql Mial and alerts,but I don't think it is very reliable as when the Agent is not running,I won't get feedback.
Thank you very much.

you can configure all the servers on one of u'r central server and monitor all the activities for all the servers from that central server itself.

ulyss
Starting Member

10 Posts

Posted - 2002-12-11 : 09:10:42

Thank you,I already thought it could be done.
Do I do this with linking all my servers or something because I don't have any idea how .... :)?

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-12-11 : 09:13:08

You could write that yourself in SQL-DMO

Damian

ulyss
Starting Member

10 Posts

Posted - 2002-12-11 : 09:21:50

Thank you but I don't know anything about SQL-DMO and it seems to me ti is not comprehensible for me in the books,do you have any good links or short starting pointers.Anyway if not at least I know where to begin :)
Thx

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-12-11 : 09:29:53

I don't see what's so difficult in clicking on each server to check it using EM. I used to do it all the time, I could check 8 servers in 2 minutes. All of the failed jobs (if any) pop up right away, and I could've set up alerts for them if they failed (I didn't though) And if there was a problem, I'd already have EM open and could fix it immediately.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-12-11 : 19:40:19

quote:

do you have any good links or short starting pointers.

Here are some good starting points

http://www.sqlteam.com/SearchResults.asp?SearchTerms=sql-dmo

http://www.google.com/search?hl=&cat=&meta=&q=sql-dmo

Hope that helps

Damian

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2002-12-11 : 20:02:40

Just hire a student worker to do the checks! J/K

ulyss
Starting Member

10 Posts

Posted - 2002-12-12 : 07:47:36

quote:

quote:

do you have any good links or short starting pointers.

Here are some good starting points

http://www.sqlteam.com/SearchResults.asp?SearchTerms=sql-dmo

http://www.google.com/search?hl=&cat=&meta=&q=sql-dmo

Hope that helps

Damian

Thanks Merkin that helped me,now the only thing I'll have to do is learn some VB :)
Take care you all and thx.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources