Need Suggestions on Improving Performances of sql server

Question

Hi All,

Can some one List out or send me reading Articles Thing which will help  improve SQL server Performances and need some examples..

Thanks,

Maddy

Answer 1

Hello Maddy,

see e.g. Troubleshooting Performance Problems in SQL Server 2005

It shown up which performance problems can occur and if you know how to solve, then you know how to avoid them.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hi maddy,

SQL Server Performance Tips and Guidelines: http://www.codeproject.com/Articles/22853/SQL-Server-Performance-Tips-and-Guidelines.

Hope this helps,
Maggie

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 3

http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 4

Thanks Uri for sharing very good Articals