Database for VMware Sql Express

Hi,

I have a concern here with using SQL Express. I understand that it is meant for 5 ESXi hosts and 50 VMs. - We have way outgrown this. We now have 9 ESXi hosts and around 80 or more VMs . When i run a health check from vcentre it is all green.

The only thing i have noticed is that vcentre is a little slow to load. - Do i really have a problem here. ? What do i need to do please
LVL 1
philb19Asked:
Who is Participating?
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
It very much depends on how you setup vCenter to collect the data, interval, statistics level, varies the db size. Every organisation is different.

You can use the sizing guide to work out exactly how much space is required.

Using the sizing guide you can specify the hosts, number of VMs, and the Statistic Intervals you are collecting, Interval Duration and Statics Level which will give you an actual value for your database.

It's not really a rough guide!


See here:-

How to calculate the database size for vCenter Server
Using vCenter Server, Select Administration, vCenter Server Settings, Statistics.
0
 
amarchandkCommented:
connect to SQL express database server with SQL management studio and check the vcdb data base size.

SQL express editions has 4GB database limit (SQL 2008 R2 has 10GB database limit). If you are reaching database limit size you may run into problem.
0
 
Nagendra Pratap SinghDesktop Applications SpecialistCommented:
Which express version is it?

Current express version have the capacity much higher than people think it has.

As already mentioned, the limit went up to 10 GB from 2 GB. They also have a management studio for this.

http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
The issue will be eventually the database will grow beyond the size Express can handle, so just check your DB size, on a regular basis.

Maybe no need to change immediately, but check db size on a regular basis.
0
 
philb19Author Commented:
Ok thanks very much for answers here -its SQL express 2008 R2 size of vcdb is around 800mb. I am still seeking an answer as to why VMware stipulate not to have more than 5 hosts - 50Vm with sql express. - Why do they say this when i have 9 hosts 80 Vm - 800mb sql db size - Are we just saying it is a rough guide?r is there more to this?
0
 
Nagendra Pratap SinghDesktop Applications SpecialistCommented:
It is a rough guide indeed. You can end up with a large database if you have lots of settings and retain lots of data.
0
 
philb19Author Commented:
Hi my concern was simply was it a hard limit - I mean go over 5 hosts and the db or systems will crash fail - it appears not to be the case i have 9 hosts 80 vms db size is 800mb - I take on what hancock says though and give him half points
0
 
Nagendra Pratap SinghDesktop Applications SpecialistCommented:
In this case I would like full points to be given to hanccocka
0
 
philb19Author Commented:
ok how - already awarded
0
 
Nagendra Pratap SinghDesktop Applications SpecialistCommented:
Moderators should be able to help.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
0
 
philb19Author Commented:
still dont know how to accept hanccocka answer - how do i do this - there is no link to request attention of resubmit answer
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Don't worry. Moderators will returned to Question, and Alter Outcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.