Losing Database Connectivity

[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

 

[Miha Markic [MVP C#]]

You have to do inspection - sql profiler, logging, etc.