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
_____
From: Steven Keene [mailto:SKeene@creativesolutions.com]
Sent: vrijdag 1 augustus 2003 14:30
To: toasters(a)mathworks.com
Subject: Does anyone have experience with SQL 2000 on NetApp?
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