VMware: VMotion Info

In deze post lees je hoe je informatie uit de VC database kunt halen d.m.v. een query. Het gaat dan in het bijzonder om het aantal VMotion taken die gestart zijn. Je kunt dan na gaan hoe vaak een VM wordt gevmotioned via een handmatige taak of via DRS.

De volgende query kun je loslaten op VC database:

SELECT vpx_event.event_type, vpx_event.vm_name, vpx_event.create_time from vpx_event where event_type like ‘%migrate%’
SELECT distinct(vpx_event.event_type) from vpx_event order by event_type


De volgende informatie komt dan terug uit de query:


Het gaat dan om de volgende event_types:

  • vim.event.VmMigratedEvent (handmatige VMotion)
  • vim.event.DrsVmMigratedEvent (VMotion via DRS)


Meer informatie vind je in het volgende Topic op VMUG.nl gestart door Gabrie.


VMware: The DB user entered does not have the required permissions

Bij het vers installeren van VirtualCenter 2.5 kreeg ik bij het configureren de volgende foutmelding:


Dit kwam omdat ik bij de gebruiker in SQL 2000 geen ‘Server Roles’ had toegevoegd. De volgende Roles heb je nodig voor een succesvolle installatie:

  • System Administrators
  • Server Administrators
  • Database Creators (ik weet niet zeker of deze erbij moet, dit heb ik voor de zekerheid gedaan).


Meer informatie over het installeren / upgraden van je VC Database vind je hier:

VM ID: 1003346

VM ID: 1003610

Microsoft: Infrastructure Planning and Design



Infrastructure Planning and Design guides share a common structure, including:

  • Definition of the technical decision flow through the planning process.
  • Listing of decisions to be made and the commonly available options and considerations.
  • Relating the decisions and options to the business in terms of cost, complexity, and other characteristics.
  • Framing decisions in terms of additional questions to the business to ensure a comprehensive alignment with the appropriate business landscape.

These guides complement product documentation by focusing on infrastructure design options.
Each guide leads the reader through critical infrastructure design decisions, in the appropriate order, evaluating the available options for each decision against its impact on critical characteristics of the infrastructure. The IPD Series highlights when service and infrastructure goals should be validated with the organization and provides additional questions that should be asked of service stakeholders and decision makers.
IPD consists of the following downloadable packages:

  • Infrastructure Planning and Design Series Introduction
  • Selecting the Right Virtualization Technology
  • Microsoft SoftGrid Application Virtualization
  • Windows Server Virtualization (for Windows Server 2008 Hyper-V and Virtual Server 2005 R2 SP1)
  • New! Windows Deployment Services
  • New! Windows Server 2008 Active Directory Domain Services
  • New! Windows Server 2008 Terminal Services

The guides are available as individual downloads or as a single all-in-one package.
Send questions or feedback to us directly at SATfdbk@microsoft.com

System Requirements
  • Supported Operating Systems: Windows Server 2003; Windows Vista; Windows XP
  • These download files work with the following Office programs:
    • Microsoft Office Word 2007 (.docx)
    • Microsoft Office Word 2003 (.doc)
    • A Word viewer such as Word Viewer 2003.


  1. To start the download, select a file from the list of Files in this Download on this page.
  2. Save the .zip file to your preferred location on your computer.

Additional Information

Solution Accelerators are free, scenario-based guides and automations designed to help IT professionals who are proactively planning, deploying, and operating IT systems using Microsoft products and technologies. Solution Accelerator scenarios focus on security and compliance, management and infrastructure, and communication and collaboration.
More Information about the Solution Accelerator Notifications Newsletter
Register to receive the Solution Accelerator Notifications newsletter so that you can stay informed about new Solution Accelerator releases and updates. The newsletter covers such areas of interest as:

  • Communication and Collaboration
  • Security, Data Protection, and Recovery
  • Deployment
  • Operations and Management

You may also receive invitations to participate in accelerator development via beta programs and customer surveys. Solution Accelerator Notifications is currently available in English only.


You can download the documents over here: http://www.microsoft.com/downloads/

VMware: VirtualCenter 2.0.x and SQL 2005


Na een verse installatie van Windows 2003 SP2, SQL 2005 SP2 en VC 202 patch1 krijg ik de onderstaande foutmelding zodra ik de VC service wil starten.


Dit kun je oplossen door de volgende stappen uit te voeren:

If the VirtualCenter Server service installs but does not start and logs the following error, this is a symptom that the SQL Server 2005 SP1 database is not configured correctly:

Failed to init tableDef: Column VER_ID does not exist in table VPX_VERSION. Database version may be incompatible.

This condition can occur if VirtualCenter Server was installed using a database login mapped to a user other than dbo. When the VirtualCenter login is the owner of the database, the login automatically maps to the dbo user.
There are two ways to achieve the correct configuration:

  • Configure a fresh installation.
  • Repair a fresh installation that does not start.

To configure a fresh installation:

  1. Connect to your SQL Server 2005 server with SQL Server Management Studio.
  2. Create a database login (*vclogin*) for VirtualCenter Server to use.
  3. Create a new database (*VCDB*) and change the owner from <default> to vclogin.
  4. Observe that vclogin maps to the dbo database user for VCDB.
  5. Change the default database for vclogin from master to VCDB.
  6. Install VirtualCenter Server according to the product documentation.

To repair a fresh installation that does not start:
If the database has already been created and VirtualCenter Server has already been installed, it is possible to modify the owner of the database with a system stored procedure. In the steps below, substitute <vcuser> and <vclogin> with your appropriate account names.

  1. Connect to your SQL Server 2005 server with SQL Server Management Studio.
  2. Go to the db_owner schema properties and change the owner from <vcuser> to dbo.
  3. Delete the <vcuser> database user (not the <vclogin> database login that maps to it).
  4. Open a new query window for the VirtualCenter database.
  5. Execute this command:
    EXEC sp_changedbowner @loginame = ‘<vclogin>’, @map = ‘true’
  6. Start the VirtualCenter Server service.

Reference the VirtualCenter Server Release Notes at http://www.vmware.com/support/pubs/vi_pubs.html for details on supported databases and client driver versions. For information how to identify your SQL Server version and edition, reference the Microsoft Knowlege Base article 321185 at http://support.microsoft.com/kb/321185.

De bovenstaande tekst komt van het volgende document: http://kb.vmware.com

Bij mij was dit niet de oplossing. Ik heb er uiteindelijk voor gekozen om geen gebruik te maken van een SQL account maar van een Windows (AD) account welke rechten had op VC database. Daarna starte de VirtualCenter Service gewoon op.

VMware: Virtualize SQL Server?

Op deze vraag heeft VMware een antwoord namelijk de volgende whitepaper: SQLServerWorkloads.pdf.

De bovenstaande whitepaper is een performance study van VMware en HP over hoe je een  SQL server wel of niet moet Virtualiseren.

Dit is de conclusie van de performance study:

The performance results we describe in this paper support the conclusion that running Microsoft SQL Server 2005 inside VMware virtual machines can provide an effective production-ready platform for running transaction-processing workloads.
Your IT organization can leverage the sizing data we present in this white paper to deploy Microsoft SQL Server successfully using VMware Infrastructure 3. By comparing effective workload throughput and resource utilization for your datacenter with the results presented in this paper, you can design and size your virtualized environment to meet your SLA targets.
The number of actual users and transactions you can support in a production environment will, of course, depend on the specific applications used and the intensity of user activity. The results of
Conclusions 12 VMware SQL Server Performance in a VMware Infrastructure 3 Environment
our tests clearly demonstrate that in a VMware Infrastructure 3 environment, the transaction throughput scales almost linearly even as the number of clients increases, for every configuration we tested. Our results show that the throughput rate of UP virtual machine is comparable for 32-bit and 64-bit environments. However, for SMP virtual machines, the throughput rate is slightly higher in a 64-bit environment compared to a 32-bit environment. Further, SMP virtual machines can service a higher number of users. One disadvantage of SMP virtual machines is that they have higher CPU costs per transaction than UP virtual machines. From a performance perspective, we recommend using SMP virtual machines rather than UP virtual machines for Microsoft SQL Server, and if possible, a 64-bit environment if your application stack supports it.

How To: Setup and Configure SQL 2005 (Express)

Het volgende artikel http://technet.microsoft.com/ legt uit hoe je de setup door moet lopen. Dit spreekt echter voor zich.

Het KB artikel KB914277 legt uit hoe je remote connections in kunt schakelen.

Om even verder op KB914277 in te gaan, laat ik even een aantal printscreens zien. Tevens laat ik gelijk even zien hoe je een database aanmaakt en de daarbij behorende user toevoegd.

Continue reading “How To: Setup and Configure SQL 2005 (Express)”