how to tune a query in sql server.... [Resolved]

Posted by Sureshij under Sql Server on 2/28/2014 | Points: 10 | Views : 991 | Status : [Member] | Replies : 2
what are the factors we need to consider while tuning a query....
wanted to know the things to be considered?

ij


Responses

Posted by: Bandi on: 2/28/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved

1) we need to look into execution plan and identify the costlier operations in the query

2) try to have proper indexes on table columns

3) avoid duplicate indexes

4) identify long running queries so that u can work on top long running queries

refer

https://www.simple-talk.com/sql/performance/tune-your-indexing-strategy-with-sql-server-dmvs/?_e_pi_=7%2CPAGE_ID10%2C2226852286


http://tutorial.programming4.us/windows_server/sql-server-2008-r2---a-performance-and-tuning-methodology-(part-3)---performance-and-tuning-design-guidelines.aspx

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sureshij, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Bandi on: 2/28/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
refer
https://medium.com/tech-talk/f834f09bafaf?_e_pi_=7%2CPAGE_ID10%2C5470154724

http://beginner-sql-tutorial.com/sql-query-tuning.htm



Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sureshij, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response