monitoring tool

Are there any good monitoring tools that would notify us upon CPU,Disk
space, blocking, errors/warnings in event logs,etc..
We use Sitescope and it doesnt seem to be a robust tool
Thanks
Hi,
Have a look into Microsoft operation manager (MOM). See the below URL for
details:-
http://www.microsoft.com/mom/default.mspx
Thanks
Hari
SQL Server MVP
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OESfJu$qFHA.460@.TK2MSFTNGP15.phx.gbl...
> Are there any good monitoring tools that would notify us upon CPU,Disk
> space, blocking, errors/warnings in event logs,etc..
> We use Sitescope and it doesnt seem to be a robust tool
> Thanks
>
|||There are a lot of different monitoring tools. MOM is one
that Hari mentioned. You may also want to look at some of
the tools from idera:
www.idera.com
-Sue
On Sun, 28 Aug 2005 11:08:46 -0700, "Hassan"
<hassanboy@.hotmail.com> wrote:

>Are there any good monitoring tools that would notify us upon CPU,Disk
>space, blocking, errors/warnings in event logs,etc..
>We use Sitescope and it doesnt seem to be a robust tool
>Thanks
>
|||Take a look at AgileInfoSoftware DataStudio, under its Performance
Monitoring node, it allows user to monitor process, lock, blocking locks
etc.
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OESfJu$qFHA.460@.TK2MSFTNGP15.phx.gbl...
> Are there any good monitoring tools that would notify us upon CPU,Disk
> space, blocking, errors/warnings in event logs,etc..
> We use Sitescope and it doesnt seem to be a robust tool
> Thanks
>
|||Check out AgileInfoSoftware DataStudio http://www.agileinfollc.com
John King
AgileInfoSoftware
http://www.agileinfollc.com
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OESfJu$qFHA.460@.TK2MSFTNGP15.phx.gbl...
> Are there any good monitoring tools that would notify us upon CPU,Disk
> space, blocking, errors/warnings in event logs,etc..
> We use Sitescope and it doesnt seem to be a robust tool
> Thanks
>
|||Sorry to bring back an old thread, but this is of great interest to me also.
I'm doing a trial deployment of MOM and finding it a bit more than we may
need. I like the extensibility via the management packs, but it may be too
big, too expensive and to tell the truth, a bit 'finicky' in setting up and
maintaining. Right now I have more alerts about MOM itself to figure out and
fix than the SQL servers we are attempting to monitor.
I'm a network engineer, not a SQL DBA. All I really want is something that
alerts when a job fails, lets us know if the SQL Agent isn't running and a
few other server statistics.
I'm going to look into Idera and Agileinfo.
Does anyone have any other recomendations? I know vendors like to throw in
the kitchen sink when it comes to features. In this case, for me, KISS is
more like my guiding principle.
Regards,
MK
"John King" wrote:

> Check out AgileInfoSoftware DataStudio http://www.agileinfollc.com
> John King
> AgileInfoSoftware
> http://www.agileinfollc.com
> "Hassan" <hassanboy@.hotmail.com> wrote in message
> news:OESfJu$qFHA.460@.TK2MSFTNGP15.phx.gbl...
>
>
|||I really like Idera's Diagnostic Manager. Great third-party tool!
Lori
"Michael Kenny" <MichaelKenny@.discussions.microsoft.com> wrote in message
news:CA9FCD26-8BB7-4247-930F-2F803688233E@.microsoft.com...[vbcol=seagreen]
> Sorry to bring back an old thread, but this is of great interest to me
> also.
> I'm doing a trial deployment of MOM and finding it a bit more than we may
> need. I like the extensibility via the management packs, but it may be too
> big, too expensive and to tell the truth, a bit 'finicky' in setting up
> and
> maintaining. Right now I have more alerts about MOM itself to figure out
> and
> fix than the SQL servers we are attempting to monitor.
>
> I'm a network engineer, not a SQL DBA. All I really want is something that
> alerts when a job fails, lets us know if the SQL Agent isn't running and a
> few other server statistics.
> I'm going to look into Idera and Agileinfo.
> Does anyone have any other recomendations? I know vendors like to throw in
> the kitchen sink when it comes to features. In this case, for me, KISS is
> more like my guiding principle.
> Regards,
> MK
>
>
> "John King" wrote:

Monitoring Clustered SQL Server

I am attempting to montior failovers, using Sitescope, so does anyone know
event what events are created when a node fails over?
Dave B
The SDK for Windows Clustering should give you a few.
http://msdn.microsoft.com/library/de...start_page.asp I
am not a developer, so I can't help you anymore with the SDK.
You can also create a failure and use the ones you want from that wonderful
experience.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.itsummitseries.com/experts/fournier.htm - Cluster Summit
"Dave B" <DaveB@.discussions.microsoft.com> wrote in message
news:5C9DDBD9-4FF8-461D-BAEE-8C480EA9A713@.microsoft.com...
>I am attempting to montior failovers, using Sitescope, so does anyone know
> event what events are created when a node fails over?
> --
> Dave B
|||Dave B wrote:
> I am attempting to montior failovers, using Sitescope, so does anyone know
> event what events are created when a node fails over?
We use nagios to monitor if the sql service is running on the prefered
node. If not it must have failed over. sitescope can monitor services too.
Hans