Hi friends,
I want to know that how can we increase SQL performance?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
AartiPosted Nov 14, 2011, 7:34 AM
to Increase SQL Performance use Query Optimization Tecniques.
Like: indexes,Sequences...Constraints, use of proper joins in yours SQL Queries So On....
for best refer http://msdn.microsoft.com
Thanks :)
Deepak DwijPosted Nov 14, 2011, 11:54 AM
Kunal NaikPosted Nov 13, 2011, 11:42 PM
In below link, is a good article for how to improving sql server perormance,
Click Here
Manoj SevdaPosted Nov 13, 2011, 11:24 PM
There are lot of reason which effect on sql server performance.
SQL Server Performance Killers
Let's now consider the major problem areas that can degrade SQL Server performance. By
being aware of the main performance killers in SQL Server in advance, you will be able to focus
your tuning efforts on the likely causes.
Once you have optimized the hardware, operating system, and SQL Server settings, the main performance killer in SQL Server are as follows, in a rough order (with the worth appearing first):
1. Poor Indexing
2. Inaccurate Statistics
3. Excessive blocking and deadlocks
4. Non-set-based operations, usually T-SQL cursors
5. Poor Query Design
6. Poor database design
7. Excessive fragmentation
8. Non-reusable execution plans
9. Poor Execution plans, Usually caused by parameter sniffing
10. Frequent recompilation of execution plans
11. Improper use of cursors
12. Improper configuration of the database log
13. Excessive use or improper configuration of tempdb
All above are main factor which is effect on SQL Server performance.