MS SQL Monitoring on Windows 2003 64-bit
list Ambati Srinivas
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
list Raymond Storer
What are you trying to accomplish exactly? Ray
▸
From: Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid]
Sent: Monday, March 22, 2010 8:25 AM
To: user-ae9b8668bcde@xymon.invalid
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.
list Ambati Srinivas
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 <user-bbaa567d59bb@xymon.invalid> wrote:
What are you trying to accomplish exactly? Ray *From:* Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid] *Sent:* Monday, March 22, 2010 8:25 AM *To:* user-ae9b8668bcde@xymon.invalid *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.
list Jerald Sheets
There's a couple SQL Server monitor scripts over on deadcat.net. Maybe you could modify them to your needs? --- Jerald M. Sheets jr.
▸
On Mon, Mar 22, 2010 at 11:50 AM, Ambati Srinivas <user-3744c619952a@xymon.invalid>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 <user-bbaa567d59bb@xymon.invalid>wrote:What are you trying to accomplish exactly? Ray *From:* Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid] *Sent:* Monday, March 22, 2010 8:25 AM *To:* user-ae9b8668bcde@xymon.invalid *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.
list Josh Luthman
How does the information get out of MSSQL? SNMP? CSV that bbwin can send? Josh Luthman Office: XXX-XXX-XXXX Direct: XXX-XXX-XXXX XXXX Wayne St Suite XXXX Troy, OH XXXXX “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 <user-3744c619952a@xymon.invalid> 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 <user-bbaa567d59bb@xymon.invalid> wrote:What are you trying to accomplish exactly? Ray From: Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid] Sent: Monday, March 22, 2010 8:25 AM To: user-ae9b8668bcde@xymon.invalid 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.
list 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:user-4c45a83f15cb@xymon.invalid]
Sent: maandag 22 maart 2010 18:01
To: user-ae9b8668bcde@xymon.invalid
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: XXX-XXX-XXXX
Direct: XXX-XXX-XXXX
XXXX Wayne St
Suite XXXX
Troy, OH XXXXX
"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 <user-3744c619952a@xymon.invalid> 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 <user-bbaa567d59bb@xymon.invalid> wrote:What are you trying to accomplish exactly? Ray From: Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid] Sent: Monday, March 22, 2010 8:25 AM To: user-ae9b8668bcde@xymon.invalid 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.
list dOCtoR MADneSs
On Thu, 25 Mar 2010 11:38:07 +0100, "Gillis Bart" <user-cba7bb00b233@xymon.invalid>
▸
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:user-4c45a83f15cb@xymon.invalid] Sent: maandag 22 maart 2010 18:01 To: user-ae9b8668bcde@xymon.invalid 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: XXX-XXX-XXXX Direct: XXX-XXX-XXXX XXXX Wayne St Suite XXXX Troy, OH XXXXX "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 <user-3744c619952a@xymon.invalid> 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 <user-bbaa567d59bb@xymon.invalid> wrote:What are you trying to accomplish exactly? Ray From: Ambati Srinivas [mailto:user-3744c619952a@xymon.invalid] Sent: Monday, March 22, 2010 8:25 AM To: user-ae9b8668bcde@xymon.invalid 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.
Thank you very much for this ! I'll give it a try this weekend and give you a feedback is necessary
list Richard Finegold
On Fri, Mar 26, 2010 at 00:55, user-d54077869176@xymon.invalid
▸
<user-d54077869176@xymon.invalid> wrote:On Thu, 25 Mar 2010 11:38:07 +0100, "Gillis Bart" <user-cba7bb00b233@xymon.invalid> 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
list Gillis Bart
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:user-6a016aac278a@xymon.invalid]
Sent: vrijdag 26 maart 2010 9:59
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] MS SQL Monitoring on Windows 2003 64-bit
On Fri, Mar 26, 2010 at 00:55, user-d54077869176@xymon.invalid
<user-d54077869176@xymon.invalid> wrote:On Thu, 25 Mar 2010 11:38:07 +0100, "Gillis Bart"
<user-cba7bb00b233@xymon.invalid>
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