314
Optimiser SQL Server
Papiers techniques et livres blancs Microsoft
(à chercher sur le site de Microsoft, les liens étant parfois changés)
Database Engine Tuning Advisor (DTA) in SQL Server 2005 – document Word.
Références web
• SQL Server Query Optimization Team, Distributed/Heterogeneous Query
Processing in Microsoft SQL Server, http://citeseer.ist.psu.edu/732761.html
• Physical Database Storage Design - http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
• Travaux de recherches sur lesquels est basé le Database Engine Tuning Advisor
– http://research.microsoft.com/research/dmx/autoadmin/
• SQL Server I/O Basics, Chapter 2 – http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx
• Working with tempdb in SQL Server 2005 – http://www.microsoft.com/technet/
prodtechnol/sql/2005/workingwithtempdb.mspx
Sites
• GUSS : http://www.guss.fr/
• developpez.com : http://sqlserver.developpez.com/
• forums developpez.com : http://www.developpez.net/forums/
• SQL Server Performance – http://www.sql-server-performance.com/
• SQL Server Central – http://www.sqlservercentral.com/
• SQL Server Magazine (payant) – http://www.sqlmag.com/
• Site Microsoft Technet – http://technet.microsoft.com/fr-fr/sqlserver/
• SQL Team – http://www.sqlteam.com/
• SQL Server Community – http://www.sqlcommunity.com/
• Simple Talk (site communautaire de RedGate, un éditeur d’outils tiers pour
SQL Server) – http://www.simple-talk.com/sql/
• Newsgroups Microsoft (USENET) : microsoft.public.fr.sqlserver, microsoft.public.sqlserver.programming. Cherchables via Google Groups : http://
groups.google.com/
Blogs
• SQL Server Storage Engine – http://blogs.msdn.com/sqlserverstorageengine/
• SQL Server Manageability Team Blog – http://blogs.msdn.com/sqlrem/
• Microsoft SQL Server Development Customer Advisory Team – http://
blogs.msdn.com/sqlcat/
• Microsoft SQL Server Support Blog – http://blogs.msdn.com/sqlblog/
• SQL Programmability & API Development Team Blog – http://
blogs.msdn.com/sqlprogrammability/