Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

SCOM Report of SQL database growth

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
IT-NYC
Asked:
IT-NYC
  • 4
  • 3
3 Solutions
 
jogosCommented:
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
 
IT-NYCAuthor Commented:
Used space. ABC GBs last month, XYZ GBs now.
0
 
jogosCommented:
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
Technology Partners: 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!

 
IT-NYCAuthor Commented:
Thanks, jogos!
All of these seem to be outside of SCOM. Have you tried to do it within SCOM?
Thanks!
0
 
jogosCommented:
No experience with SCOM
0
 
IT-NYCAuthor Commented:
Ok, thanks. I will have to try something else. EE doesn't have SCOM as a category :(
0
 
IT-NYCAuthor Commented:
Didn't fully answered my question
0

Featured Post

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.

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