VMware: VirtualCenter Database Performance for Microsoft SQL Server 2005


 

VMware® VirtualCenter uses a database to store metadata on the state of a VMware Infrastructure
environment. Performance statistics and their associated stored procedure operations constitute the largest
and the most resource‐intensive component of the VirtualCenter database. Hence the performance of your
VirtualCenter database depends upon the frequency at which you collect performance statistics and the level
of detail of the statistics you store. VirtualCenter 2.5 features a number of enhancements that are aimed at
greatly improving the performance and scalability of the performance statistics operations in the
VirtualCenter database. The purpose of this study is to present the performance results of tests we conducted
to validate these performance enhancements and to provide best practices information for configuring a
VirtualCenter database. The study also provides information for sizing the server you use to host the
VirtualCenter database based on these performance results. Although the new features in VirtualCenter 2.5
benefit users with any of the supported databases, the examples and performance data presented in this study
are specific to Microsoft SQL Server and the paper assumes that you have a working knowledge of SQL Server.

This study covers the following topics:

  • “VirtualCenter 2.5 Database Overview” on page 2

  • “Performance Statistics Collection in VirtualCenter” on page 2

  • “Performance Statistics Database Operations and Their Effects on Performance” on page 3

  • “Performance Enhancement in VirtualCenter 2.5” on page 3

  • “Performance Tests” on page 4

  • “Performance Results” on page 5

  • “Sizing the VirtualCenter Database Server” on page 7

  • “Performance Best Practices” on page 8

  • “References” on page 9

  • “Appendix A: Configuring Performance Statistics Levels and Rollups with VirtualCenter” on page 10

  • “Appendix B: Configuring Memory Size for SQL Server” on page 11

  • “Appendix C: Monitoring

  • Je kunt de whitepaper hier downloaden: http://www.vmware.com/files/pdf/vc_database_performance.pdf

    Advertisements

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s