If SQL database has poor performance, it will cause timeout issue during retrieve data. Usually, we have below tips to improve its performance:
- Re-build indexes (check the index fragmentation first)
- Review the SQL execution plan to find out the most time consuming part
- Rewrite the SQL to optimize the execution, overwrite the stored procedure if these steps don’t work
- find out the blocking or bottleneck for the statements
- check the fragmentation by scripts or manual
- check the useless indexes and missing Indexes, then add the missing indexes and delete useless indexes
- housekeep the database log file
- raise a performance ticket for investigating the issue with Microsoft (need to collect execution plan and profile trace)
Like!! Thank you for publishing this awesome article.
Like!! Great article post.Really thank you! Really Cool.
Like!! I blog frequently and I really thank you for your content. The article has truly peaked my interest.