Solved

SolarWinds dbo.SysLog is too big

Posted on 2014-10-22
3
817 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40398991
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
ID: 40400239
"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 22

Assisted Solution

by:eeRoot
eeRoot earned 250 total points
ID: 40403393
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Is your computer hacked? learn how to detect and delete malware in your PC
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

734 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