Team Blog

Glenn Berry : Using Intel Optane Storage for SQL Server

Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.

January 14, 2019 | SQLPerformance.com | SQL Server, hardware, disk performance, I/O 0

Monica Rathbun : I/O Troubleshooting

Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.

April 18, 2017 | SQLPerformance.com | disk performance, indexes, I/O 0

Is a RID Lookup faster than a Key Lookup?

For T-SQL Tuesday #78, Aaron Bert

May 10, 2016 | SQLPerformance.com | T-SQL, T-SQL Tuesday, lookups, rid lookups, disk performance, Key Lookups 0

Glenn Berry : Database Hardware and Infrastructure Trends

Glenn Berry provides the SQL Server DBA some insight into the ever-changing world of hardware and infrastructure.

April 26, 2016 | SQLPerformance.com | SQL Server, CPU Performance, hardware, disk performance 0

Instant File Initialization : Impact During Setup

SQL Server 2016 allows you to enable instant file initialization during installation; Aaron Bertrand looks at how this can impact tempdb data file creation.

March 11, 2016 | SQLPerformance.com | tempdb, instant file initialization, setup, Windows, disk performance 0

Erin Stellato : Sparse Columns : Impact on Time & Space

Erin Stellato looks into sparse columns in SQL Server - the changes to space requirements and the impact on the write portion of your workload.

February 5, 2016 | SQLPerformance.com | I/O subsystem, sparse columns, database design, disk performance 0

Glenn Berry : Using Microsoft DiskSpd to Test Your Storage Subsystem

Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.

August 4, 2015 | SQLPerformance.com | System Configuration, I/O Latency, I/O Performance, disk performance 0

Glenn Berry : Analyzing I/O Performance for SQL Server

Glenn Berry talks about measuring I/O performance for SQL Server, focusing on latency, IOPS, and sequential throughput.

May 27, 2015 | SQLPerformance.com | System Configuration, I/O Performance, disk performance 0