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 »