Category: I/O

Glenn Berry talks about the blazing speeds of the latest Intel Optane gear from Intel, and how they can improve your SQL Server workloads.
Monica Rathburn (@SQLEspresso) talks about a few of the more common elements she always checks for when troubleshooting I/O problems.
Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
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 | Disk Performance, I/O 0
Kevin Kline answers several questions from his recent webinar on I/O latency with Tegile's Sumeet Bansal.
Kevin Kline shares the slide deck and video from his recent webinar on reducing latency and boosting performance in SQL Server.
Glenn Berry discusses a new feature in Windows Server 2016, Storage Spaces Direct, and how SQL Server will benefit.
1 2

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More

Get a Free 2-Week Trial

Start your free trial of any of our products today.

Free Trial

2-Week Trial