MONITORING DATABASE SPACE GROWTH

Hi guys,

Would like to ask regarding of what module can help me for monitoring of the database growth? It is actually monitoring of space being used by the database for the past months up to present. Cant see it on SAM and DPA. I am not actually sure if SRM can solve my problem.

Thanks,

Find more posts tagged with

sam

Database

space

npm

srm

growth

nta

monitoring

Accepted answers

chad.every

This should be available via SAM using the AppInsight for SQL template.

2017-07-05 10_39_57-AppInsight for SQL - Summary - SE_SQLSERVER.png

When you click into any of the databases you can get more info.

2017-07-05 10_41_56-SQL Database - SolarWindsOrion-Tolman.png

Clicking into any of the files gives you the historical trends.

2017-07-05 10_42_48-Custom Chart - Database Size for E__Program Files_Microsoft SQL Server_MSSQL11.S.png

I guess this is all assuming you're using MSSQL.

All comments

chad.every

This should be available via SAM using the AppInsight for SQL template.

2017-07-05 10_39_57-AppInsight for SQL - Summary - SE_SQLSERVER.png

When you click into any of the databases you can get more info.

2017-07-05 10_41_56-SQL Database - SolarWindsOrion-Tolman.png

Clicking into any of the files gives you the historical trends.

2017-07-05 10_42_48-Custom Chart - Database Size for E__Program Files_Microsoft SQL Server_MSSQL11.S.png

I guess this is all assuming you're using MSSQL.

mesverrum

You should be able to collect that information from SAM, and indirectly even NPM would let you know by monitoring the capacity of disk volumes.

Via SAM Appinsight template

You can also set an alarm condition when growth rates exceed a specified percentage in 24 hours.

solarmarcs

Wow thank you a lot! tried looking for it using DPA but it is not there. But I have a question, when I drill down the appinsight for SQL template, the server that I want to monitor is not there? Yes, it is an SQL server.

solarmarcs

Thank you for this, really helped me a lot. But one thing, why is that the sql server isnt on the appinsight template? only some of our servers appeared. what could be the possible reasons why is it not there?

HolyGuacamole

Just means you haven't applied the template to those SQL servers. Click on "list resources" for the node and choose 'AppInsight for SQL'

Also, note that AppInsight automatically calculates a daily growth rate for you

http://oriondemo.solarwinds.com/Orion/APM/SqlBlackBox/SqlBlackBoxDatabaseDetails.aspx?NetObject=ABSD:124

Scroll to the Storage resource of charts

praveen_v

Whether it is part of SAM license ?

solarmarcs

Hi!

I already added the Appinsight in list resources. But im still unable to see the ALL DATABASE. What should I need to do? Thanks!

solarmarcs

Thank you, this helped me a lot. I am not able to see all the needed databases' size. Greatly appreciated!