BBwin script monitor sql 2005

6 messages in this thread

list Jason Chambers · Tue, 29 May 2007 09:52:10 -0400 ·

Does anyone know where I can get a script to monitor sql 2005 servers,
x64? Deadcat.net appears to be useless now.

 
Jason Chambers

IT Helpdesk Support

  <http://www.geosoft.com/>; eosoft Inc.

XX Richmond St. West - 8th Floor

Toronto, Ontario, Canada

M5H 2C9

Tel: XXX-XXX-XXXX x344

Fax: XXX-XXX-XXXX

www.geosoft.com <http://www.geosoft.com>;

list Rich Smrcina · Tue, 29 May 2007 09:01:12 -0500 ·

Why do you say it's useless?  The scripts to monitor SQL Server are VBS, aren't they?

▸ quoted from Jason Chambers


Jason Chambers wrote:

Does anyone know where I can get a script to monitor sql 2005 servers, x64? Deadcat.net appears to be useless now.

 
Jason Chambers

*IT Helpdesk Support*


<http://www.geosoft.com/>eosoft Inc.

▸ quoted from Jason Chambers


XX Richmond St. West - 8th Floor

Toronto, Ontario, Canada

M5H 2C9

Tel: XXX-XXX-XXXX x344

Fax: XXX-XXX-XXXX

www.geosoft.com <http://www.geosoft.com>;

--


Rich Smrcina
VM Assist, Inc.
Phone: XXX-XXX-XXXX
Ans Service:  XXX-XXX-XXXX
user-61add9955ef9@xymon.invalid

Catch the WAVV!  http://www.wavv.org
WAVV 2008 - Chattanooga - April 18-22, 2008

list Jason Chambers · Tue, 29 May 2007 10:15:13 -0400 ·

But only works on Sql 2000, or x86 platforums.

Jason Chambers
IT Helpdesk Support
Geosoft Inc.

▸ signature

XX Richmond St. West - 8th Floor
Toronto, Ontario, Canada
M5H 2C9
Tel: XXX-XXX-XXXX x344
Fax: XXX-XXX-XXXX
www.geosoft.com
 


-----Original Message-----

▸ quoted from Rich Smrcina

From: Rich Smrcina [mailto:user-cf452ff334e0@xymon.invalid] Sent: May-29-07 10:01 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] BBwin script monitor sql 2005

Why do you say it's useless?  The scripts to monitor SQL Server are VBS, aren't they?

Jason Chambers wrote:

Does anyone know where I can get a script to monitor sql 2005 servers, x64? Deadcat.net appears to be useless now.

 
Jason Chambers

*IT Helpdesk Support*

<http://www.geosoft.com/>eosoft Inc.

XX Richmond St. West - 8th Floor

Toronto, Ontario, Canada

M5H 2C9

Tel: XXX-XXX-XXXX x344

Fax: XXX-XXX-XXXX

www.geosoft.com <http://www.geosoft.com>;

-- 
Rich Smrcina
VM Assist, Inc.
Phone: XXX-XXX-XXXX
Ans Service:  XXX-XXX-XXXX
user-61add9955ef9@xymon.invalid

Catch the WAVV!  http://www.wavv.org
WAVV 2008 - Chattanooga - April 18-22, 2008

list Eric Meddaugh · Tue, 29 May 2007 10:18:07 -0400 ·

 

I wrote one here to monitor msSQL servers, not sure on the version.  It
runs from the unix hobbit server, it requires DBD::Sybase and DBI.

 
The tar needs to be extracted to /home/hobbit/server/ext (change paths
in the files if you use a different structure ).

 
Change the "dbinfo" to reflect your login user/password.  You'll have to
grant access for the user to "sysservers" to select the "srvname" and
"srvid". (see scripts).

 
You'll just need to add to the host tag, "mssql:<PORT>"

 
At some point it may be expanded to gather more additional stats and
report it as "data" to the hobbit server.

 
It probably should be put into The Shire, however that is done.

 
---Eric

▸ quoted from Jason Chambers

From: Jason Chambers [mailto:user-3fa671c0a30d@xymon.invalid] 
Sent: Tuesday, May 29, 2007 09:52
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] BBwin script monitor sql 2005

Does anyone know where I can get a script to monitor sql 2005 servers,
x64? Deadcat.net appears to be useless now.

Jason Chambers

IT Helpdesk Support

  <http://www.geosoft.com/>; eosoft Inc.

XX Richmond St. West - 8th Floor

Toronto, Ontario, Canada

M5H 2C9

Tel: XXX-XXX-XXXX x344

Fax: XXX-XXX-XXXX

www.geosoft.com

list Rich Smrcina · Tue, 29 May 2007 09:23:59 -0500 ·

OK, thanks for the tip.

▸ quoted from Jason Chambers


Jason Chambers wrote:

But only works on Sql 2000, or x86 platforums.

Jason Chambers
IT Helpdesk Support
Geosoft Inc.
XX Richmond St. West - 8th Floor
Toronto, Ontario, Canada
M5H 2C9
Tel: XXX-XXX-XXXX x344
Fax: XXX-XXX-XXXX
www.geosoft.com

-- 
Rich Smrcina
VM Assist, Inc.
Phone: XXX-XXX-XXXX
Ans Service:  XXX-XXX-XXXX
user-61add9955ef9@xymon.invalid

Catch the WAVV!  http://www.wavv.org
WAVV 2008 - Chattanooga - April 18-22, 2008

list Galen Johnson · Tue, 29 May 2007 10:31:50 -0400 ·

Eirc, you already have at least 2 monitors you've submitted...however, it's been made easier (on me):
 
http://www.trantor.org/theshire/doku.php/faq question #2.
 
=G=

▸ quoted from Eric Meddaugh

From: Eric Meddaugh [mailto:user-4e1e735fdc96@xymon.invalid] 
Sent: Tuesday, May 29, 2007 10:18 AM
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] BBwin script monitor sql 2005

I wrote one here to monitor msSQL servers, not sure on the version.  It runs from the unix hobbit server, it requires DBD::Sybase and DBI.

The tar needs to be extracted to /home/hobbit/server/ext (change paths in the files if you use a different structure ).

Change the "dbinfo" to reflect your login user/password.  You'll have to grant access for the user to "sysservers" to select the "srvname" and "srvid". (see scripts).

You'll just need to add to the host tag, "mssql:<PORT>"

At some point it may be expanded to gather more additional stats and report it as "data" to the hobbit server.

It probably should be put into The Shire, however that is done.

---Eric

From: Jason Chambers [mailto:user-3fa671c0a30d@xymon.invalid] 
Sent: Tuesday, May 29, 2007 09:52
To: user-ae9b8668bcde@xymon.invalid
Subject: [hobbit] BBwin script monitor sql 2005

Does anyone know where I can get a script to monitor sql 2005 servers, x64? Deadcat.net appears to be useless now.

Jason Chambers

IT Helpdesk Support

  <http://www.geosoft.com/>; eosoft Inc.

XX Richmond St. West - 8th Floor

Toronto, Ontario, Canada

M5H 2C9

Tel: XXX-XXX-XXXX x344

Fax: XXX-XXX-XXXX

www.geosoft.com

BBwin script monitor sql 2005 🔗 link

BBwin script monitor sql 2005