Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 105
  • Last Modified:

vcentre on SQL Express database needs size email alerting setup

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
L-Plate
Asked:
L-Plate
  • 3
  • 3
1 Solution
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
How many Hosts and VMs do you have ?

once at 10GB Express will stop, and vCenter Service will stop and abort, and terminate.
0
 
L-PlateAuthor Commented:
4 hosts and about 100 vms
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm second Andrew.
Btw, SQLMail should never be used since it has security issues.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
L-Plate did you move to another SQL Server Edition?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
do you require any more assistance, to close out ?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
At least chose a comment that really has the solution and not a question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now