?
Solved

SCOM Report of SQL database growth

Posted on 2015-01-21
7
Medium Priority
?
649 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
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.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

752 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