SQL Performance articles
(For internal use&search)
- Tuning
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx (Physical design)
http://www.sqlmag.com/Article/ArticleID/46377/sql_server_46377.html (Performance Tuning)
http://www.sql-server-performance.com/ac_filegroup_performance.asp (Optimizing Performance Files&Filegroups)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/msdn_sql7perftune.asp (SQL 7 PerfTune)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_536v.asp (Query tuning)
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx (SQL 2000 PerfTune DW)
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx (Transact Replic PerfTune)
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx (SQL Server Best Practices)
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/tempdb_capacity_planning_index.mspx (TEMPDB Cap)
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/loading_bulk_data_partitioned_table.mspx (Load Bulk)
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/dbcc_showcontig_improvements.mspx (DBCC SHOWCONTIG improv)
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx (DB Mirroring Best Pract)
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx (Troubleshotting Performance SQL 2005)
http://www.microsoft.com/technet/scriptcenter/scripts/sql/sql2005/default.mspx?mfr=true (Script repository)
http://www.microsoft.com/technet/prodtechnol/sql/2005/bestpractice/storage-top-10.mspx (Storage 10 Best Pract)
http://www.microsoft.com/technet/prodtechnol/sql/2005/bestpractice/oltp-performance-issues.mspx (Top SQL 2005 Perf OLTP)
http://www.sqlservercentral.com/columnists/jsack/2653.asp (Tuning SQL 2005)
http://www.simple-talk.com/sql/sql-server-2005/fine-tuning-your-database-design-in-sql-2005/ (Tuning SQL 2005)
http://www.sqlservercentral.com/columnists/pmu/2644.asp (SQL Application memory tuning) - Counters
http://www.sqlservercentral.com/columnists/kjambu/2677.asp (Performance Counters) - Índices e Planos de Execução
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1112905_tax301327,00.html?adg=301324&bucket=ETA
http://www.sql-server-performance.com/sql_server_maintenance.asp
http://www.sqlmag.com/Article/ArticleID/41844/sql_server_41844.html
http://www.developersdex.com/sql/message.asp?p=580&r=5117242 (Script)
http://education.sqlfarms.com/ShowPost.aspx?PostID=55
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
No comments:
Post a Comment