This question is a bit general since I am not exposed to SAN (Storage Area Network).
Are there any optimizations or configuration changes that can be performed with SAN to improve SQL Server performance?
The tuning that you'd do with a SAN would include.
If you have a chance to make it up to the SQLPASS Summit in Seatle in November I'll be giving a presentation on Storage for the DBA which is all about SAN storage.
Take a look at Brent Ozar's tutorial on SAN tuning using SQLIO:
I used this technique to identify a bottleneck on an older remote SAN where we manage an OLTP system (the bottleneck was only having one Host Bus Adapter card).
Check out the following best practices white paper:
Touched on in the white paper - remember to set the correct offsets on your volumes if you're not using Windows 2008:
Separate your databases' log and data files and tempdb as mrdenny has explained, and use an appropriate RAID level.
Not SAN specific, but useful - when creating your databases' transaction logs pre-grow them to avoid Virtual Log File fragmentation:
This a generalzied question however the best optimzation you can do with a SAN in my opinion is the original deployment of the LUNS and RAID configurations.
For example, if you have a 24bay SAN, determining the size, raid configuration and amount of disks used per LUN. from there you can evenly distribute the disk i/o for the SQL server by optimizing what goes where.
dedicated lun for the read databases, the heavy write or mixed databases, tempdb, etc...
let me know if this helps point in the right direction, if you have anymore questions feel free to ask, have a great day.