Tag: "performance"
PerfMon - Sizing an existing database environment
Estimating the number of I/Os required for a system is crucial when sizing one or multiple existing databases on a new I/O subsystem to the SQL Server. Often in mixed environments (OLTP/RDW) we must take the blended approach for managing the I/O for our… more »
Introducing Microsoft SQL Server 2012 - Free ebook
Introducing Microsoft SQL Server 2012 includes 10 chapters:
PART 1 DATABASE ADMINISTRATION (by Ross Mistry)CHAPTER 1 SQL Server 2012 Editions and Engine Enhancements CHAPTER 2 High-Availability and Disaster-Recovery Enhancements CHAPTER 3 Perf… more »
Troubleshooting Performance Problems in SQL Server 2008
There is a new withe paper on SQL Server 2008 performance troubleshooting and covers the following in depth: CPU Bottlenecks Memory Bottlenecks I/O BottlenecksSlow-Running Queries
Extended EventsData Collector and the MDWDownload from the Microsoft… more »
Tuning the Performance of Backup Compression in SQL Server 2008
There is an interesting technical note by using the backup compression and its benefits in SQL-Server 2008 at SQLCAT.
Follow up: http://sqlcat.com/technicalnotes/archive/2008/04/21/tuning-the-performance-of-backup-compression-in-sql-server-2008.aspx
CU… more »
