Intermittent Connection Issue - How to Monitor

We have a 3rd party application which uses a connection to a SQL
Server 2005 database. It intermittently loses connnection to the
database and displays an error. The vendor is playing hardball with
resolving the issues. What we would like to do is have a small
application that can run on the machine the client applilcation is
installed on and make connection checks and logs. This way if both
loose connection we can rule out the 3rd party software as being the
issue. However, if theirs looses connection and the monitor
application does not notice anything we can use that information as
leverage for dealing with the vendor.
Is there any such application out there that would do this?
Thanks in advance.Try this tool:
http://www.paessler.com/ipcheck/download
It has a free version that can be use to check every 15 minutes.
Thank you
Lucas
<lavaice@.gmail.com> wrote in message
news:1180719965.172880.52790@.g4g2000hsf.googlegroups.com...
> We have a 3rd party application which uses a connection to a SQL
> Server 2005 database. It intermittently loses connnection to the
> database and displays an error. The vendor is playing hardball with
> resolving the issues. What we would like to do is have a small
> application that can run on the machine the client applilcation is
> installed on and make connection checks and logs. This way if both
> loose connection we can rule out the 3rd party software as being the
> issue. However, if theirs looses connection and the monitor
> application does not notice anything we can use that information as
> leverage for dealing with the vendor.
> Is there any such application out there that would do this?
> Thanks in advance.
>|||What we are looking for is something that would actually establish a
SQL connection to the database and report back if and when it was
interrupted instead of just port monitoring or service monitoring.
Thanks
Jon
On Jun 1, 3:29 pm, "Lucas Kartawidjaja" <luk...@.hotmail.com> wrote:
> Try this tool:http://www.paessler.com/ipcheck/download
> It has a free version that can be use to check every 15 minutes.
> Thank you
> Lucas
> <lava...@.gmail.com> wrote in message
> news:1180719965.172880.52790@.g4g2000hsf.googlegroups.com...
> > We have a 3rd party application which uses a connection to a SQL
> > Server 2005 database. It intermittently loses connnection to the
> > database and displays an error. The vendor is playing hardball with
> > resolving the issues. What we would like to do is have a small
> > application that can run on the machine the client applilcation is
> > installed on and make connection checks and logs. This way if both
> > loose connection we can rule out the 3rd party software as being the
> > issue. However, if theirs looses connection and the monitor
> > application does not notice anything we can use that information as
> > leverage for dealing with the vendor.
> > Is there any such application out there that would do this?
> > Thanks in advance.|||So - write a little script that loops until an error is encountered and does
nothing but execute some sort of trivial statement. Use QA (or SMS or isql
or whatever tool you have) to execute it. You may want to look up WAITFOR
in BOL. Or perhaps just set up the profiler to monitor the dbms.