I would like to set up 2 difference instance of sql servers on different servers sharing same datafiles in a IBM Storage device (SAN). This is basically for load balancing. I would like to use one server for
OLTP and another one for reporting. Please let me know any issues with this kind of configuration and kindly guide me how can i do this. Basiclly i want to know the sharing of datafiles for 2 different instances.