Sorry if this is kind of more than question at a time, but here goes.
Running SQL Server 2008 on windows server 2008 as well. We have a large database just over 200gb right now (it holds images of documents that are scanned in, the 3rd party app is using an image column. it also has some other data that is accessed, including licensing info for the program)
The data files for it are still on the c drive because someone decided to set it up that way. It's been growing bit by bit and the drive is getting dangerously low on space. I have an iScsi drive I want to move it to before anything bad happens (there are log files on this drive right now, but it has a ton of free space and I don't really have any other options right now), but I need to be sure of a few things first.
I want to find a good way to measure the i/o rates on the files as it currently stands, but even after searching I'm not sure of the best way to do this over the course of a day or two to have a good idea.
I also want to test the throughput of the new drive I plan on using to make sure it is suitable. I was thinking of using SQLIO for this, but haven't looked into it much yet.
Lastly, just in case there is some serious performance issues, I was thinking it might be a good idea to have some kind of replication setup, probably asynchronous to avoid performance issues, so that we can quickly revert back to the original files without having to lose any data or wait for the new file to copy back over again.