Our environment is getting bigger and bigger. We have almost 45 SQL Servers
running and its a high availability cluster servers. We need to monitor all
jobs, services etc.
Is there any third party monitoring tool that can monitor all services and
SQL jobs?

Farrukh

www.sqlsentry.net



On 5/22/08 11:18 AM, in article
F8226842-E138-41D2-989B-B549FAF2FE93@microsoft.com, "FARRUKH"
<farrscorpio77@hotmail.com> wrote:

> Our environment is getting bigger and bigger. We have almost 45 SQL Servers
> running and its a high availability cluster servers. We need to monitor all
> jobs, services etc.
> Is there any third party monitoring tool that can monitor all services and
> SQL jobs?
>
> Farrukh

does it support cluster environemnt, monitor services?

"Aaron Bertrand [SQL Server MVP]" wrote:

> www.sqlsentry.net
>
>
>
> On 5/22/08 11:18 AM, in article
> F8226842-E138-41D2-989B-B549FAF2FE93@microsoft.com, "FARRUKH"
> <farrscorpio77@hotmail.com> wrote:
>
> > Our environment is getting bigger and bigger. We have almost 45 SQL Servers
> > running and its a high availability cluster servers. We need to monitor all
> > jobs, services etc.
> > Is there any third party monitoring tool that can monitor all services and
> > SQL jobs?
> >
> > Farrukh
>
>

Did you go to the web site? Which specific services do you want to monitor?


On 5/22/08 11:49 AM, in article
3E7CD39E-BAD6-4364-9BCE-4D618EB3D485@microsoft.com, "FARRUKH"
<farrscorpio77@hotmail.com> wrote:

> does it support cluster environemnt, monitor services?
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
>> www.sqlsentry.net
>>
>>
>>
>> On 5/22/08 11:18 AM, in article
>> F8226842-E138-41D2-989B-B549FAF2FE93@microsoft.com, "FARRUKH"
>> <farrscorpio77@hotmail.com> wrote:
>>
>>> Our environment is getting bigger and bigger. We have almost 45 SQL Servers
>>> running and its a high availability cluster servers. We need to monitor all
>>> jobs, services etc.
>>> Is there any third party monitoring tool that can monitor all services and
>>> SQL jobs?
>>>
>>> Farrukh
>>
>>

Yes, I checked the website. I would like tool monitor MSDTC, SQL Agent
services.

"Aaron Bertrand [SQL Server MVP]" wrote:

> Did you go to the web site? Which specific services do you want to monitor?
>
>
> On 5/22/08 11:49 AM, in article
> 3E7CD39E-BAD6-4364-9BCE-4D618EB3D485@microsoft.com, "FARRUKH"
> <farrscorpio77@hotmail.com> wrote:
>
> > does it support cluster environemnt, monitor services?
> >
> > "Aaron Bertrand [SQL Server MVP]" wrote:
> >
> >> www.sqlsentry.net
> >>
> >>
> >>
> >> On 5/22/08 11:18 AM, in article
> >> F8226842-E138-41D2-989B-B549FAF2FE93@microsoft.com, "FARRUKH"
> >> <farrscorpio77@hotmail.com> wrote:
> >>
> >>> Our environment is getting bigger and bigger. We have almost 45 SQL Servers
> >>> running and its a high availability cluster servers. We need to monitor all
> >>> jobs, services etc.
> >>> Is there any third party monitoring tool that can monitor all services and
> >>> SQL jobs?
> >>>
> >>> Farrukh
> >>
> >>
>
>

On May 22, 12:47 pm, FARRUKH <farrscorpi...@hotmail.com> wrote:
> Yes, I checked the website. I would like tool monitor MSDTC, SQL Agent
> services.
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
> > Did you go to the web site? Which specific services do you want to monitor?
>
> > On 5/22/08 11:49 AM, in article
> > 3E7CD39E-BAD6-4364-9BCE-4D618EB3D...@microsoft.com, "FARRUKH"
> > <farrscorpi...@hotmail.com> wrote:
>
> > > does it support cluster environemnt, monitor services?
>
> > > "Aaron Bertrand [SQL Server MVP]" wrote:
>
> > >>www.sqlsentry.net
>
> > >> On 5/22/08 11:18 AM, in article
> > >> F8226842-E138-41D2-989B-B549FAF2F...@microsoft.com, "FARRUKH"
> > >> <farrscorpi...@hotmail.com> wrote:
>
> > >>> Our environment is getting bigger and bigger. We have almost 45 SQL Servers
> > >>> running and its a high availability cluster servers. We need to monitor all
> > >>> jobs, services etc.
> > >>> Is there any third party monitoring tool that can monitor all services and
> > >>> SQL jobs?
>
> > >>> Farrukh

I dont think you'll find anything better than MSFT Operations Manager
2007.

SQL Sentry mainly monitors SQL Server and SQL Server Agent services. (Yes
it works on clusters...) But you can do all kinds of custom alerting, it's
very flexible and I think you could easily write something that checks the
DTC service state periodically and on failure raises an alert that SQL
Sentry can consume.


On 5/22/08 12:47 PM, in article
7A50EA1D-06DC-46C4-82EF-1B31FDF4C928@microsoft.com, "FARRUKH"
<farrscorpio77@hotmail.com> wrote:

> Yes, I checked the website. I would like tool monitor MSDTC, SQL Agent
> services.

Some info on xp_servicecontrol

http://www.sqlservercentral.com/Foru...14726-5-1.aspx

It also talks briefly about using scm from the command line, but I'm not
sure that would work on 2005 servers (haven't tried).



On 5/22/08 1:12 PM, in article C45B21C4.60A5%ten.xoc@dnartreb.noraa, "Aaron
Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote:

> SQL Sentry mainly monitors SQL Server and SQL Server Agent services. (Yes
> it works on clusters...) But you can do all kinds of custom alerting, it's
> very flexible and I think you could easily write something that checks the
> DTC service state periodically and on failure raises an alert that SQL
> Sentry can consume.
>
>
> On 5/22/08 12:47 PM, in article
> 7A50EA1D-06DC-46C4-82EF-1B31FDF4C928@microsoft.com, "FARRUKH"
> <farrscorpio77@hotmail.com> wrote:
>
>> Yes, I checked the website. I would like tool monitor MSDTC, SQL Agent
>> services.
>

I definitely think there is BETTER than MOM 07 there. Maybe not a better
VALUE however.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Jeff" <jeffbry@gmail.com> wrote in message
news:50062017-7d36-4866-a1c4-9ab8c80af4e9@m45g2000hsb.googlegroups.com...
> On May 22, 12:47 pm, FARRUKH <farrscorpi...@hotmail.com> wrote:
>> Yes, I checked the website. I would like tool monitor MSDTC, SQL Agent
>> services.
>>
>> "Aaron Bertrand [SQL Server MVP]" wrote:
>>
>> > Did you go to the web site? Which specific services do you want to
>> > monitor?
>>
>> > On 5/22/08 11:49 AM, in article
>> > 3E7CD39E-BAD6-4364-9BCE-4D618EB3D...@microsoft.com, "FARRUKH"
>> > <farrscorpi...@hotmail.com> wrote:
>>
>> > > does it support cluster environemnt, monitor services?
>>
>> > > "Aaron Bertrand [SQL Server MVP]" wrote:
>>
>> > >>www.sqlsentry.net
>>
>> > >> On 5/22/08 11:18 AM, in article
>> > >> F8226842-E138-41D2-989B-B549FAF2F...@microsoft.com, "FARRUKH"
>> > >> <farrscorpi...@hotmail.com> wrote:
>>
>> > >>> Our environment is getting bigger and bigger. We have almost 45 SQL
>> > >>> Servers
>> > >>> running and its a high availability cluster servers. We need to
>> > >>> monitor all
>> > >>> jobs, services etc.
>> > >>> Is there any third party monitoring tool that can monitor all
>> > >>> services and
>> > >>> SQL jobs?
>>
>> > >>> Farrukh
>
> I dont think you'll find anything better than MSFT Operations Manager
> 2007.

> I dont think you'll find anything better than MSFT Operations Manager
> 2007.

Now, that kind of statement needs to be highly qualified. Not that I'm
saying MOM 2007 is not good. It is good. But monitoring is one of those
things that have a lot to do with what you already have in the
infrastructure, people's experience, and so on.

Linchi

"Jeff" wrote:

> On May 22, 12:47 pm, FARRUKH <farrscorpi...@hotmail.com> wrote:
> > Yes, I checked the website. I would like tool monitor MSDTC, SQL Agent
> > services.
> >
> > "Aaron Bertrand [SQL Server MVP]" wrote:
> >
> > > Did you go to the web site? Which specific services do you want to monitor?
> >
> > > On 5/22/08 11:49 AM, in article
> > > 3E7CD39E-BAD6-4364-9BCE-4D618EB3D...@microsoft.com, "FARRUKH"
> > > <farrscorpi...@hotmail.com> wrote:
> >
> > > > does it support cluster environemnt, monitor services?
> >
> > > > "Aaron Bertrand [SQL Server MVP]" wrote:
> >
> > > >>www.sqlsentry.net
> >
> > > >> On 5/22/08 11:18 AM, in article
> > > >> F8226842-E138-41D2-989B-B549FAF2F...@microsoft.com, "FARRUKH"
> > > >> <farrscorpi...@hotmail.com> wrote:
> >
> > > >>> Our environment is getting bigger and bigger. We have almost 45 SQL Servers
> > > >>> running and its a high availability cluster servers. We need to monitor all
> > > >>> jobs, services etc.
> > > >>> Is there any third party monitoring tool that can monitor all services and
> > > >>> SQL jobs?
> >
> > > >>> Farrukh
>
> I dont think you'll find anything better than MSFT Operations Manager
> 2007.
>

I have not had a chance to look at MOM yet. I have reviewed a number
of tools for my job last year. We finally settled on Idera SQL
Diagnostic Manager. It does alot more than just monitor SQL agent
though. Idera and Quest were close, we went with Idera as it installs
nothing on the instances we are monitoring, and their support is
fantastic. Idera and Quest cost about the same.

Idera SQL Diagnostic Manager - www.Idera.com

Quest Spotlight on SQL Server - http://www.quest.com/spotlight-on-sq...er-enterprise/

The last one is free for up to 5 instances which we liked alot, and
relatively cheap beyond that. It runs under apache and MySql which
was kinda cool to play with and learn, but we're an MS shop and don't
have that kind of expertise around, so we stay with what we know. It
is a very cool product and will monitor just about any type of
application/service that might be running on a box, SQL, IIS, Apache,
I think you can even configure it to monitor custom services.
Definitely worth a look see though.

http://manageengine.adventnet.com/pr...ger/index.html



My 2 cents....

David Hay