Browse by Tags

• Backup
• Bulk Import/Export
• Concurrency
• Conferences 2007
• Data Compression
• Database Mirroring
• DBCC
• DBCC CHECKDB Series
• Disaster Recovery
• FILESTREAM
• General
• Index Fragmentation Series
• On-Disk Structures
• Restore
• Service Level Agreements
• Shrink
• SQL Express
• SQL Server 2008
• SQL Server IO
• SQL Server Security
• TechEd 2006
• TechEd 2008
• TempDB
• VarDecimal Storage Format
• VLDB Maintenance

• Changes to sp_estimate_data_compression_savings stored procedure in SQL2008R2

  When you compress an object (index or table or partition), there are two components of space savings that you get. First component is fragmentaton (i.e. the original object might have been fragmented). The object gets degragmented as part of doing compression Read More... Posted Wednesday, September 16, 2009 8:53 PM by Sunil Agarwal | 0 Comments Filed under: Index Fragmentation Series, Data Compression

• A Unicode Compression example

  Now that we have Unicode compression available in SQL Server 2008R2 as described in, let me take a simple example using AdventureWorksDW database to show you the additional compression that can be achieved on tables with one or more columns of type NCHAR Read More... Posted Monday, August 17, 2009 4:37 AM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• Unicode Compression in SQL Server 2008R2

  In my previous blog , I had mentioned that unicode compression will be available as part of next SQL Server release named SQL 2008R2. You can down load the CTP2 version http://www.microsoft.com/sqlserver/2008/en/us/r2.aspx to play with it. This is a new Read More... Posted Monday, August 17, 2009 2:00 AM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• Customer feedback on Data Compression

  As I described in my previous blog , the data compression feature has been very successful. We do appreciate all the feedback that we have received as this provides us a way to know how customers have been using the feature and the challenges they are Read More... Posted Monday, August 17, 2009 1:44 AM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• Update on data compression performance/space-savings and links to published white papers

  It has been a while since I blogged about data compression so I thought it will be good to provide an update on data compression usage within SQL Server community. I am happy to say that the Data compression feature has been a tremendous success in SQL Read More... Posted Sunday, August 16, 2009 9:11 PM by Sunil Agarwal | 0 Comments Filed under: Data Compression

• TempDB Monitoring and Troubleshooting: Out of Space

  One of the key challenges in TempDB is that it is a common resource for all applications running on an instance and any misbehaving application or rouge user command can take up all the space in TempDB bringing down other applications with it. In my discussions Read More... Posted Monday, January 12, 2009 1:30 AM by Sunil Agarwal | 4 Comments Filed under: TempDB

• TempDB Monitoring and Troubleshooting: DDL Bottleneck

  This blog continues the discussion on the common issues in TempDB that you may need to troubleshoot. In previous blogs, I discussed how to identify and troubleshoot IO and allocation bottleneck in TempDB. In this blog, I will describe how to indentify Read More... Posted Monday, January 12, 2009 12:35 AM by Sunil Agarwal | 1 Comments Filed under: TempDB

• TempDB Monitoring and Troubleshooting: Allocation Bottleneck

  This blog continues the discussion on the common issues in TempDB that you may need to troubleshoot. In the blog http://blogs.msdn.com/sqlserverstorageengine/archive/2009/01/05/tempdb-monitoring-and-troubleshooting-io-bottleneck.aspx , we discussed how Read More... Posted Sunday, January 11, 2009 5:36 AM by Sunil Agarwal | 4 Comments Filed under: TempDB

• TempDB Monitoring and Troubleshooting: IO Bottleneck

  I hope my earlier blogs on TempDB (http://blogs.msdn.com/sqlserverstorageengine/archive/tags/TempDB/default.aspx ) have given you a good background on the objects contained in TempDB and its configuration and have deployed your workload in production Read More... Posted Monday, January 05, 2009 2:07 AM by Sunil Agarwal | 3 Comments Filed under: TempDB

• Managing TempDB in SQL Server: TempDB Configuration

  In my previous blogs, I described the types of objects in TempDB and how they are managed. I hope that it provided you with a good working knowledge of TempDB. Now the next question is how do I configure the TempDB for my production workload? In this Read More... Posted Sunday, January 04, 2009 11:48 PM by Sunil Agarwal | 2 Comments Filed under: TempDB

• What is allocation bottleneck?

  Allocation bottleneck refers to contention in the system pages that store allocation structures. There are three types of pages that store allocation structures as follows · PFS (Page Free Space): it tracks the following key information about each page. Read More... Posted Sunday, January 04, 2009 11:45 PM by Sunil Agarwal | 5 Comments Filed under: TempDB

• Managing TempDB in SQL Server: TempDB Basics (Version Store: Growth and removing stale row versions)

  In the previous blog http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/31/managing-tempdb-in-sql-server-tempdb-basics-version-store-logical-structure.aspx , I described the logical/physical structure of a row in version store. A natural question Read More... Posted Thursday, January 01, 2009 2:04 AM by Sunil Agarwal | 2 Comments Filed under: TempDB

• Managing TempDB in SQL Server: TempDB Basics (Version Store: logical structure)

  Now that we know a few things about Version Store, let us now look into its structure to understand how it stores rows from different tables/indexes with different schema. Interestingly, you don’t need to look far and the answer is available when you Read More... Posted Wednesday, December 31, 2008 7:03 AM by Sunil Agarwal | 1 Comments Filed under: TempDB

• Managing TempDB in SQL Server: TempDB Basics (Version Store: Simple Example)

  In order to understand the version store, let me start with an example. I will use a database that has RCSI (read committed snapshot) and SI (Snapshot Isolation) enabled as it provides more controlled environment to manage versions. When a database is Read More... Posted Wednesday, December 31, 2008 2:18 AM by Sunil Agarwal | 4 Comments Filed under: TempDB

• Managing TempDB in SQL Server: TempDB Basics (Version Store: Why do we need it?)

  Version store is a new entity in SQL Server 2005. It is used to store versions of data and index rows. A row version typically is an older copy of the data or an index row and is created to support existing (triggers) and new features (snapshot based Read More... Posted Monday, December 22, 2008 3:33 AM by Sunil Agarwal | 1 Comments Filed under: TempDB