23 votes
Accepted

Is "deadlock detected" really an error? Should I be suppressing them after handling them?

A deadlock is a kind of serialization error: you didn't do anything forbidden, it just so happened that there was an interaction with other active transactions that prevented your transaction from ...
Laurenz Albe's user avatar
  • 51.8k
10 votes
Accepted

Unknown,AppDomain 66 (master.sys[runtime].65) is Marked for Unload Due to Memory Pressure

Memory architecture was changed in SQL Server 2012 such that there was little need to worry about the MemToLeave setting anymore, especially if using 64-bit SQL Server. And, starting with SQL Server ...
Solomon Rutzky's user avatar
10 votes
Accepted

How to remove SQL Server Error Logs

Thats about 25% of the server space. First and foremost, you really need to increase the size of your drive or move the error logs to a different drive. ~40GB for a C:\ drive might've been an okay ...
LowlyDBA - John M's user avatar
8 votes

Find out date and or number of error logs xp_readerrorlog

If you run EXEC sys.sp_enumerrorlogs; it will return one row for each log file, the oldest date in the log file, and the log file size. Which means you can do something like this: CREATE TABLE #...
Erik Darling's user avatar
  • 40.8k
7 votes

Unknown,AppDomain 66 (master.sys[runtime].65) is Marked for Unload Due to Memory Pressure

Might look into this: https://learn.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide. Especially the query on what's currently allocated. It will give you somewhere ...
Adam K.'s user avatar
  • 379
7 votes
Accepted

When should I inspect the Error Log?

I've had a varied career, but I have never found relevant information in the SQL Server Error Log. I'm happy you've had an easy time with SQL Server :) Under what circumstances should I consider ...
Sean Gallardy's user avatar
7 votes
Accepted

How can I prevent SQL Server from logging the starting and stopping of XE sessions to the server log files?

Readers Note: This was done with public symbols from the Microsoft Symbols Server. The errorlog start and stop items are being generated in the XEventController::AlterEventSession and XEventController:...
Sean Gallardy's user avatar
6 votes
Accepted

Getting the error log location in an efficient way

SELECT SERVERPROPERTY('ErrorLogFileName') Actually it is an (undocumented) serverproperty, which appears to work on SQL2005+ Joe Sack has a post on it
Mark's user avatar
  • 879
6 votes
Accepted

SQL Server, how to log client PID of failed login attempts?

Default Server Trace Try to get more info from the default server trace, as Eitan Blumin's article Finding the Details Missing from the SQL Server Failed Logins Audit shows using this query: SELECT ...
Ronaldo's user avatar
  • 5,079
5 votes
Accepted

HKHostFreezeCkptTrimming on SQL Server 2017

I don't have an answer for what exactly they mean, but I see them on every machine where I have a memory optimized file group. Since they start with "HK" they seem to be related to In-Memory OLTP (...
Josh Darnell's user avatar
  • 29.3k
5 votes
Accepted

SQL Server created a new errorlog file but instance and agent were not restarted

I would assume it's more likely that the procedure sp_cycle_errorlog was called. There's a possibility someone accidentally right clicked on Error Log and then clicked Recycle instead of Configure ...
Shaulinator's user avatar
  • 3,142
5 votes

SQL Server 2014 Avaliability Group DbMgrPartnerCommitPolicy

For future readers : DbMgrPartnerCommitPolicy::SetSyncState:00000003BFC0B0E0:1 The last integer describes the AG state 0 - Not Joined to AG 1 - Not Synchronized 2 - Suspended 4 - Synchronized 8 - Redo ...
5 votes

When should I inspect the Error Log?

Well darn. It looks like I should be checking that thing more often. Usually, it's just flooded with info telling me that my log backups are working great. If you’d like a free tool that narrows the ...
Erik Darling's user avatar
  • 40.8k
4 votes

View permission to SQL Server logs on SSMS GUI

Be careful following this solution. The throw-away 1-liner at the bottom needs to be heeded. When you grant someone membership to the 'securityadmin' fixed server role, they will gain enormous power ...
Mark's user avatar
  • 161
4 votes

How to suppress specific warnings in mysql error log when ignoring a table to replicate

Maybe a bit late, but since mysql v 8.0.13 there is a new parameter: log_error_suppression_list: https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_log_error_suppression_list ...
Leo Bosnjak's user avatar
4 votes

How to set email alerts for high IO errors (sql server error log)?

The error number is 833, so it is just a matter of setting up an Agent Event Alert based on that error number. The number isn't written to eventlog by default, however, so you need to configure that ...
Tibor Karaszi's user avatar
3 votes

Log report 'bad password', but still grants access

Alright, I have a resolution maybe, and an explanation for the log entries. Following the advise of @John-Eisbrener & @Danielle-Paquette-Harvey (did I do the attribution right?) In particular John'...
Beekeeper's user avatar
3 votes

SQL Error Log, how big is too big?

SQL Error Log, how do I determine the most appropriate error log size? Whatever is above the "normal" for each individual environment. Some environments require the logging of successful and ...
Sean Gallardy's user avatar
3 votes

SSPI handshake failed with error code 0x8009030c, state 14

WORKAROUND/SOLUTION Loopback check can be removed by adding a registry entry as follows: Edit the registry using regedit. (Start –> Run > Regedit ) Navigate to: HKLM\System\CurrentControlSet\Control\...
IBT's user avatar
  • 41
3 votes

After upgrade to 2016, can't view SQL Server Logs

Windows patching and majid's solution is what worked for us too. Just adding my 2c that may help others. We have a cluster with 2008, 2014 SP2 and 2016 CU2. After upgrading an instance to 2016, we had ...
D. Hughes's user avatar
3 votes

Can't recycle the ERRORLOG - error 17049

From System Error Codes (1300-1699): OS error 1392 indicates file corruption. ERROR_FILE_CORRUPT 1392 (0x570) The file or directory is corrupted and unreadable. So it looks like you have ...
Tom V's user avatar
  • 15.7k
3 votes
Accepted

is there a way to find out who was spid228 at a given time in the past?

You can easily extract that information from the default trace: DECLARE @path nvarchar(4000); SELECT @path= path FROM sys.traces WHERE id = 1; SELECT TextData, HostName, ApplicationName, LoginName, ...
spaghettidba's user avatar
  • 11.3k
3 votes

When should I inspect the Error Log?

Here's three more cases, in addition to Sean's list: When the instance won't start properly (as vonPryz noted). In similar vein, when a database won't come back online. When a user is encountering ...
J.D.'s user avatar
  • 37.5k
2 votes

Getting the error log location in an efficient way

Does anyone have any suggestions how I could work out the log file location in an efficient way, even when my log files are large. Assuming you are running SQLServer 2008R2 SP1 and up, you can use ...
Kin Shah's user avatar
  • 62.2k
2 votes

After upgrade to 2016, can't view SQL Server Logs

We also have some 2016 instances besides 2008 all in a cluster environment. I tried every possible solution on the net without success. I found out SQL Server tries to connect to an instance via ODBC ...
majid malek's user avatar
2 votes
Accepted

length of the result exceeds the > length limit (2GB) of the target large type

While I can tell you that in my case, I found the job causing the error by it's frequency, (the error was happening every five minutes) and there were only 2 jobs running every 5 minutes. However, ...
HWisnik's user avatar
  • 36
2 votes
Accepted

SQL Server Error Log - Is It / Can It Be Encrypted?

Is it possible for the SQL Server Error Logs to be encrypted? There is no option that "turns on errorlog encryption", so you'll need to use encryption at a lower layer, such as bitlocker or similar ...
Sean Gallardy's user avatar
2 votes

Login failed errors while DB refresh in progress

One option might be to change the login for this user to have a different default database: ALTER LOGIN [xxxx] WITH DEFAULT_DATABASE = [tempdb]; This way at least the connections will succeed and ...
Josh Darnell's user avatar
  • 29.3k
2 votes
Accepted

Postgres 10 shutting down on installation in Ubuntu 14

listening on IPv4 address "127.0.0.1", port 5432, listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432", database system is ready to accept connections Just your server ...
Evan Carroll's user avatar
  • 63.2k
2 votes
Accepted

SQL Server Audit Clutters Error log

This isn't clutter. You need to figure out why the audit is failing, and resolve it.
Randolph West's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible