An XEvent a Day (17 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 1)

Posted by Jonathan Kehayias on SQL Blog See other posts from SQL Blog or by Jonathan Kehayias
Published on Fri, 17 Dec 2010 22:00:00 GMT Indexed on 2010/12/18 17:17 UTC
Read the original article Hit count: 782

Filed under:

Extended Events

|

SQL Server 2008

|

SQL Server 2008 R2

|

SQL Server Denali

|

XEvent A Day

Today’s post is a continuation of yesterday’s post How Many Checkpoints are Issued During a Full Backup? and the investigation of Database Engine Internals with Extended Events. In today’s post we’ll look at how Backup’s work inside of SQL Server and how to track the throughput of Backup and Restore operations. This post is not going to cover Backups in SQL Server as a topic; if that is what you are looking for see Paul Randal’s TechNet Article Understanding SQL Server Backups . Yesterday...(read more)

© SQL Blog or respective owner

Related posts about Extended Events

ASA hairpining: I basicaly want to allow 2 spokes to be able to communicate with each other.

as seen on Server Fault - Search for 'Server Fault'
ASA Spoke to Spoke Communication I have been looking at spke to spoke comms or "hairpining" for months and have posted on numerouse forums but to no avail. I have a Hub and spoke network where the HUB is an ASA Firewall version 8.2 * I basicaly want to allow 2 spokes to be able to communicate with… >>> More
Complex SQL query help on aggregating values for nested subquery

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi! I have people, companies, employees, events and event kinds. I'm making a report/followup sheet where people, companies and employees are the rows, and the columns are event kinds. Event kinds are simple values describing: "Promised Donation", "Received Donation", "Phoned", "Followed up" and… >>> More
UIComponent extended class isn't showing UIComponent extended class

as seen on Stack Overflow - Search for 'Stack Overflow'
I have 1 class (that is extending a UIcomponent) that is representing a component. In that component I create different instances of another class that is also a UIComponent but this class doesn't show up in de first class. I see that it is running and that it has the correct hights but I got the… >>> More
"power limit notification" clobbering on 12G Dell servers with RHEL6

as seen on Server Fault - Search for 'Server Fault'
Server: Poweredge r620 OS: RHEL 6.4 Kernel: 2.6.32-358.18.1.el6.x86_64 I'm experiencing application alarms in my production environment. Critical CPU hungry processes are being starved of resources and causing a processing backlog. The problem is happening on all the 12th Generation Dell servers… >>> More
jquery fullcalendar - viewDisplay to pass selected month to events (reload events per month)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How can I pass the selected month from viewDisplay to the events function (which is a php call to the DB to load the events)? Only events for one month should get loaded at a time, but I'm afraid of what might happen if the user decides to click 'next' multiple times really quickly... My other… >>> More

Related posts about SQL Server 2008

SQL Server 2008 Vs Sql Server 2008 R2 in web-development

as seen on Stack Overflow - Search for 'Stack Overflow'
This will give many opportunities in Web-development transition from Sql Server 2008 to Sql Server 2008 R2: 1.If database in one instance of SQL Server. 2.a) if in the server PC have 1 processor b) if in the server PC have 4 processors >>> More
Creating an ASP.NET Database using MS SQL 2008 in Visual Web Developer 2008

as seen on ASP Free - Search for 'ASP Free'
This article illustrates how to create a database in ASP.NET. We ll be using Microsoft SQL Server 2 8 and developing it in Visual Web Developer Express 2 8. Given the importance of databases to most websites nowadays you should find this information useful when building just about any website… >>> More
Introducing SQL Server 2008 and 2008 R2 Integration Services

as seen on Internet.com - Search for 'Internet.com'
The latest release of SSIS strengthens its position as one of the primary foundations of Business Intelligence, delivering a powerful framework for solutions that combine data from disparate sources, facilitating its analysis and reporting. Join Marcin Policht as he reviews its general characteristics… >>> More
Installing and configuring SQL Server 2008 and 2008 R2 Integration Services

as seen on Internet.com - Search for 'Internet.com'
Marcin Policht shows you how to install and configure SQL Server 2008 and 2008 R2 Integration Services. >>> More
Windows Server 2008 / SQL 2008 Licensing for Authenticated Web Application

as seen on Server Fault - Search for 'Server Fault'
Hello, I'm trying to crunch some numbers to see what the software costs involved are for hosting an application we are developing. Users will not be anonymous - they will need to log in. SQL Server 2008: SQL Server licensing is easy - it will be licensed per-processor. No real fuss there. The… >>> More