Leveraging Compression for SQL Server Performance

Tegile

Indexing is king when it comes to achieving the highest levels of performance in SQL Server. When indexing is correctly combined with compression (an 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 and 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.
Watch Now

Spotlight

Apache Hadoop is one of the primary technologies used to analyze Big Data today. It offers both tremendous opportunities and challenges for someone just starting the Big Data journey. See how easy Microsoft Azure HDInsight makes it for you to start using Hadoop technologies to get you started on you


OTHER ON-DEMAND WEBINARS

Zero Trust in Practice: Why Identity Drives Next-Gen Access

Zero Trust is quickly becoming the dominant security model for the cloud, shifting the perimeter from the network to the people and devices that make up a modern workforce. As a model with many moving parts, the immediate question is where to start? View this on-demand webinar to learn: The full Zero Trust reference architecture

The Dynamic Future of Business and the Access Management Imperative

The volume, complexity, and pace of all the critical elements of business are undeniably increasing. The question is not whether or not commerce will undergo a dramatic transformation in the coming years, but what - precisely - that transformation will look like, what new opportunities it will present, and - most importantly - w

Gartner Magic Quadrant for Cloud Financial Planning and Analysis Solutions

Financial Planning and Analysis (FP&A) solutions support the office of finance’s efforts to manage financial planning and budgeting as well as financial modeling and performance reporting. Application leaders should use this Magic Quadrant to identify vendors that are a good match for their business needs. This report highlights

Overloaded infrastructure, overworked staff? Automated help is here.

IT infrastructure has never stopped becoming more complex and more critical to business, and the load on both that infrastructure and the personnel that run it has never stopped growing. As a result, automation has become a major competitive area for infrastructure vendors. This webinar looks at the way to approach automation, a

Spotlight

Apache Hadoop is one of the primary technologies used to analyze Big Data today. It offers both tremendous opportunities and challenges for someone just starting the Big Data journey. See how easy Microsoft Azure HDInsight makes it for you to start using Hadoop technologies to get you started on you

resources