Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gautamsaraswat88
Starting Member
2 Posts |
 Posted - 2011-11-20 : 12:51:51
|
| Hello everyone,i want to know about Sql Server tunning As what is sql tunning?Why we use it?and how to do it?Thanks in Advance |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-11-20 : 13:05:44
|
| Tuning (one n only) is the process of making one or more SQL queries run more optimally.Re how you do it, entire books have been written on that.http://www.amazon.com/Server-Performance-Tuning-Distilled-Experts/dp/1430219025/ref=sr_1_1?s=books&ie=UTF8&qid=1321812326&sr=1-1http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server-2005/dp/0735621969/ref=sr_1_2?s=books&ie=UTF8&qid=1321812326&sr=1-2--Gail ShawSQL Server MVP |
 |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
|
|
anita.86
Starting Member
21 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-12-11 : 04:56:15
|
| For Query tuning , there are predeployment queries and post deployment queries. Both require optimisation. The first type need to be optimised, the second type need to be optimised ONCE they are identified as causing the problem.For sql server tuning - try and identify bottlenecks - analysing waits at the instance level is an effective approach - then links the waits with specific tuning activityJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Sql Server Tunning