mssql queries need to be monitor

[vaibhav beohar]

Hi,

Through my nagios xi want to check the status of my mssql queries,
how may queries get inserted at what time , what are the transaction or query get failed and at what time , what are the sql statement get failed etc etc,
is there any way in nagios xi to monitory above statements.


Thanks.

[scottwilkerson]

Nagios XI can use the MSSQL wizard to run any query you specify against the MSSQL Server. You you can formulate a query that will give the desired results, then you can use that query in Nagios XI to check whatever you want to check.

The tricky part for you will be formulating the query so it returns the desired result.

[vaibhav beohar]

Thanks for reply . do you have any example query to check the failed transaction ?

Thanks.

[scottwilkerson]

I don't have one, you want want to check with a MSSQL administrator

[vaibhav beohar]

Hi Team,

While updating my nagios xi with latest release getting following.



[root@nagiosflex nagiosxi]# ./upgrade
Loaded plugins: fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
* base: centos.01link.hk
* extras: centos.01link.hk
* rpmforge: apt.sw.be
* updates: centos.aol.in
Setting up Install Process
Package bc-1.06.95-1.el6.i686 already installed and latest version
Package dstat-0.7.0-1.el6.noarch already installed and latest version
Package expat-devel-2.0.1-11.el6_2.i686 already installed and latest version
Package mailx-12.4-6.el6.i686 already installed and latest version
Package 1:mod_ssl-2.2.15-15.el6.centos.1.i686 already installed and latest version
Package numpy-1.4.1-9.el6.i686 already installed and latest version
Package openldap-2.4.23-26.el6_3.2.i686 already installed and latest version
Package openldap-devel-2.4.23-26.el6_3.2.i686 already installed and latest version
Package python-lxml-2.2.3-1.1.el6.i686 already installed and latest version
Package python-simplejson-2.0.9-3.1.el6.i686 already installed and latest version
Package rpmdevtools-7.5-1.el6.noarch already installed and latest version
Package rrdtool-python-1.3.8-6.el6.i686 already installed and latest version
Package sudo-1.7.4p5-13.el6_3.i686 already installed and latest version
Nothing to do
--2012-09-04 17:16:28-- http://assets.nagios.com/downloads/nagi ... 86.tar.bz2
Resolving assets.nagios.com... 72.14.181.71
Connecting to assets.nagios.com|72.14.181.71|:80... failed: Connection timed out.
Retrying.

--2012-09-04 17:17:32-- (try: 2) http://assets.nagios.com/downloads/nagi ... 86.tar.bz2
Connecting to assets.nagios.com|72.14.181.71|:80... failed: Connection timed out.
Retrying.

--2012-09-04 17:18:37-- (try: 3) http://assets.nagios.com/downloads/nagi ... 86.tar.bz2
Connecting to assets.nagios.com|72.14.181.71|:80... failed: Connection timed out.
Retrying.

--2012-09-04 17:19:43-- (try: 4) http://assets.nagios.com/downloads/nagi ... 86.tar.bz2
Connecting to assets.nagios.com|72.14.181.71|:80... ^CTraceback (most recent call last):
File "./install", line 21, in <module>
tarname = tarfile.open( wkversion , 'r:bz2' )
File "/usr/lib/python2.6/tarfile.py", line 1670, in open
return func(name, filemode, fileobj, **kwargs)
File "/usr/lib/python2.6/tarfile.py", line 1741, in bz2open
fileobj = bz2.BZ2File(name, mode, compresslevel=compresslevel)
IOError: [Errno 2] No such file or directory: 'wkhtmltopdf-0.10.0_rc2-static-i386.tar.bz2'


Regards,
Vaibhav.

[scottwilkerson]

Does you XI machine have internet access?

[vaibhav beohar]

Hi,


Yes my machine have internet enabled, and i have set proxy in /etc/wgetrc file... but i am getting some different error.

root@nagiosflex nagiosxi]# ./upgrade
Loaded plugins: fastestmirror, refresh-packagekit
Loading mirror speeds from cached hostfile
* base: centos.01link.hk
* extras: centos.01link.hk
* rpmforge: apt.sw.be
* updates: centos.01link.hk
Setting up Install Process
Package bc-1.06.95-1.el6.i686 already installed and latest version
Package dstat-0.7.0-1.el6.noarch already installed and latest version
Package expat-devel-2.0.1-11.el6_2.i686 already installed and latest version
Package mailx-12.4-6.el6.i686 already installed and latest version
Package 1:mod_ssl-2.2.15-15.el6.centos.1.i686 already installed and latest version
Package numpy-1.4.1-9.el6.i686 already installed and latest version
Package openldap-2.4.23-26.el6_3.2.i686 already installed and latest version
Package openldap-devel-2.4.23-26.el6_3.2.i686 already installed and latest version
Package python-lxml-2.2.3-1.1.el6.i686 already installed and latest version
Package python-simplejson-2.0.9-3.1.el6.i686 already installed and latest version
Package rpmdevtools-7.5-1.el6.noarch already installed and latest version
Package rrdtool-python-1.3.8-6.el6.i686 already installed and latest version
Package sudo-1.7.4p5-13.el6_3.i686 already installed and latest version
Nothing to do

Error parsing proxy URL http://abc:xyz123#@proxy2.mycompany.com:8080: Bad port number.

Traceback (most recent call last):
File "./install", line 21, in <module>
tarname = tarfile.open( wkversion , 'r:bz2' )
File "/usr/lib/python2.6/tarfile.py", line 1670, in open
return func(name, filemode, fileobj, **kwargs)
File "/usr/lib/python2.6/tarfile.py", line 1741, in bz2open
fileobj = bz2.BZ2File(name, mode, compresslevel=compresslevel)
IOError: [Errno 2] No such file or directory: 'wkhtmltopdf-0.10.0_rc2-static-i386.tar.bz2'

[scottwilkerson]

If you proxy password has special chars you may need to escape them in /etc/wgetrc