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@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