Solved

vcentre on SQL Express database needs size email alerting setup

Posted on 2016-08-16
7
79 Views
Last Modified: 2016-10-10
My vCentre is currently on SQL Express which does not have an SQL Agent to email stats.

Is there an alternative to get email alerts setup?

I'm looking to monitor database growth
0
Comment
Question by:L-Plate
  • 3
  • 3
7 Comments
 
LVL 118
ID: 41757771
How many Hosts and VMs do you have ?

once at 10GB Express will stop, and vCenter Service will stop and abort, and terminate.
0
 

Author Comment

by:L-Plate
ID: 41757863
4 hosts and about 100 vms
0
 
LVL 118
ID: 41757890
SQL Express is too small, for that infrastructure

I would recommend you use SQL FULL or switch to the appliance, you will exceed 10GB, and have to constantly clear the tasks and events tables.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41784704
I'm second Andrew.
Btw, SQLMail should never be used since it has security issues.
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41804819
L-Plate did you move to another SQL Server Edition?
0
 
LVL 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 500 total points
ID: 41823609
do you require any more assistance, to close out ?
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 41837013
At least chose a comment that really has the solution and not a question.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Last article we focus in how to VMware: How to create and use VMs TAGs – Part 1 so before follow this article and perform the next tasks, you should read the first article how to create the TAG before using them in Veeam Backup Jobs.
HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now