I currently have a medium-sized (4GB) SQL Server 2005 database running on a 3-year old Windows 2003 Server. [Xeon 2.8-2core, 2GB, 2x 73GB SCSI 10k - RAID 1]. This DB back ends an ASP.NET OLTP application running on the same server. The application also supports reporting from the same database (no data warehouse, just some denormalization where critical).
CPU utilization on the current server is not worth mentioning, memory utilization is "time to consider an upgrade" high. Disk performance/utilization is... I'm not sure... but application and query performance remains sufficiently snappy.
We plan to upgrade the hardware within the next year to account for some anticipated growth. I would like to move to a Windows 2008 R2 with Hyper-V for more flexibility, etc...
Question: Does an iSCSI SAN provide sufficient performance for running SQL 2008 in a VM? I'm not finding good guidance on the google. I know the configuration is supported (while NAS is not), but it seems like the consensus is 'maybe, but Fiber/HBA or DAS is better'.
What are the metrics I should evaluate on my current system to help guide this decision? Are there any thresholds I should look for that would indicate iSCSI won't cut it?
Any guidance or information very much appreciated!
UPDATE: Also, some additional googling turned up this article that has some useful information and links: