Leveraging Compression for SQL Server Performance

Presented by

Sumeet Bansal & Neil Hambly

About this talk

ndexing is king when it comes to achieving highest levels of performance in SQL Server. When indexing is correctly combined with compression (Enterprise only feature), you can gain significant advantages. During this session, we will demo how to query dynamic management views (DMVs) to identify the right objects on which to implement compression, ways to measure performance and identify impact on memory and other resources. We will cover advanced scripts that provide details on fragmentation, memory caching & compression levels. We will also look at how someone who does not have the Enterprise Edition of SQL Server or latest edition of SQL Server can still leverage compression and gain the performance advantage using the right Flash Storage solution

Related topics:

More from this channel

Upcoming talks (0)
On-demand talks (49)
Subscribers (4577)
The transformation of enterprise IT is changing the performance and economics of enterprise storage. Flash storage arrays deliver high I/O and low latency for business applications such as databases, server virtualization and virtual desktops. Hear how our customers achieve business acceleration and unmatched storage capacity reduction.