I am an application user in Health Care. The application relies on communication with a large database, including image data and other large numeric arrays. We add approximately 15GB per day to the database server (note image data might be file based). The application crashes, sometimes coincident in time with querying the database e.g. when you query the patient list in opening a new case.
There are two instances of the application database, used by two groups, that currently share a physical disk in the database server. I wonder what factors I'd need to understand in order to estimate whether or not there might be appreciable performance gain by giving each instance of the database a dedicated physical disk.