1 / 17

Optimizing SQL Server Performance in a Virtual Environment

DBI317. Optimizing SQL Server Performance in a Virtual Environment. Denny Cherry Independent Consultant www.mrdenny.com. www.mrdenny.com. mrdenny@mrdenny.com. @mrdenny. Denny Cherry. Topics of Discussion. Diagnosing Performance Problems Balloon Memory Drivers

vevina
Télécharger la présentation

Optimizing SQL Server Performance in a Virtual Environment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBI317 Optimizing SQL Server Performance in a Virtual Environment Denny Cherry Independent Consultant www.mrdenny.com

  2. www.mrdenny.com mrdenny@mrdenny.com @mrdenny Denny Cherry

  3. Topics of Discussion • Diagnosing Performance Problems • Balloon Memory Drivers • Memory Deduplication Options • Storage Configuration Options

  4. Diagnosing Performance Problems • Check Host and Guest CPU numbers • Check Host for CPU thrashing • Check Host and Guest for Disk IO latency

  5. Balloon Memory Drivers • Used by host OS to request memory back from the guest OS • Prevents host of from paging physical memory to the hosts swap file • Should be enabled • Lock pages in memory should be disabled, unless enabled for a specific reason

  6. Memory Reservations • Forces the memory to be available for the guest • Recommended that it be set to a portion of the allocated memory

  7. Memory Reservations • Forces the memory to be available for the guest • Recommended that it be set to a portion of the allocated memory

  8. Memory DeduplicationOptions • Great for OS memory • Doesn’t work at all for SQL Server • Unless… multiple SQL Servers have the same pages in cache

  9. Storage Configuration Options • IO is the same if the disks are physical or virtual • Use automatic tier adjusting technology if possible • Keep OS, data, logs, tempdb on separate disks if possible

  10. Storage Deduplication • Can greatly improve overall performance • By deduplicating OS virtual disks, we save much less data to the array • As less data is written to the array, less OS data is loaded into cache on the array

  11. Monitor, Monitor, Monitor • Did I mention that you need to monitor • Watch all levels of the environment • SQL Server • Guest • Hypervisor • Host • Storage

  12. Related Content • Breakout Sessions (VIR401, VIR308, VIR 309, DBI313, DBI312) Hands-on Labs (DBI12-HOL, DBI11-HOL) Product Demo Stations (demo station title and location) MCSE SQL Server 2012 Find Me Later At the SQL Server Booth

  13. DBI Track Resources @sqlserver @teched_europe #msTechEd SQL Server 2012 Eval Copy Hands-On Labs Get Certified! mva Microsoft Virtual Academy

  14. Resources Learning TechNet • Connect. Share. Discuss. • Microsoft Certification & Training Resources http://europe.msteched.com www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

  15. Evaluations Submit your evals online http://europe.msteched.com/sessions

  16. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related