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

Registering servers on ssms for all nodes on vmware (23h)

SSRS row grouping question (1d)

How to sort by using ORDER using a field as the sort category in other table within the same database file? (1d)

Register servers - always on (2d)

How to make join to teams display without join all teams? (2d)

Perform calculation to sum values grouped by another column value (3d)

How to convert rows to columnsin sql server (3d)

How to separate value exist on temp table dynamically separated by comma? (4d)

- Advertisement -