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

Improving update statistics process for 6 big tables (4d)

Peer to Peer Replication is not working between 2 different machines (4d)

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (38d)

Subscription sends report with data to one user but empty report to other users (40d)

Pivot Tables in SQL (47d)

Can't restore backup; SSMS says my user account directory is empty (48d)

REPL55012 error (74d)

SQL 2022 SSIS does not write data in Excel (82d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site