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

Getting a sum for date ranges of 7 days when there are missing dates (14h)

Why Does My SQL Server Agent Job Fail on Schedule but Succeed Manually? (13d)

How to group by invg_id instead of null lines (13d)

Trigger is not allowing the database to populate when enabled (28d)

Trigger is causing database to not populate (28d)

Consecutive count of holidays if first date of a month is holiday (29d)

Issues With Not Having Permissions To Add New Database (32d)

I need help with checking the sql query (40d)

- Advertisement -