So much Tech and so little time

5.5

So today a vCenter Server Service wouldnt start Java was going mental and we kept seeing event IDs 1105 and 1827. So what this means is our SQL Express instance reached the limits the size of databases i.e. 10GB on SQL Express 2008 R2.

You can confirm this by looking at the size of the VIM_VCDB.MDF file in c:\program files\Microsoft SQL Server\MSSQL10_50.VIM_SQLEXP\MSSQL\Data, if its 10GB then your in trouble.

So the first thing to do is fire up Microsoft SQL Server Management studio and run a standard report against the VIM_VCDB by right clicking the DB > Reports > Standard Reports > Disk Usage by Top Tables:

From here you can see which tables are causing the problems, in my case its dbo.VPX_EVENT_ARG which is massive.

So from here you need to purge the above table:

From Microsoft SQL Server Management studio

Click databases to expand and select VIM_VCDB > Tables.

Right-click the dbo.VPX_PARAMETER table and select Open.Note

: If you are using SQL Server 2008, right-click the dbo.VPX_PARAMETER table and click Edit Top 200 Rows.

Modify event.maxAge to 30, and modify the event.maxAgeEnabled value to true.

Modify task.maxAge to 30, and modify the task.maxAgeEnabled value to true.

Next run a built-in stored procedure to shink the logs:

Go to VIM_VCDB > Programmability > Stored Procedures.

3. Right-click dbo.cleanup_events_tasks_proc and select Execute Stored Procedure. This purges the data from the vpx_event, vpx_event_arg, and vpx_task tables based on the date specified for maxAge.

Now the records have been purged you need to shrink the DB:

As before connect using SQL Server Management Studio.

2. Right click on the VIM_VCDB database and New Query, when the white SQLQuery box opens type the below and click ! Execute

1

dbcc shrinkdatabase(VIM_VCDB,5)

3. It’ll start running and when its finished you should see:

Check the size of the file again and you should be able to start the services.

So a client asked me to upgrade their ESXi server from 5.1 to 5.5. Fairly straight forward if you rememeber this:

Update vCenter to 5.5,

Update vSphere Update Manager to 5.5,

Lastly update ESXi to 5.5.

So lets get going:

Update vCentre:

Firstly download the vCentre ISO: VMware-VIMSetup-all-5.5.0-2183112-20140901-update02.iso (or what ever is the latest version).

Logon to your vCentre server and run the ISO.

If all the components of the existing vCenter Server infrastructure are installed on the same machine, the easiest and fastest upgrade way it to select Simple Install on VMware vCenter 5.5 Installer screen. Remember that upgrading from 5.0 or 5.1 is much easier as SSO will be already installed and the upgrade of SSO will be almost seamless.
It will upgrade all necessary components of vCenter Server, starting with SSO. As you can see, I am upgrading from a version with SSO already installed (i.e. 5.1) so it says it will upgrade it.

After a few checks the upgrade process for SSO will start making sure that SSO users, groups and Lookup Services are migrated. The previous version will be uninstalled and the new one configured:
After Web Client, the next element is Inventory Service. You’ll be asked if you want to keep or overwrite your database:

And now vCenter Server itself will be upgraded:
After asking if the vCenter Server database should be upgraded
the installer will ask you a few other questions like if host agents should be updated automatically once vCenter Server upgrade is done or which account vCenter Server service should run on as well as you will be able to customized port used by vCenter Server. Finally the upgrade starts:
and the whole process completes successfully:
Once the vSphere Client is upgraded, you can check version of your vCenter Server:
Done. Almost everything has been done automatically and we were asked only for necessary information. If you want to have much more control over the upgrade process or if your vCenter Server components are installed on different machines, check the next post in the series when I show how to upgrade them.

Udate vSphere Update Manager:

Run the ISO again and choose Vsphere Update manager:

Tick the download if you have a internet connection:

Type your password for your installation:

Update:

Next through:

The installation will take the service off line so make sure no other Admins are working. Once finished you need to update your client.

vSphere Update Manager client update:

Open the vSphere Client, and log into the vCenter

From Plug-ins menu, select Manage Plug-ins

This should show the plug-in manager, that will show the VMware vSphere Update Manager, and blue link to download and install the plug-in.
At the end of the install, the plug-in will attempt to connect to the VUM server, accept the default certificate that is presented.

Note: This should add an Update Manager icon to the “Solutions and Application” portion of the vSphere Client:

Click on Browse and browse towards the ESXi 5.5 ISO image from your system and click on Next

Import ESXi Image wizard will detect the ESXi 5.5 information and click on Next to complete the Import.

Create a New Baseline for ESXi host upgrade.Enter the name ,description and Select Host Upgrade under Host baselines and click on Next

Select the ESXi Image to be included as part of this Upgrade baseline and click on Next.

Review the information for this baseline and click on Finish.

Select the cluster or Host to attach the newly created Host upgrade Baseline. Select the Update Manager tab and click on Attach. Select the checkbox for the baseline to attach to the Host. I am attaching this host upgrade baseline to my ESXi 5.5 host 192.168.1.1. Click on Attach

Click on Scan to check the compliance for the Host against the attached baseline.

If the attached baseline is applicable to the selected Host, Click on Remediate and click on Next.

Accept the End user License Agreement for this ESXi 5.5 upgrade and click on Next.

Verify the Upgrade settings.Select the checkbox if you want to remove the installed third-party software that is incompatible with the upgrade, and continue with the remediation and click on Next.

Enter the Task name and description. If you want to perform this upgrade in later time,Select the checkbox At time and define the time. I am doing it with immediately option. Click on Next.

Specify the Host Remediation option as per your requirement and click on Next.

Specify the cluster Remediation options as per your requirement and click on Next.

Review the selected remediation settings and click on Finish to start the Upgrade process.

Subscribe to my posts

Dont like Adverts

I know the adverts are annoying but I only use them to pay for hosting. If you find any of my posts useful then I’d really appreciate it if you could disable your ad-blocker and click a advert of two.
Or if not then you could buy me a coffee?
Thanks