Client written application using SQL Server was designed to be on local servers at each facility. Instead of individual local facility servers, each of the sixteen facilities has its own database on the corporate SQL Server cluster. All of the .mdf, .ndf, and .ldf files are on a SAN.
The first question is if there would be an appreciable performance improvement if database files were placed on separate disks. Disk Layout Best Practices Published By Microsoft Team recommends data files and transaction log files of a database be placed on separate disks. Some more recent source has indicated ?SANs are well suited for these uses with SQL Server 2000? but do not specifically address the separate disks issue. This matter requires further investigation.
The second concern is the performance difference between using the current sixteen databases verses a single corporate wide version. Either way SQL would reside on the same hardware and support the same user volume. The issue is whether SQL Server would have an appreciable performance improvement in having a single application database verses having sixteen