[hobbit] MS SQL Monitoring on Windows 2003 64-bit

[Gillis Bart]

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