Sql Server error log growing out of control

Question

Post reply

Sql Server error log growing out of control

sanjaydut26

SSCommitted

Points: 1968
More actions
September 8, 2016 at 7:16 am

#400696

Hello Everyone,
I have come across an issue where my sql server error log is growing out of control(It is around 200gb).
I tried sp_cycle_errorlog still no use and my error log size is limited to 50.
Please find the error log screenshot for reference here - https://drive.google.com/open?id=0BwQesWwtB8meN0VQeVlQUU9iN2c
How do i clear server error logs and free my disk space?

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 1

I can't see your image; can you tell us what the error message says?

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

I think your first priority should be dealing with what's causing the error messages, not the growing of the error log.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Gazareth One Orange Chip Points: 27737 More actions · Answer 3

Sure it's not the transaction log that's 200GB?

sp_cycle_log doesn't delete the old file until it goes over the max number of log files (default is 6) so the 200GB file may still be there even though the log has cycled.

sanjaydut26 SSCommitted Points: 1968 More actions · Answer 4

Yes, it's not the transaction log.

pls see the screenshot - https://drive.google.com/file/d/0BwQesWwtB8meN0VQeVlQUU9iN2c/view?usp=sharing

sjimmo SSChampion Points: 11139 More actions · Answer 5

You need to identify why you are receiving the stack dumps.

What version of SQL Server is this?

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

Gazareth One Orange Chip Points: 27737 More actions · Answer 6

Is this any help? It's for SQL 2012.

https://social.msdn.microsoft.com/Forums/en-US/098fb5b0-d3ad-4008-b7c5-8d810b89f4f7/sql-server-2012-frequent-system-health-monitor-thread-operating-system-error-exception-0x1?forum=sqldatabaseengine

Error log entries on the screenshot:

System Health Monitor Thread: Operating system error Exception 0x1 encountered.

Error: 17053. Severity 16, State:1

External dump process return code 0x20000001. External dump process returned no errors.

Stack signature for dump is 0xC04907ED

CImageHelper:Int() Failed load of symbol files with path = C:\Program Files(x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER (screengrab cuts off)

Using 'dbghelp.dll' version '4.0.5'

...

Loads of stack dump entries

...

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 7

sanjaydut26 (9/8/2016)

Yes, it's not the transaction log.

pls see the screenshot - https://drive.google.com/file/d/0BwQesWwtB8meN0VQeVlQUU9iN2c/view?usp=sharing%5B/quote%5D

Please stop linking to Google drive and just post the error message. A lot of work places block sites like that.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Call Microsoft Customer Support and open a case. Stack dumps are hard to debug, CSS has tools that we don't. Make sure you're on the latest SP & CU first.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

sjimmo SSChampion Points: 11139 More actions · Answer 9

Is this any help? It's for SQL 2012.

https://social.msdn.microsoft.com/Forums/en-US/098fb5b0-d3ad-4008-b7c5-8d810b89f4f7/sql-server-2012-frequent-system-health-monitor-thread-operating-system-error-exception-0x1?forum=sqldatabaseengine

Error log entries on the screenshot:

System Health Monitor Thread: Operating system error Exception 0x1 encountered.

Error: 17053. Severity 16, State:1

External dump process return code 0x20000001. External dump process returned no errors.

Stack signature for dump is 0xC04907ED

CImageHelper:Int() Failed load of symbol files with path = C:\Program Files(x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER (screengrab cuts off)

Using 'dbghelp.dll' version '4.0.5'

...

Loads of stack dump entries

...

As Gail said above, contact Microsoft. They will provide you with an application to run which will collect a lot of information. They will also ask for copies of the stack dumps.

Otherwise you will need to learn how to translate a lot of Hex code and try to follow all of the different things going on with this server.

Good luck.

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

sanjaydut26 SSCommitted Points: 1968 More actions · Answer 10

I Thank Everyone for the support. I will write to MS regarding the issue.

Gazareth One Orange Chip Points: 27737 More actions · Answer 11

GilaMonster (9/9/2016)
Make sure you're on the latest SP & CU first.

Definitely do this first though.