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

["doctor (at) makelofine.org" <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