Home All Groups Group Topic Archive Search About

Losing Database Connectivity

Author
20 Feb 2006 11:35 PM
Neal
All,

I have a windows service which polls the database every 10 seconds
(10000 ms).  When I change the frequency to 100 ms.  After a few hours,
the Windows Service does not even connect to the database anymore, nor
does it throw any errors.

I'm closing my connections properly and I noticed that it doesn't
affect any other applications that are hitting the same database.

Any thoughts?

Thanks,
Neal

Author
21 Feb 2006 8:14 AM
Miha Markic [MVP C#]
You have to do inspection - sql profiler, logging, etc.

--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote
"Neal" <neal.m.s***@gmail.com> wrote in message
news:1140478550.186719.299310@z14g2000cwz.googlegroups.com...
> All,
>
> I have a windows service which polls the database every 10 seconds
> (10000 ms).  When I change the frequency to 100 ms.  After a few hours,
> the Windows Service does not even connect to the database anymore, nor
> does it throw any errors.
>
> I'm closing my connections properly and I noticed that it doesn't
> affect any other applications that are hitting the same database.
>
> Any thoughts?
>
> Thanks,
> Neal
>

AddThis Social Bookmark Button