StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POA checklist for fixing .NET applications to SQL Server timeout problems and improve execution time
text
Body
copied!<p>A checklist for improving execution time between .NET code and SQL Server. Anything from the basic to weird solutions is appreciated.</p> <p><strong>Code:</strong></p> <p>Change default timeout in command and connection by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67438">avgbody</a>.</p> <p>Use stored procedure calls instead of inline sql statement by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67438">avgbody</a>.</p> <p>Look for blocking/locking using Activity monitor by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67387">Jay Shepherd</a>.</p> <p><strong>SQL Server:</strong></p> <p>Watch out for parameter sniffing in stored procedures by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#68183">AlexCuse</a>.</p> <p>Beware of dynamically growing the database by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67660">Martin Clarke</a>.</p> <p>Use Profiler to find any queries/stored procedures taking longer then 100 milliseconds by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67598">BradO</a>.</p> <p>Increase transaction timeout by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67438">avgbody</a>.</p> <p>Convert dynamic stored procedures into static ones by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67438">avgbody</a>.</p> <p>Check how busy the server is by <a href="https://stackoverflow.com/questions/67366/a-checklist-for-fixing-net-apps-to-sql-server-timeout-problems-and-improve-exec#67387">Jay Shepherd</a>.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload