- Check that only the required columns are selected [in select statements]
- Check that the right types of joins are used
- Check that if re-ordering the joins will help or not
- Check the indexes of the tables [is indexing done on the right columns]
- Check that in joins you used the indexed columns in the join condition
- Check that the operating system is configured for optimum performance [for SQL Server]
- Use concepts like Scaling Up and Scaling Out to increase the overall performance of queries/SQL Server
- Use Dynamic Management Views to analyze the query performance/(query execution plans)
- Use hints to skip default query execution plan to introduce your plan for quick response. Use hints on join types or also for table index selection
- Check that the system and the network are appropriately configured and there are no issues that can cause the performance penalty
- Tools that may help in the analysis and improvement: DBCC Commands, Dynamic Management Views, SQL Server Profiler, SQL Server Management Studio, System Stored Procedures, and SQL Trace
- Check these articles for more information
From: http://sitestree.com/?p=5087
Categories:38
Tags:
Post Data:2013-01-20 11:22:32
Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a>
In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
<a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
