sql server (alternate): Large binary writes slower than expected -- sql server (alternate)

Large binary writes slower than expected

Code4u
2/21/2005 10:26:04 AM

sql server (alternate): Hello, we are investigating the use of SQL Server as a backend to our
scientific imaging application. We have found that when we write a
large image (60 Megabytes) the performance is quite a bit slower than
writing 60 single megabyte images. The tests were performed running
SQL Server 2000 on Windows 2003 Enterprise on a single machine to
eliminate the network's contribution. Perhaps there is a configuration
option that will allow us to tune SQL Server to better handle large
writes?

Re: Large binary writes slower than expected

Andrew J. Kelly
2/21/2005 1:33:16 PM

Make sure you have the log file on its own Raid1 disk array. Make sure your
cache on the disk controller is also set for 100% write back cache if it is
battery backed.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]