Large binary writes slower than expected

[Code4u]

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?

TIA

[Andrew J. Kelly]

Re: Large binary writes slower than expected

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


"Code4u" <code4u@gmail.c om> wrote in message
news:ff9k115jpr eda0btpobe69bhl 1siarv2tb@4ax.c om...[color=blue]
> 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?
>
> TIA[/color]