On Mon, Mar 27, 2006 at 09:50:31AM -0800, Ephi Dror
wrote:> Hi All,
>
> Does anyone run SQL and/or exchange on SAMBA server share?
>
> Are there any special considerations to take? would you be kind enough
> to share your experience doing it?
>
> Any special smb.conf configuration is required?
> is there any performance issue or functional limitations supporting it?
>
> I am just wondering since Microsoft encourages block level access over
> share/file level access.
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;304261
> Microsoft generally recommends that you use a Storage Area Network (SAN)
> or locally attached disk for the storage of your Microsoft SQL Server
> database files because this configuration optimizes SQL Server
> performance and reliability. By default, use of network database files
> (stored on a networked server or Network Attached Storage [NAS]) is not
> enabled for SQL Server.
>
> However, you can configure SQL Server to store a database on a networked
> server or NAS storage server. Servers used for this purpose must meet
> SQL Server requirements for data write ordering and write-through
> guarantees detailed in the "More Information" section of this
article.
> .
> http://support.microsoft.com/kb/234656/
> All versions of SQL Server open the log and data files using the Win32
> CreateFile function. The dwFlagsAndAttributes member includes the
> FILE_FLAG_WRITE_THROUGH option when opened by SQL Server.
>
> All comments are welcome and highly appreciated.
Should work. If you have problems let us know and we'll fix 'em.
Jeremy.