T-SQL Tuesday #31: Paradox of the Sawtooth Log

Posted by merrillaldrich on SQL Blog See other posts from SQL Blog or by merrillaldrich
Published on Tue, 12 Jun 2012 07:10:29 GMT Indexed on 2012/06/12 10:45 UTC
Read the original article Hit count: 546

Filed under:

log

|

transactions

|

T-SQL Tuesday

Today’s T-SQL Tuesday, hosted by Aaron Nelson ( @sqlvariant | sqlvariant.com ) has the theme Logging . I was a little pressed for time today to pull this post together, so this will be short and sweet. For a long time, I wondered why and how a database in Full Recovery Mode, which you’d expect to have an ever-growing log -- as all changes are written to the log file -- could in fact have a log usage pattern that looks like this: This graph shows the Percent Log Used (bold, red) and the Log File(s)...(read more)

© SQL Blog or respective owner

Related posts about log

Logrotate not doing any rotation

as seen on Super User - Search for 'Super User'
I just set up LogRotate on my RHEL6 server so that it rotates my custom Apache log files. However, it doesn't do anything when i try manually running it. I expect it to rotate the log files "access.log" and "err.log". They have been there for a few days and need to be rotated. Here is the output: [root@pc1… >>> More
ORA-03113 in code. In addition, TNS-12535 and ORA-03137 in alert file

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got an exception that contain ORA-03113: (SiPPSS.GetPrintWorkDirectDetail) - ERR:ORA-03113: end-of-file on communication channel Process ID: 7448 Session ID: 30 Serial number: 9802 ?????:12110937 ????:T855 Oracle.DataAccess.Client.OracleException ORA-03113: end-of-file on communication channel… >>> More
PostgreSQL 8.4 won't start after blackout

as seen on Server Fault - Search for 'Server Fault'
I have problem with starting PostgreSQL 8.4 on Ubuntu 9.10 Server after blackout. When I try to connect to the database it says: psql: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. When I try to start it by… >>> More
repeated failing passwords in linux security log (/var/log/secure)

as seen on Server Fault - Search for 'Server Fault'
Recently, I opened up the SSH port through my firewalls (and redirecting to my server) so I could check on the (http) server while on the road. The first week or two there was nothing different. But now, three or four weeks later, I see lots of this: Mar 20 08:38:28 localhost sshd[21895]: pam_unix(sshd:auth):… >>> More
How can I back up my ubuntu system?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I'm sure there's a lot of questions on here similar to this, and I've been reading them, but I still feel this warrants a new question. I want nightly, incremental backups (full disk images would waste a lot of space - unless compressed somehow.) Preferably rotating or deleting old backups when running… >>> More

Related posts about transactions

NServiceBus and NHibernate - Message Handler and Transactions

as seen on Stack Overflow - Search for 'Stack Overflow'
From my understanding NServiceBus executes the Handle method of an IMessageHandler within a transaction, if an exception propagates out of this method, then NServiceBus will ensure the message is put back on the message queue (up X amount of times before error queue) etc.. so we have an atomic operation… >>> More
Reliable test for MSDTC promoting transactions to distributed?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I reliably check that MSDTC has promoted a transaction to a distributed transaction, from .net code? Currently a co-worker is testing this by shutting down the coordinator on his machine - if an exception is thrown this is taken as evidence that an attempt to promote the transaction has occurred… >>> More
[News] Travailler avec Entity Framework et les transactions

as seen on Dot Net Guru - Search for 'Dot Net Guru'
Voici un article comme on voudrait en lire plus souvent sur l'utilisation des transactions dans le contexte des ORM Entity Framework et Linq2SQL. Il d?crit de mani?re tr?s synth?tique les transactions implicites et explicites et effleure l'approche pessimiste et optimiste. >>> More
Transactions in LINQ to SQL applications

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I would like to talk about LINQ to SQL and transactions.When I have a LINQ to SQL class I always get asked this question, "How does LINQ treat Transactions?". When we use the DeleteOnSubmit() method or the InsertOnSubmit() method, all of those commands at some point are translated into… >>> More
T-SQL Tuesday #31: Paradox of the Sawtooth Log

as seen on SQL Blog - Search for 'SQL Blog'
Today’s T-SQL Tuesday, hosted by Aaron Nelson ( @sqlvariant | sqlvariant.com ) has the theme Logging . I was a little pressed for time today to pull this post together, so this will be short and sweet. For a long time, I wondered why and how a database in Full Recovery Mode, which you’d expect to… >>> More