1 of 1 people found this helpful
Capacity planning comes out of the box with SAM (an Orion module for servers and applications). However, you could create a custom metric in DPA to show overall storage usage.
What databases are you monitoring (Oracle, SQL, other)?
For top SQL, you can query the summary tables (it's going to be a LOT more performant than going against detail).
Try something like:
select name, id from cond -- to get the name of the instance you want the top SQL from
select sqlhash, sum(timesecs)/60
from con_sql_sum_<id from above query>
where period = 'D'
and datehour between '<begin date>' and '<end date>'
group by sqlhash, timesecs
order by timesecs desc
Thanks for the tip. I was hoping to find a way to export raw data to a csv file but I could probably use this to create my own SQL Server report.
Do you know if Solarwinds provides any documentation on their database structure?
For that, I'd recommend opening up a support case. I know we've shared information about the ERD previously...