|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Losing Database ConnectivityAll,
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 You have to do inspection - sql profiler, logging, etc.
-- Show quoteMiha Markic [MVP C#] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ "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 > |
|||||||||||||||||||||||