Planning for tunning Database SQL Server 2000, 2005 and 2008

Question

Hi friends i need your help

I'm new on SQL Server 2008 Administration, is there an article or datasheet where specify a checklist for a planning tunning database (considerations for tunning, what i must tunning, tips, etc...) ?

Please help me with this.

Greetings

Aleds

PD:  If the article or datasheet also considerate SQL 2000 and SQL 2005, two thumbs up!!.

  

Answer 1

Check this article: - http://technet.microsoft.com/en-us/library/cc966540.aspx

---

Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
|Team Blog:- Team Blog

Answer 2

Hello,

Please see this article

http://www.databasedesign-resource.com/sql-server-maintenance-plan.html

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 3

Hi Aleds,

Check these links:
Tuning a Database: http://msdn.microsoft.com/en-us/library/ms178025(v=sql.100).aspx 
                             http://msdn.microsoft.com/en-us/library/ms190392(v=sql.100).aspx.

Thanks,
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 4

1.Analyze waits at the instance level.
2.Correlate waits with queues.
3.Determine a course of action.
4.Drill down to the database/file level.
5.Drill down to the process level.
6.Tune indexes/queries.

---

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