Question
What techniques efficiently profile slow queries in an ASP.NET app causing SQL Server timeouts to reveal potential optimization opportunities?
hey, try using sql extende events (or profiler) to catch the slow queries and add logging in your asp.net code. i foudn it really helps to pinpoint the culprits causing timeouts. give it a shot!