SQL Server SAN timeout settings

Giganews Newsgroups
Subject: SQL Server SAN timeout settings
Posted by:  Jim Clark
Date: Fri, 2 Oct 2009

I am running SQL Server 2005 x64 on Windows 2003 active/passive cluster. We
are currently having latency issues with our SAN, this is causing the SQL
Server instance to restart when the latency is high. We are addressing the
SAN latency issues with the SAN vendor but in the short-term I would like to
know;
1) What are the time-out settings for SQL Server for SAN storage?
2) Can these settings be modified and if so what other impacts may this have?

Replies