SQL Execution (Enterprise Manager-QA) VS. .NET Execution

home
database
view story

1 Kicks

SQL Execution (Enterprise Manager-QA) VS. .NET Execution(blog.davidyardy.com)

submitted by mmikey121(10) 3 years ago

I have been chasing an issue for quite a while where the query would timeout when executed from an ASP.NET interface. If I ran that exact same query through Query Analyzer the results would be returned in less than 2 seconds. I have for a while been struggling with why it is different between those two interfaces. I thought about connection pooling issues, command time outs and connection timeouts and was focused on that for a while.

add a comment |category: Database |Views: 9
Tweet