How do I see how much space my syslogs are using on the disk? I am trying to decide on how long to keep them for.
One method would be to go and look at the Syslog DB table in the DB and see how much size it is and how many records
I can't get into the database.
Hi,
You can execute this SQL query from SolarWinds Database Manager:
sp_spaceused N'SysLog'
This gives you a bunch of information about the rows and sizes.
More information about this procedure and its output can be found here:
http://msdn.microsoft.com/en-us/library/aa260286(SQL.80).aspx
Thanks
