A checklist for fixing .NET applications to SQL Server timeout problems and improve execution time
- by avgbody
A checklist for improving execution time between .NET code and SQL Server.
Anything from the basic to weird solutions is appreciated.
Code:
Change default timeout in command and connection by avgbody.
Use stored procedure calls instead of inline sql statement by avgbody.
Look for blocking/locking using Activity monitor by Jay Shepherd.
SQL Server:
Watch out for parameter sniffing in stored procedures by AlexCuse.
Beware of dynamically growing the database by Martin Clarke.
Use Profiler to find any queries/stored procedures taking longer then 100 milliseconds by BradO.
Increase transaction timeout by avgbody.
Convert dynamic stored procedures into static ones by avgbody.
Check how busy the server is by Jay Shepherd.
