SQL Server Storage Engine under the hood: How SQL Server performs I/O

On September 6th, Thomas Grohser will present on “SQL Server Storage Engine under the hood: How SQL Server performs I/O” to the SQL Server Ireland User Group.

How does SQL Server really access the data and log files on the disk? What’s done asynchronous and what’s  synchronous and what impact does that have on our queries and DML statements? How do you specify IO requirement and what are they to begin with?

What I/O characteristics do different access methods, workloads and maintenance task have?

What impact do features  like database mirroring and replication have? What changes have occurred to the SQL Server
startup?

Which I/O Subsystems (including SSD) are best for which type of data and what’s the impact if you choose a different one?  Which
files can be placed on the same volume and which should not?

The Target Audience is for both DBA & Storage Engineers

Thomas H. Grohser is a SQL Server MVP (SQL Server Performance Engineering). In the last 17 of his more than 24 years as an IT
Professional, he spent the majority of the time exploring the deeper inner workings of SQL Server and its features while working for entertainment , pharmaceutical and other industry leading companies. The main focus of his work is to architect, plan and provide a reliable, highly available, secure  and scalable  infrastructure for and with the features of SQL Server. This covers
all angles from hardware, network, storage systems, Operating systems, SQL Server configuration and the Data Access Layer of applications.

Currently he works at one of the largest SQL Server installations in the world processing hundreds of millions  of transactions
daily while moving peta bytes of data  in a 24×7 environment.

He now shares all the findings and the gathered know how with the SQL Server community and started speaking regularly at international conferences in North America and Europe and at local events and work closely with SQLCAT  to make sure everyone interested can access the information.

This event will be held on the Ground Floor, Microsoft Atrium Building Block B, Carmenhall Road, Sandyford Industrial Estate, Dublin 18 (close to the Sandyford Luas stop). Limited underground parking is available at the back of the building.

Registration is free to all at http://www.mtug.ie/Home/tabid/38/ctl/Details/Mid/369/ItemID/91/Default.aspx?ContainerSrc=[G]Containers/_default/No+Container

Name:  SQL Server Storage Engine under the hood: How SQL Server performs I/O

Date:  September 6th , 18:30

Location: Auditorium, Microsoft Atrium

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: