SQL Server 2000 I/O Basics

By Bill Graziano on 16 January 2006 | 0 Comments | 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." Follow the link to SQL Server 2000 I/O Basics...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 11,723 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email ThisSubscribe to this feedKick itSave to del.icio.usView blog reactions

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

Searchengine for database? (0 Replies)

Inner Join w/ Multiple results display in one row (0 Replies)

How To Migrate Triggers and Packages Using SSMA (1 Reply)

Logon,Unknown,Login failed for user (2 Replies)

SQL Server permissions. (6 Replies)

Why display date different from source? (6 Replies)

Default value in SQL Db (2 Replies)

Inner Join w/ Multiple Results display in one row (15 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email:

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

SQL Server Jobs