SQL Server Alert System: ‘Severity 20 – Fatal Error In Current Process’DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. The logon attempt failed [CLIENT: 192.168.1.xxx] With SQL Server alerting turned to for some of …
Is there any safe way to ‘update statistics’ without causing major slow downs? As far as a safe way to update statistics. It is best to rebuild statistics in the off hours time as it will have some impact on the system. You can do a couple of things to help: If you need help with your statistics maintenance, or …
Database mail is a critical part of getting notifications from your SQL Server when things go wrong. The problem comes when you have a database mail SMTP account where every 3 months the password expires and needs to be reset. Given you have many SQL Servers that are all using that same SMTP account to send email you may have …
Part of good server monitoring it to have alerts enabled for a number of different errors to know when things go bad. The problem is we were getting the following error every time the server was restarted. SQL Server Alert System: ‘ERROR 824’ occurred on \\MyServerNameDESCRIPTION: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xe660dd36; actual: 0xcd481907). …
Recently while working on a SQL Server for a client I came across the following error when I attempted to view the SQL Server logs in SSMS. From there I decided I needed to track this down, so I attempted to run the sp_readerrorlog stored procedure, which also failed, but it provided more informaiton. The full error message was: Msg …
Finding Serializable QueriesDecember 3, 2019 Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I needed to find queries that were being run against a SQL Server that … Latest 100 PostsRead More » November 2019 Release of Database Health MonitorNovember 30, 2019 Thanks to the successful funding campaign on …
Serializable, and some of the other isolation levels can have performance implications. Recently I came across a case where I needed to find queries that were being run against a SQL Server that were in Serializable mode. The way that it works is the first section runs and creates the temp table, then the second part loops for 500 tries …
Thanks to the successful funding campaign on Indiegogo I was able to fund the November 2019 release of Database Health Monitor. Here are the release notes. Version 2.9.4 Release Notes Version 2.9.4 is the November release of Database Health Monitor. New Reports New Features Bug Fixes Here is a look at the start of the new security report: And here …
November 2019 Release of Database Health Monitor Read more »
Can you help fund the next release of Database Health Monitor? I have started an Indiegogo funding campaign for the November release of Database Health monitor. Not asking for a lot here, just $500 to help fund the next release of Database Health Monitor. What We Need & What You Get I am looking to raise $500 (us dollars) to …
Funding the November release of Database Health Monitor Read more »
Should I upgrade from SQL Server 2008 and SQL Server 2008 R2 now that it is at end of life? On July 9, 2019 SQL Server 2008 and 2008 R2 reached their end of life for support. Technically what this means is that 2008 and 2008 R2 have reached the “Extended Support End Date”. This means that Microsoft will no …