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:josh at imaginenetworksllc.com] Sent: maandag 22 maart 2010 18:01 To: hobbit at hswn.dk 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: 937-552-2340 Direct: 937-552-2343 1100 Wayne St Suite 1337 Troy, OH 45373
"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 <am.srini at gmail.com> 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 <storerr at nibco.com> wrote:
What are you trying to accomplish exactly?
Ray
From: Ambati Srinivas [mailto:am.srini at gmail.com] Sent: Monday, March 22, 2010 8:25 AM To: hobbit at hswn.dk 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.
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk