SQL Server Performance

Question

Hi friends, I want to know that how can we increase SQL performance?

Aarti · Answer

Hi 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 Dwij · Answer

Useful explaination Manoj.. thanks

Kunal Naik · Answer

Hi, In below link, is a good article for how to improving sql server perormance, Click Here

Manoj Sevda · Answer

Hi Friend, 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.

SQL Server Performance

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)