Creating a new Vcenter SQL db

stlhost
stlhost used Ask the Experts™
on
Will this be sufficient enough space for vcenter 6x db?

use [master] 
go 
CREATE DATABASE [vcenterdb] ON PRIMARY 
(NAME = N'vcenterdb', FILENAME = N'C:\vcenterdb.mdf', SIZE = 200000KB, FILEGROWTH = 10% ) 
LOG ON 
(NAME = N'vcenterdb_log', FILENAME = N'C:\vcenterdb.ldf', SIZE = 100000KB, FILEGROWTH = 10%) 
COLLATE SQL_Latin1_General_CP1_CI_AS 
go
use vcenterdb 
go 
sp_addlogin @loginame=[vpxuser], @passwd=N'vpxuser!0', @defdb='vcenterdb', @deflanguage='us_english'
go 
ALTER LOGIN [vcuser] WITH CHECK_POLICY = OFF 
go 
CREATE USER [vcuser] for LOGIN [vcuser]
go
use MSDB
go
CREATE USER [vcuser] for LOGIN [vcuser]
go

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
Commented:
That should be sufficient for the beginning ad it will grow as needed however you need to monitor the free space on the disk/LUN where the C:\vcenterdb.mdf file will be located as it has unrestricted growth and also make sure appropriate maintenance(backups) exists so T-log space can be recycled because it is caped at 2GBG.

Here: https://www.vmware.com/support/vsphere4/doc/vsp_4x_db_calculator.xls you can find a calculator for your VM DB(s) size.

Last not least...usually you don't put DB files on C:\ root but on other drives/LUNs in some folders.

Author

Commented:
Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial