Working with SQL Server for many years but in recent years, performance and tuning becomes a more and more popular topic at my work. At recent TechEd Australia, I have heard over so many sessions about these topics. Within the most mentioned, it is the TempDB. The TempDB is the critical part for SQL performance as it is the most read workplace in SQL Server and therefore, the configuration and disk IO would impact how SQL Server interact TempDB thus influence the performance. Thank you for these sessions and the presenters and I have gained a new level of knowledge.
I have collected some of the links here and hoping this can be help myself and others who are in the same boat keep learning.
The Basics
What is TempDB?
http://technet.microsoft.com/en-us/library/ms178028.aspx
Compilation of SQL Server TempDB IO Best Practices
http://blogs.msdn.com/b/cindygross/archive/2009/11/20/compilation-of-sql-server-tempdb-io-best-practices.aspx
Analyzing I/O Characteristics and Sizing Storage Systems for SQL Server Database Applications
http://msdn.microsoft.com/en-us/library/ee410782.aspx
SQL Server Performance in the Cloud, Windows Azure
Windows Azure SQL Database and SQL Server -- Performance and Scalability Compared and Contrasted
http://msdn.microsoft.com/en-us/library/windowsazure/jj879332.aspx
Other Reading
SQL IaaS Basics
SQL Server in Windows Azure Virtual Machines
http://msdn.microsoft.com/en-us/library/windowsazure/jj823132.aspx
High Availability and Disaster Recovery for SQL Server in Windows Azure Virtual Machines
http://msdn.microsoft.com/en-us/library/jj870962.aspx
Window Azure Storage
SOSP Paper - Windows Azure Storage: A Highly Available Cloud Storage Service with Strong Consistency
http://blogs.msdn.com/b/windowsazurestorage/archive/2011/11/20/windows-azure-storage-a-highly-available-cloud-storage-service-with-strong-consistency.aspx
SQL Server Backup and Restore with Windows Azure Blob Storage Service
http://msdn.microsoft.com/en-us/library/jj919148.aspx
USENIX Best Paper Award: Erasure Coding in Windows Azure Storage
http://blogs.msdn.com/b/windowsazurestorage/archive/2012/06/13/usenix-best-paper-award-erasure-coding-in-windows-azure-storage.aspx
