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

[doctor at makelofine.org]

On Thu, 25 Mar 2010 11:38:07 +0100, "Gillis Bart" <Bart.Gillis at cegeka.be>
wrote:
> 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
> 
> 
> 
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk

Thank you very much for this !
I'll give it a try this weekend and give you a feedback is necessary