Capacity planning

Bump!

I would like this too!

Our DBA's are wanting to run a report which details capacity planning for our SQL databases as currently they use various methods which is very time consuming.

It would be good if i could get this from SolarWinds which reports on DB growth and DB anticipated growth based on the trend during monitoring - exactly like how SolarWinds does it for Disk, CPU & Memory forecasting.

Any ideas anybody?

Thanks.

Try this one, go to the reporting tool and try using the below as a custom SQL data source then build the report as you normally would.

SELECT top 20 *
FROM [dbo].[VolumesForecastCapacity] forecast
join [dbo].[Volumes] vol on vol.volumeid=forecast.instanceid
join [dbo].[Nodes] n on n.nodeid=vol.nodeid
join [dbo].[APM_applications] app on forecast.nodeid=app.nodeid
join [dbo].[APM_SqlBbApplication] sql on sql.applicationid=app.id
where bpeak>0
and DaysToCapacityPeak < 90
order by DaysToCapacityPeak

Because of the way things are joined it will filter the volume forecasts to only include disks that are on nodes that have the appinsight for sql assigned to them.

Maybe you should add something like

and VolumeType = 'Fixed Disk'

to the "where" clause to avoid showing virtual memory etc.