June 3, 2013 at 3:40 am
Hi all,
How to do query tuning. Is there any methods for query tuning.how to find Query cost .What is the importance of this in tuning.
June 3, 2013 at 5:20 am
This is a very vast topic and can't be covered in forum posts
Do some search in Google and come back with specific doubts if any, we will be glad to help
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 3, 2013 at 6:03 am
Hello,
You can use following link for brief explanation about Performance Tuning,
http://msdn.microsoft.com/en-us/library/ms190957(v=sql.105).aspx
June 3, 2013 at 6:13 am
Kingston Dhasian (6/3/2013)
This is a very vast topic and can't be covered in forum posts
Kingston hit the nail on the head here. This is a huge topic and you should expect to invest considerable time and do lots and lots of reading. Performance tuning is both an art and a science. After you get the basics of indexes down, I'd recommend reading stuff by Gail Shaw and Kimberly Tripp - they're both excellent.
June 5, 2013 at 11:47 pm
Here is a post for a definition of query tuning - What is SQL Server Tuning? but in reality query tuning and database tuning in general requires solid knowledge across the performance stack. i.e storage,network,server etc
Jack Vamvas
sqlserver-dba.com
June 6, 2013 at 1:34 am
Query Performance Tuning Distilled - Grant Fritchey
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply