Setting up alerts in Zenoss

Hi,

We are testing ZenOss to see if it helps us on our path to compliancy.  can I :

1. Report all services currently running on selected servers, weekly.
2. Can I create alerts like low disk space, high CPU use
3. Can I alert people if SQL Server job fails or deadlocks
4. Daily report on time taken by SQL jobs (procedures) to finish executing.
5. Alert Admin if remote login failed for more than 3 times for a user.

Thanks !
pratz09Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lcohanConnect With a Mentor Database AnalystCommented:
"Can I alert people if SQL Server job fails or deadlocks"
http://msdn.microsoft.com/en-us/library/ms186385(v=SQL.90).aspx

"Daily report on time taken by SQL jobs (procedures) to finish executing."
You could run the query below once a day and send the results as a report:
SELECT  a.execution_count ,
    OBJECT_NAME(objectid) Name,
    query_text = SUBSTRING(
    b.text,
    a.statement_start_offset/2,
    (   CASE WHEN a.statement_end_offset = -1
        THEN len(convert(nvarchar(max), b.text)) * 2
        ELSE a.statement_end_offset
        END - a.statement_start_offset)/2
    ) ,
    b.dbid ,
    dbname = db_name(b.dbid) ,
    b.objectid ,
    a.creation_time,
    a.last_execution_time,
    a.*
FROM            sys.dm_exec_query_stats a
CROSS APPLY     sys.dm_exec_sql_text(a.sql_handle) as b
--WHERE OBJECT_NAME(objectid) = 'YOURPROCEDURE'
ORDER BY a.last_execution_time DESC



OR

SQL performance dashboard
http://www.microsoft.com/download/en/details.aspx?id=22602
0
 
lcohanDatabase AnalystCommented:
Here is a shorter version for the SP report and just select whatever columns you want instead of a.* from query below:

use your_db
go

SELECT  a.execution_count ,
    OBJECT_NAME(b.object_id) as Name,
    dbname = db_name(a.database_id) ,
    b.object_id ,
    a.cached_time,
    a.last_execution_time,
    a.*
FROM master.sys.dm_exec_procedure_stats a inner join sys.objects b on a.object_id = b.object_id
ORDER BY a.last_execution_time DESC
0
 
pratz09Author Commented:
SQL Performance Dashboard is just fantastic. Extra thanks for that.
0
All Courses

From novice to tech pro — start learning today.