How Microsoft SQL Server Helps You to Lower Your Cost of Storage
Play How Microsoft SQL Server Helps You to Lower Your Cost of Storage
Are increasing storage costs hurting your bottom line as data sizes keep growing throughout your organization? In this session, we explore how SQL Server can help you lower your storage costs. We start with Microsoft SQL Server 2005 partitioning to transparently migrate older data to lower-cost storage tiers over time. We then move over to SQL Server functionality such as DTA and specific DMVs that help you reduce storage consumption by adjusting your physical design plus storage-efficient backup and restore strategies. Last but not least, we discuss new storage cost-saving functionality in Microsoft SQL Server 2008 such as data compression, backup compression, and minimal logging which can get you to 50% or more reduction in storage requirements for typical applications. Throughout the session, we share experiences, insights, and best practices from SQL Server customers and Microsoft-internal deployments. Leran how to make good use of these technologies in combination, what they mean for server consolidation, how they impact the question about DAS vs. SAN, and how they relate to good application design.