- 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=3659
Categories:Root, By Sayed Ahmed
Tags:
Post Data:2016-09-15 14:19:59
Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada
