Perfmon counter comparison: DatabasesTransactions/sec vs SQL StatisticsBatch Requests/sec

Perfmon counter comparison: DatabasesTransactions/sec vs SQL StatisticsBatch Requests/sec

one great use for perfmon counters is to sample how much work is my sequel server doing it can just be confusing which counter to use there's a counter called database transactions per sec and there's a counter called batch request per sec now of these two counters i much prefer the batch requests per

Nested Transactions in T-SQL

Nested Transactions in T-SQL

we sort of opened up this chapter with our discussion of transactions towards the end of that second video in the chapter I unintentionally gave you a peek into what we would call nested transactions it was just a mistake real easy to do and I want to talk to you about the fallacy of

SQL Server tutorial 78: How to perform a transaction log backup.

SQL Server tutorial 78: How to perform a transaction log backup.

"How Transaction Logs Work Lesson 7.1"

"How Transaction Logs Work Lesson 7.1"

one of the fundamental aspects of a database is the transaction log now the transaction log is something you need to first of all understand what it's doing then second of all understand how as an administrator you use the transaction log to protect your database so first off let's look at a couple of