SQL Server 2000 I/O Basics

By Bill Graziano on 16 January 2006 | Tags: Disk Tuning


This is a very misleading title. The article is actually very advanced and is one of the best I've seen on SQL Server I/O in a long time. It's written by Bob Dorr in the PSS group. Their introduction reads "Because new devices and storage solutions continue to appear in the marketplace, the environments in which Microsoft® SQL Server™ runs have become extremely diverse. To ensure data integrity for our customers who are running SQL Server, it is important that I/O environments provide appropriate functionality. The purpose of this paper is to explain the Input/Output (I/O) requirements for SQL Server database file operations so that vendors and customers can evaluate and adjust their environments to meet the needs of SQL Server."

Link: SQL Server 2000 I/O Basics


Related Articles

Which is Faster: SAN or Directly-Attached Storage? (21 January 2008)

Benchmarking Disk I/O Performance: Size Matters! (30 October 2007)

Use SQLIOSIM to simulate SQL Server disk activity (8 March 2007)

Top Six FAQs on Windows 2000 Disk Performance (24 March 2003)

Other Recent Forum Posts

Using the CASE Clause with a date range for just Month and DAy (4h)

SQL problem to be solved (7d)

Align column in SQL Query output (7d)

I have a sql query which returns a sum of total amount by user and I am trying to add another column which uses the total and multiply it by a number (8d)

Troubleshooting Deadlocks in SQL Server (18d)

Last Login date and time (19d)

Negative effects of High VLF counts (19d)

Need to return a value that indicates that a record has been added, but not when a record is modified (20d)

- Advertisement -