Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

VMWARE vCenter install SQL Express or full SQL ???????/

Posted on 2014-01-09
6
Medium Priority
?
6,727 Views
Last Modified: 2014-01-17
from what I read I think I would want a real SQL 2008 standard and not SQL 2008 express

I have 6 hosts with 192 GB each ,, brand new servers and expect 200-300 VMs, VCOPS< VCAC etc

thanks
0
Comment
Question by:NAMEWITHELD12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 

Accepted Solution

by:
ILOVEENTERPRISEDESKTOP earned 336 total points
ID: 39770272
You could run Sql express 2008 as the number of ESXI host limit is 5-10 but you might have to keep purging data regularly  as sql express gives you just 10 MB and would run into multiple issues .

I would recommend you to use Full blown servers as you would have to install VCOPS and VCAC Database on it .

Refer to the link and you can choose database accordingly http://partnerweb.vmware.com/comp_guide2/sim/interop_matrix.php
0
 
LVL 13

Assisted Solution

by:SagiEDoc
SagiEDoc earned 336 total points
ID: 39770331
SQL Express used to be limited to 4GB of data per database. This limit has since been dropped. However for me personally the biggest advantage using Standard over Express is in Standard you are able to schedule backups and maintenance jobs on the database. The performance data that VMware stores in the database can put a huge load on the database, and it is important to keep the database maintained. Having said that you can run Express and do all this with scripts and schedule them with the Windows scheduler to run. So in the end it will come down to a cost factor, if you can afford Standard or already have it, then IMO use it.
0
 
LVL 123

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 332 total points
ID: 39770367
SQL 2008 Express is suitable for your installation, because you have a small number of hosts.

SQL 2008 Express is not limited to database size anymore, which often was an issue.

It really comes down, on how you want to manage your SQL databses?

e.g. we are in the process of building a Super SQL Db Server, for all our Management e.g. VMware vSphere and Microsoft Hyper-V, and SCVMM 2012 R2.

This will be based on FULL SQL.
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 13

Assisted Solution

by:Abhilash
Abhilash earned 332 total points
ID: 39771084
I also suggest you to take a look at the vCenter server appliance. It comes with a built in DB and can accommodate up to 100 Hosts and 300 VM's. You will be saving two windows licenses and also SQl if you are planning to go for standard edition.
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 332 total points
ID: 39772793
SQL Express used to be limited to 4GB of data per database. This limit has since been dropped.
...
SQL 2008 Express is not limited to database size anymore, which often was an issue.


Both SQL Server 2008 and 2012 Express Edition are limited to 10GB.
0
 
LVL 20

Assisted Solution

by:compdigit44
compdigit44 earned 332 total points
ID: 39775399
According to the following link, I believe Perkins is correct there is a 10GB cap on a SQL Express DB..

http://www.ginktage.com/2013/03/what-are-the-limitations-of-sql-server-express-edition/

I to think you should look at deploying the vCenter 5,5 Virtual Appliance for you role
out..

http://www.yellow-bricks.com/2013/08/26/vsphere-5-5-nuggets-vcenter-server-appliance-limitations-lifted/
0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question