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

x
?
Solved

vcentre on SQL Express database needs size email alerting setup

Posted on 2016-08-16
7
Medium Priority
?
93 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
[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
  • 3
  • 3
7 Comments
 
LVL 123
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 123
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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 
LVL 52

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 52

Expert Comment

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

Accepted Solution

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

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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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 …
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.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

664 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