{"id":535,"date":"2010-12-29T17:12:00","date_gmt":"2010-12-29T17:12:00","guid":{"rendered":"\/blogs\/jonathan\/post\/An-XEvent-a-Day-(29-of-31)-The-Future-Looking-at-Database-Startup-in-Denali.aspx"},"modified":"2017-04-13T12:16:31","modified_gmt":"2017-04-13T16:16:31","slug":"an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/","title":{"rendered":"An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali"},"content":{"rendered":"

As I have said previously in this series, one of my favorite aspects of Extended Events is that it allows you to look at what is going on under the covers in SQL Server, at a level that has never previously been possible.  SQL Server Denali CTP1 includes a number of new Events that expand on the information that we can learn about how SQL Server operates and in today\u2019s blog post we\u2019ll look at how we can use those Events to look at what happens when a database starts up inside of SQL Server.<\/p>\n

First lets create our Event Session, which will collect a large number of events that relate to the operations that occur when a database starts in SQL Server.   <\/p>\n

\n
DECLARE <\/span>@sqlcmd <\/span>nvarchar<\/span>(<\/span>max<\/span>) =\r\n<\/span>'IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE\r\nname=''MonitorStartupLogRecovery'')\r\n   DROP EVENT SESSION [MonitorStartupLogRecovery] ON SERVER;\r\nCREATE EVENT SESSION [MonitorStartupLogRecovery]\r\nON SERVER\r\nADD EVENT sqlserver.database_started \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.databases_log_file_used_size_changed \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.databases_log_flush \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.databases_log_flush_wait \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.file_read \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.file_read_completed \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.file_write_completed \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.file_written \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_block_cache \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_block_consume \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_blocks_uncache \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_cache_buffer_refcounter_change \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_consumer_act \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_flush_complete \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_flush_requested \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_flush_start \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.log_single_record \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.new_log_interest_flip \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.redo_single_record \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.redo_target_set \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>')),\r\nADD EVENT sqlserver.transaction_log \r\n(WHERE (database_id = ' <\/span>+ <\/span>CAST<\/span>(<\/span>DB_ID<\/span>(<\/span>'AdventureWorks2008R2'<\/span>) <\/span>AS varchar<\/span>(<\/span>3)) + <\/span>'))\r\nADD TARGET package0.asynchronous_file_target(\r\n     SET filename=''C:\\SQLBlog\\MonitorStartupLogRecovery.xel'',\r\n         metadatafile=''C:\\SQLBlog\\MonitorStartupLogRecovery.xem'')\r\nWITH (MAX_MEMORY = 8192KB, EVENT_RETENTION_MODE = ALLOW_SINGLE_EVENT_LOSS, STARTUP_STATE = ON)'\r\n<\/span>EXEC<\/span>(<\/span>@sqlcmd<\/span>)\r\n<\/span>GO\r\n<\/span><\/pre>\n<\/blockquote>\n
With the Event Session created, we can make some changes that write to our test database to see what happens when the database is recovered at startup. We are going to can make two changes to the database.  First we\u2019ll begin a transaction and create a table with 10 rows of data in it without committing the transaction.  <\/p>\n
\n
USE <\/span>AdventureWorks2008R2\r\n<\/span>GO\r\n<\/span>-- Begin a Transaction and leave it open\r\n<\/span>BEGIN TRANSACTION\r\n<\/span>-- Create the First Table\r\n<\/span>SELECT TOP <\/span>10 *\r\n<\/span>INTO <\/span>TestTable\r\n<\/span>FROM <\/span>Sales<\/span>.<\/span>SalesOrderDetail sod\r\n<\/span>GO\r\n<\/span><\/pre>\n<\/blockquote>\n
Now in a New Query Window, we\u2019ll create a second table with 10 rows of data without opening a transaction, and then force a dirty shutdown of the Database Engine.<\/p>\n
\n
USE <\/span>AdventureWorks2008R2\r\n<\/span>GO\r\n<\/span>-- Create a Second Table\r\n<\/span>SELECT TOP <\/span>10 *\r\n<\/span>INTO <\/span>TestTable2\r\n<\/span>FROM <\/span>Sales<\/span>.<\/span>SalesOrderDetail sod\r\n<\/span>GO\r\n<\/span>-- Flush changes to data file\r\n<\/span>CHECKPOINT\r\nGO\r\n<\/span>-- Force Shutdown the Engine\r\n<\/span>SHUTDOWN<\/span><\/pre>\n<\/blockquote>\n
Once SHUTDOWN is issued, the process terminates, and the Database Engine will need to be restarted from the Services Snapin, the SQL Server Configuration Manager, or through SSMS.  When the Engine starts up, the Event Session will become active, and the Events will be logged to the package0.asynchronous_file_target for analysis.  Once recovery completes, we can drop the Event Session from the Server, so that the buffers flush, and we can then begin our analysis of the collected information.<\/p>\n
\n
USE <\/span>tempdb\r\n<\/span>GO\r\n\r\n<\/span>-- Read the Raw Event data into a table\r\n<\/span>SELECT <\/span>CAST<\/span>(<\/span>event_data <\/span>AS XML<\/span>) <\/span>AS <\/span>event_data\r\n<\/span>INTO <\/span>TargetEvents\r\n<\/span>FROM <\/span>sys<\/span>.<\/span>fn_xe_file_target_read_file<\/span>(<\/span>'C:\\SQLBlog\\MonitorStartupLogRecovery*.xel'<\/span>, <\/span>'C:\\SQLBlog\\MonitorStartupLogRecovery*.xem'<\/span>, null, null)\r\n\r\n<\/span>-- Fetch the Event Data from the Raw Event Data into another table\r\n<\/span>SELECT \r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/@name)[1]'<\/span>, <\/span>'varchar(50)'<\/span>) <\/span>AS <\/span>event_name<\/span>,\r\n    <\/span>DATEADD<\/span>(<\/span>hh<\/span>, \r\n            <\/span>DATEDIFF<\/span>(<\/span>hh<\/span>, <\/span>GETUTCDATE<\/span>(), <\/span>CURRENT_TIMESTAMP<\/span>), \r\n            <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/@timestamp)[1]'<\/span>, <\/span>'datetime2'<\/span>)) <\/span>AS <\/span>[timestamp]<\/span>,\r\n    <\/span>COALESCE<\/span>(<\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="database_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>), \r\n             <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/action[@name="database_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>)) <\/span>AS <\/span>database_id<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="count"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[count]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="start_log_block_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[start_log_block_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="is_read_ahead"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[is_read_ahead]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="private_consumer_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[private_consumer_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="mode"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[mode]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="file_handle"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[file_handle]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="offset"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[offset]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="file_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[file_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="filegroup_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[filegroup_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="size"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[size]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="path"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[path]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="duration"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[duration]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="io_data"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[io_data]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="resource_type"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[resource_type]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="owner_type"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[owner_type]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="transaction_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[transaction_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="lockspace_workspace_id"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[lockspace_workspace_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="lockspace_sub_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[lockspace_sub_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="lockspace_nest_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[lockspace_nest_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="resource_0"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[resource_0]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="resource_1"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[resource_1]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="resource_2"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[resource_2]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="object_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[object_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="associated_object_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[associated_object_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="resource_description"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[resource_description]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="database_name"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[database_name]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="log_block_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[log_block_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="log_block_size"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[log_block_size]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="from_disk"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[from_disk]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="incomplete"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[incomplete]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="cache_buffer_pointer"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[cache_buffer_pointer]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="consumer_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[consumer_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="old_weight"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[old_weight]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="new_weight"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[new_weight]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="new_position"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[new_position]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="last_log_block_id"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[last_log_block_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="weight"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[weight]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="address"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[address]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="type"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[type]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="current_count"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[current_count]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="change_type"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[change_type]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="activity_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[activity_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="write_size"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[write_size]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="rows"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[rows]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="pending_writes"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[pending_writes]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="pending_bytes"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[pending_bytes]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="reason"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[reason]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="waiters"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[waiters]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="error"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[error]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="slot_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[slot_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="used_size"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[used_size]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="reservation_size"]\/value)[1]'<\/span>, <\/span>'bigint'<\/span>) <\/span>AS <\/span>[reservation_size]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="log_op_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[log_op_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="log_op_name"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[log_op_name]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="interest"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[interest]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="cache_type"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[cache_type]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="keys"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[keys]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="stop_mark"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[stop_mark]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="operation"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[operation]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="success"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[success]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="index_id"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[index_id]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="log_record_size"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[log_record_size]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="context"]\/text)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[context]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="replication_command"]\/value)[1]'<\/span>, <\/span>'int'<\/span>) <\/span>AS <\/span>[replication_command]<\/span>,\r\n    <\/span>event_data<\/span>.<\/span>value<\/span>(<\/span>'(event\/data[@name="transaction_start_time"]\/value)[1]'<\/span>, <\/span>'nvarchar(4000)'<\/span>) <\/span>AS <\/span>[transaction_start_time]\r\n<\/span>INTO <\/span>Results\r\n<\/span>FROM <\/span>TargetEvents\r\n<\/span><\/pre>\n<\/blockquote>\n
Now we can begin to analyze the information that we collected by querying the Results table.  Looking at the Results as a whole, we can see the database opened by reading the first page of the database and then the database boot page (page_id=9) and page 32 of the primary data file.  Then the engine scans each of the VLF\u2019s of the transaction log.  We can tell that the log reads are scans of the VLF\u2019s by looking at the DBCC LOGINFO information for the database and comparing the file_read offsets from the Event Session to the StartOffset of each of the VLF\u2019s in the DBCC LOGINFO output.<\/p>\n
<\/blockquote>\n
\n
DBCC <\/span>LOGINFO\r\n<\/span><\/pre>\n<\/blockquote>\n
\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
\n
SELECT <\/span>event_name<\/span>, <\/span>timestamp<\/span>, <\/span>database_id<\/span>, <\/span>file_id<\/span>, <\/span>mode<\/span>, <\/span>offset<\/span>, \r\n    <\/span>CASE WHEN <\/span>file_id <\/span>= <\/span>1 THEN <\/span>offset<\/span>\/<\/span>8192 ELSE <\/span>NULL <\/span>END AS <\/span>page_id<\/span>, <\/span>size<\/span>, \r\n    <\/span>log_block_id<\/span>, <\/span>log_block_size<\/span>, <\/span>start_log_block_id<\/span>, <\/span>last_log_block_id<\/span>, \r\n    <\/span>from_disk<\/span>, <\/span>consumer_id<\/span>, <\/span>activity_id<\/span>, <\/span>log_op_id<\/span>, <\/span>log_op_name<\/span>, <\/span>change_type<\/span>, \r\n    <\/span>operation<\/span>, <\/span>object_id<\/span>, <\/span>index_id<\/span>, <\/span>log_record_size<\/span>, <\/span>slot_id<\/span>, <\/span>used_size<\/span>, \r\n    <\/span>reservation_size<\/span>, <\/span>write_size<\/span>, <\/span>rows<\/span>, <\/span>pending_writes<\/span>, <\/span>pending_bytes<\/span>, \r\n    <\/span>context<\/span>, <\/span>waiters\r\n<\/span>FROM <\/span>Results\r\n<\/span><\/pre>\n
\"image\"<\/a>  <\/p>\n<\/blockquote>\n
After the startup scans the VLF\u2019s 120K of information is read from the log file, and the log buffers start to be consumed to determine the redo start point for recovery.  We can filter our Event data to remove Events that while interesting are not necessary for our analysis at the moment, as well as to reduce the number of columns being returned from the data set.<\/p>\n
\n
SELECT \r\n    <\/span>event_name<\/span>, <\/span>timestamp<\/span>, <\/span>file_id<\/span>, <\/span>mode<\/span>, <\/span>offset<\/span>, <\/span>size<\/span>, <\/span>log_block_id<\/span>, \r\n    <\/span>COALESCE<\/span>(<\/span>log_op_name<\/span>, <\/span>operation<\/span>) <\/span>as <\/span>[operation]<\/span>, <\/span>slot_id<\/span>, \r\n    <\/span>object_id<\/span>, <\/span>index_id<\/span>, <\/span>log_record_size<\/span>, <\/span>context<\/span>, <\/span>write_size<\/span>, <\/span>rows\r\nFROM <\/span>Results\r\n<\/span>WHERE <\/span>event_name <\/span>NOT IN (<\/span>'log_consumer_act'<\/span>, <\/span>'log_single_record'<\/span>, <\/span>'log_cache_buffer_refcounter_change'<\/span>, <\/span>'file_read'<\/span>) \r\n<\/span><\/pre>\n
\"image\"<\/a> <\/p>\n<\/blockquote>\n
With the filtered results, we can see the log reads into cache and the setting of the redo target.  If we scroll down further, we can get a better picture of what is happening.<\/p>\n
\"image\"<\/a> <\/p>\n
The last active log blog was consumed, and the redo target was set at that log_block_id.  Then the log is reread starting at offset 318976 and the blocks get cached and the redo operations begin against the database.  Scrolling through the results further, we can see that the redo operations continue as the log blocks increase up to the Checkpoint operation that was executed immediately before the Shutdown of the instance occurred, at the log block that was set as the redo target originally.<\/p>\n
\"image\"<\/a> <\/p>\n
At this point the data file begins to be read so that the undo operations can be performed before making the database available.<\/p>\n
\"image\"<\/a> <\/p>\n
After the undo completes the database_started Event is raised and that database becomes available for use.<\/p>\n
\"image\"<\/a> <\/p>\n
To validate that the changes we see occurring after the redo operations and before the database_started Event, we can set the database OFFLINE, recreate our Event Session, and then bring the database back ONLINE again, and then compare the logged Events when no changes have occurred to our original Events when known changes have occurred.  I am not going to do that in this blog post, but will instead leave that up to the reader to investigate on their own.<\/p>\n","protected":false},"excerpt":{"rendered":"
As I have said previously in this series, one of my favorite aspects of Extended Events is that it allows you to look at what is going on under the covers in SQL Server, at a level that has never previously been possible.  SQL Server Denali CTP1 includes a number of new Events that expand […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23,38,40,45],"tags":[],"class_list":["post-535","post","type-post","status-publish","format-standard","hentry","category-extended-events","category-sql-server-2008","category-sql-server-denali","category-xevent-a-day-series"],"yoast_head":"\nAn XEvent a Day (29 of 31) - The Future - Looking at Database Startup in Denali - Jonathan Kehayias<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"An XEvent a Day (29 of 31) - The Future - Looking at Database Startup in Denali - Jonathan Kehayias\" \/>\n<meta property=\"og:description\" content=\"As I have said previously in this series, one of my favorite aspects of Extended Events is that it allows you to look at what is going on under the covers in SQL Server, at a level that has never previously been possible.  SQL Server Denali CTP1 includes a number of new Events that expand […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/\" \/>\n<meta property=\"og:site_name\" content=\"Jonathan Kehayias\" \/>\n<meta property=\"article:published_time\" content=\"2010-12-29T17:12:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:16:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday29of31thefuturelookingatdata\/12165cba\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Jonathan Kehayias\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Kehayias\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/\"},\"author\":{\"name\":\"Jonathan Kehayias\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"headline\":\"An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali\",\"datePublished\":\"2010-12-29T17:12:00+00:00\",\"dateModified\":\"2017-04-13T16:16:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/\"},\"wordCount\":729,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday29of31thefuturelookingatdata\\\/12165cba\\\/image_thumb.png\",\"articleSection\":[\"Extended Events\",\"SQL Server 2008\",\"SQL Server Denali\",\"XEvent a Day Series\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/\",\"name\":\"An XEvent a Day (29 of 31) - The Future - Looking at Database Startup in Denali - Jonathan Kehayias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday29of31thefuturelookingatdata\\\/12165cba\\\/image_thumb.png\",\"datePublished\":\"2010-12-29T17:12:00+00:00\",\"dateModified\":\"2017-04-13T16:16:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday29of31thefuturelookingatdata\\\/12165cba\\\/image_thumb.png\",\"contentUrl\":\"https:\\\/\\\/www.SQLskills.com\\\/blogs\\\/jonathan\\\/wp-content\\\/uploads\\\/windows-live-writer\\\/anxeventaday29of31thefuturelookingatdata\\\/12165cba\\\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extended Events\",\"item\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/category\\\/extended-events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#website\",\"url\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/\",\"name\":\"Jonathan Kehayias - The Rambling DBA\",\"description\":\"The Rambling DBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sqlskills.com\\\/blogs\\\/jonathan\\\/#\\\/schema\\\/person\\\/01c10d94f3648654ef706d5e6305f69c\",\"name\":\"Jonathan Kehayias\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g\",\"caption\":\"Jonathan Kehayias\"},\"sameAs\":[\"http:\\\/\\\/3.209.169.194\\\/blogs\\\/jonathan\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"An XEvent a Day (29 of 31) - The Future - Looking at Database Startup in Denali - Jonathan Kehayias","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/","og_locale":"en_US","og_type":"article","og_title":"An XEvent a Day (29 of 31) - The Future - Looking at Database Startup in Denali - Jonathan Kehayias","og_description":"As I have said previously in this series, one of my favorite aspects of Extended Events is that it allows you to look at what is going on under the covers in SQL Server, at a level that has never previously been possible.  SQL Server Denali CTP1 includes a number of new Events that expand […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/","og_site_name":"Jonathan Kehayias","article_published_time":"2010-12-29T17:12:00+00:00","article_modified_time":"2017-04-13T16:16:31+00:00","og_image":[{"url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday29of31thefuturelookingatdata\/12165cba\/image_thumb.png","type":"","width":"","height":""}],"author":"Jonathan Kehayias","twitter_misc":{"Written by":"Jonathan Kehayias","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#article","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/"},"author":{"name":"Jonathan Kehayias","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"headline":"An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali","datePublished":"2010-12-29T17:12:00+00:00","dateModified":"2017-04-13T16:16:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/"},"wordCount":729,"commentCount":1,"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday29of31thefuturelookingatdata\/12165cba\/image_thumb.png","articleSection":["Extended Events","SQL Server 2008","SQL Server Denali","XEvent a Day Series"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/","name":"An XEvent a Day (29 of 31) - The Future - Looking at Database Startup in Denali - Jonathan Kehayias","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday29of31thefuturelookingatdata\/12165cba\/image_thumb.png","datePublished":"2010-12-29T17:12:00+00:00","dateModified":"2017-04-13T16:16:31+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#primaryimage","url":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday29of31thefuturelookingatdata\/12165cba\/image_thumb.png","contentUrl":"https:\/\/www.SQLskills.com\/blogs\/jonathan\/wp-content\/uploads\/windows-live-writer\/anxeventaday29of31thefuturelookingatdata\/12165cba\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/an-xevent-a-day-29-of-31-the-future-looking-at-database-startup-in-denali\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/"},{"@type":"ListItem","position":2,"name":"Extended Events","item":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/category\/extended-events\/"},{"@type":"ListItem","position":3,"name":"An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/","name":"Jonathan Kehayias - The Rambling DBA","description":"The Rambling DBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/#\/schema\/person\/01c10d94f3648654ef706d5e6305f69c","name":"Jonathan Kehayias","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/86630e27f5deecc5c393ea57fc7c3b6a068949f4fd6b5309f81de5a276f12855?s=96&d=mm&r=g","caption":"Jonathan Kehayias"},"sameAs":["http:\/\/3.209.169.194\/blogs\/jonathan"]}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/comments?post=535"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/posts\/535\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/media?parent=535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/categories?post=535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/jonathan\/wp-json\/wp\/v2\/tags?post=535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}