Solved

SCOM Report of SQL database growth

Posted on 2015-01-21
7
509 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
  • 4
  • 3
7 Comments
 
LVL 25

Assisted Solution

by:jogos
jogos earned 500 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 500 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL STANDARD CORE 7 31
how to just get time from a date 6 32
SQL R 21 26
Getting invalid Syntax SQL. 3 19
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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

856 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