Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SCOM Report of SQL database growth

Posted on 2015-01-21
7
Medium Priority
?
725 Views
Last Modified: 2015-01-27
How to create a report in SCOM 2012 that would show a historical growth of a SQL database? Is someone has done it, please post specific steps.
Thanks!
0
Comment
Question by:IT-NYC
[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
  • 4
  • 3
7 Comments
 
LVL 25

Assisted Solution

by:jogos
jogos earned 1500 total points
ID: 40562548
What is growth?    Place used or allocated space in database, or allocated on disk?

Example using backup size
http://www.sqlskills.com/blogs/erin/trending-database-growth-from-backups/
0
 

Author Comment

by:IT-NYC
ID: 40562952
Used space. ABC GBs last month, XYZ GBs now.
0
 
LVL 25

Assisted Solution

by:jogos
jogos earned 1500 total points
ID: 40563310
Size of backup is a trend that  you can get out of database. Other sizes you have to gather periodicaly and exploit the captured data. Something like in following example
http://www.sql-server-performance.com/2014/monitor-data-growth/
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:IT-NYC
ID: 40564288
Thanks, jogos!
All of these seem to be outside of SCOM. Have you tried to do it within SCOM?
Thanks!
0
 
LVL 25

Expert Comment

by:jogos
ID: 40564672
No experience with SCOM
0
 

Accepted Solution

by:
IT-NYC earned 0 total points
ID: 40565325
Ok, thanks. I will have to try something else. EE doesn't have SCOM as a category :(
0
 

Author Closing Comment

by:IT-NYC
ID: 40572369
Didn't fully answered my question
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

598 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