Hi,
I've adapter the bbsql-server script from deadcat.net so that it is working with the BBWin agent.
It checks if the scheduled tasks started successfully,
It checks for blocking locks and I added some statistics on "database last backup", the database transaction log Size (MB) and Usage (%)
I still have to implement some alerting on those statistics but the script works fine on MSSQL 2000 and up.
It works on both 32 and 64 bit architecture.
I will paste it on xymonton
Best regards
Bart Gillis
---- "Success is not final, failure is not fatal: it is the courage to continue that counts." --- Winston Churchill ----
-----Original Message-----
From: Josh Luthman [mailto:user-4c45a83f15cb@xymon.invalid]
Sent: maandag 22 maart 2010 18:01
To: user-ae9b8668bcde@xymon.invalid
Cc: Storer, Raymond
Subject: Re: [hobbit] MS SQL Monitoring on Windows 2003 64-bit
How does the information get out of MSSQL? SNMP? CSV that bbwin can send?
Josh Luthman
Office: XXX-XXX-XXXX
Direct: XXX-XXX-XXXX
XXXX Wayne St
Suite XXXX
Troy, OH XXXXX
"Success is not final, failure is not fatal: it is the courage to
continue that counts."
--- Winston Churchill
On Mon, Mar 22, 2010 at 11:50 AM, Ambati Srinivas <user-3744c619952a@xymon.invalid> wrote:
Hi,
I would like to monitor normal MS SQL Parameters listed, running jobs and
also locks if any.
Availability
Blocked Processes
Configuration Status
Disk I/O Errors
Error Log Updates
SQL Agent Job Failures
SQL Agent Status
SQL Server Status
Capacity
Connections Remaining
DatabaseApp
Space Utilization
Suspect Database
FilegroupApp
Space Available
Space Used
Space Utilization
Performance
Buffer Cache Hit Ratio
CPU Utilization
Deadlocks
Packet Errors
Thanks much for your assistance.
AM
On Mon, Mar 22, 2010 at 9:06 PM, Storer, Raymond <user-bbaa567d59bb@xymon.invalid> wrote:
What are you trying to accomplish exactly?
Ray
From: Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid]
Sent: Monday, March 22, 2010 8:25 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] MS SQL Monitoring on Windows 2003 64-bit
Hi Every one,
Does any successfully got MS SQL on Windows 2003 64-bit?
Please help as soon as possible as I am in the verge of tight deadline to
deliver for the client.
Detailed steps would be very very very helpful.
Thank,
AM
CONFIDENTIALITY NOTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are not
the intended recipient, please do not read, distribute or take action in
reliance upon this message. If you have received this in error, please
notify us immediately by return email and promptly delete this message
and its attachments from your computer system. We do not waive
attorney-client or work product privilege by the transmission of this
message.