I want to build a SAM template with a custom SQL query monitor to keep track of the total size of the Syslog table in the SolarWinds database. How would I do that? Thanks for any help.
Bump please
Using a SQL query monitor try running this against the database.
Use InsertDatabaseName
Go
select o.name
, SUM(a.used_pages)*8096 AS 'Size(B)'
from sys.objects o
join sys.partitions p on p.object_id = o.object_id
join sys.allocation_units a on p.partition_id = a.container_id
where o.type = 'U' AND o.name = 'Syslog'
group by o.name
This will return the size in Bytes. You should then be able to transform the data as needed.
Another option is to use AppInsight for SQL against the SQL instance your Orion server uses.
