max asynch io - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

max asynch io

Author

Topic

Kali
Starting Member

14 Posts

Posted - 2004-11-01 : 09:17:19

Hi, has anyone ever realized a benifit from setting max asynch io different than a default? In SAN environment?

Thanks

surefooted
Posting Yak Master

188 Posts

Posted - 2004-11-01 : 11:02:17

Yes, you can tune it, check out:

http://www.databasejournal.com/features/mssql/article.php/1460081
http://www.databasejournal.com/features/mssql/article.php/1438921
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/msdn_sql7perftune.asp

-Jon
Should still be a "Starting Member"

Kali
Starting Member

14 Posts

Posted - 2004-11-01 : 15:20:44

thanks surefooted,

I read all that, but still it's mostly talking about sql 6.5 qnd 7. From BOL:

Microsoft® SQL Server™ 2000 contains improved algorithms for controlling computer resources. Many of the options that must be configured manually in earlier versions of SQL Server are managed dynamically in SQL Server 2000. These configuration options are not applicable in SQL Server 7.0 and are marked N/A in this table.

max async IO for sql 2000 for Minimum and Maximum thresholds show as not available N/A

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources