SolarWinds dbo.SysLog is too big
Posted on 2014-10-22
Our SolarWInds web console stopped responding for what I presume is the syslogs being too big. I see the following error in the logs:
2014-10-22 15:02:57.33 spid62 Error: 1105, Severity: 17, State: 2.
2014-10-22 15:02:57.33 spid62 Could not allocate space for object 'dbo.SysLog'.'IX_SysLog_DateTime' in database 'SolarWindsOrion' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
I am not a SQL kind of guy and would to know of there is any statements I can run to trim this thing. I am not interested in saving data older than 60 days. Also, where in the console can I change these settings so the database doesn't get this big.