Planning for tunning Database SQL Server 2000, 2005 and 2008
-
13 Mart 2012 Salı 14:39
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!!.
Tüm Yanıtlar
-
13 Mart 2012 Salı 14:45
Check this article: - http://technet.microsoft.com/en-us/library/cc966540.aspx
Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
|Team Blog:- Team Blog- Yanıt Olarak İşaretleyen Maggie LuoMicrosoft Contingent Staff, Moderator 05 Nisan 2012 Perşembe 03:10
-
13 Mart 2012 Salı 15:00
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- Yanıt Olarak İşaretleyen Maggie LuoMicrosoft Contingent Staff, Moderator 05 Nisan 2012 Perşembe 03:10
-
28 Mart 2012 Çarşamba 08:46Moderatör
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.
- Yanıt Olarak İşaretleyen Maggie LuoMicrosoft Contingent Staff, Moderator 05 Nisan 2012 Perşembe 03:10
-
28 Mart 2012 Çarşamba 10:49Yanıtlayıcı
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/
- Yanıt Olarak İşaretleyen Maggie LuoMicrosoft Contingent Staff, Moderator 05 Nisan 2012 Perşembe 03:11