Solved

vcentre on SQL Express database needs size email alerting setup

Posted on 2016-08-16
7
88 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 120
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 120
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 50

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 50

Expert Comment

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

Accepted Solution

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

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

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

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

Suggested Solutions

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
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

751 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