How To Troubleshoot SQL Server 2005 Timeout Issues
Posted on 2007-11-15
I'm developing a .Net 2.0 application and have run in to a bit of a problem. My application runs great for an hour or two, but eventually, I start getting Timeout errors when trying to execute SQL commands. It's not every type of SQL either - just the Add, Update, Delete type activity...selects work well.
Anyway, what I really want to know is how can I monitor connections to my SQL 2005 database? I have a feeling something in my application is opening up resources and not closing them and eventually my SQL Server just stops responding.
I'd be happy to share all my code, but there's lots of it, and what I'm really looking for is a technique, not problem solving specific to this issue.