We use SQL and VLD just one year now. We are very happy
with it. The performance is very high.
We use a separate volume for our logs. So we have 1 volume
for the data with several QTREE's (one for every database) and 1 volume for the
logs.
This is because there is a difference between write/read
behaviour (logs = write; data = read). The performance is much better when you
split logs and data.
Of course, more disks in your raidgroup gives more
performance (5 spindles of 72 GB disks for data). For the logs, we use just 2
spindles, but that is no problem.
We use that volumes only for VLD. We have some other
volumes on the same filer for other applications (file server,
...).
When you want more details, please contact
me.
Reinoud
Hi, just wondering if anyone has had
experience with either Windows 2003 and/or SQL 2000 on NetApp running with VLD.
I am new to NetApp and being soon to install one, was wondering about different
volume sizes and performance with SQL databases. Any input would be
appreciated.
Thanks,
Steve