Improve SQLServer Performance?Performance improvements come from :- hardware , database design, and T-SQL code
1. Adding resources - RAM then followed by CPU in most environments today.(Dedicated database server.)
2. Fixing design problems before you go into production.
3. You may not know how database is going to grow and change organically over time
-> Review your indexing.
-> Review Statistics
frequently and keep your data partitioned.
4. Performance tuning.
Download : Troubleshooting SQL Server