Solved

SolarWinds dbo.SysLog is too big

Posted on 2014-10-22
3
690 Views
Last Modified: 2014-11-04
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.

Thank you!
0
Comment
Question by:IDMA
3 Comments
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 250 total points
Comment Utility
For now I think the best thing to do is to provide some extra space for the file can grow.
I don't know SolarWinds but if we are talking about logs, shouldn't be a way to configure how old data should be purged?
By the error message I can guess a DELETE command to run in SQL Server:
DELETE FROM _Syslog WHERE DateTime < GETDATE()-60' 

Open in new window

0
 
LVL 25

Expert Comment

by:jogos
Comment Utility
"the syslogs being too big"
That is al relative, but surely now it needs more space.    Before deleting in the heat of the batle look at some things.
- is table/index realy big, more than you expect .... and how long is that data going back (so you know the limit)
- why can database not grow, lack of disk or not configered to grow
- when deleting know that your transactionlog will grow that can hit limits too (and if disk is the problem .... ) and it could help if you know if your db is in full or simple recovery mode.
0
 
LVL 21

Assisted Solution

by:eeRoot
eeRoot earned 250 total points
Comment Utility
The Solarwinds Syslog server can be set to discard unneeded or informational messages.  If you view the syslog entries, are there a large number of any unneeded messages?  Often, the port up/ port down messages need to be deleted to prevent the syslog db from getting too big.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now