Solved

vcentre on SQL Express database needs size email alerting setup

Posted on 2016-08-16
7
71 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 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
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
Comment Utility
4 hosts and about 100 vms
0
 
LVL 117

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE)
Comment Utility
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
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 45

Expert Comment

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

Expert Comment

by:Vitor Montalvão
Comment Utility
L-Plate did you move to another SQL Server Edition?
0
 
LVL 117

Accepted Solution

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

Expert Comment

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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

When we have a dead host and we lose all connections to the ESXi, and we need to find a way to move all VMs from that dead ESXi host.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

772 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

10 Experts available now in Live!

Get 1:1 Help Now