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.

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.

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

Richard,

Thank you for these tips. I'm not a very good scripter, any help is welcome.

Best regards

Bart -----Original Message----- From: Richard Finegold [mailto:goldfndr at gmail.com] Sent: vrijdag 26 maart 2010 9:59 To: hobbit at hswn.dk Subject: Re: [hobbit] MS SQL Monitoring on Windows 2003 64-bit

On Fri, Mar 26, 2010 at 00:55, doctor at makelofine.org <doctor at makelofine.org> wrote:

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. [snip] 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

Ah, I should probably send this publicly...

There was an error when I ran this. Each server I've run this on claim to have no jobs, so the file for CheckJobStats was never created.

The following code, around line 122, "fixes" it. You can see that it only opens the file if it exists, then deletes immediately after reading instead of after the variable assignment. It could be simplified by always setting tmpStr to No Job History, then replace it with f.ReadAll as needed.

There are a few other minor improvements that could be made (e.g. change <td> to <th> in table head; maybe remove <br> from within tables since it doesn't seem to serve any purpose).

Loop if fso.FileExists(strFilePath & "\" & tempfilename) then Set f = fso.OpenTextFile(strFilePath & "\" & tempfilename ,1 ) If Not f.AtEndOfLine Then tmpStr = f.ReadAll Else tmpStr = " No Job History. " & vbcrlf End If f.Close fso.DeleteFile strFilePath & "\" & tempfilename else tmpStr = " No Job History. " & vbcrlf end if

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk