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: indexesSequences...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.