DBA newbie here. Did some searching online but cannot find a definite answer on this.
Is it acceptable to share the drive where .MDF files reside with other non-SQL Server files such as applications that go under a Program Files folder?
I assume it is not but maybe this depends on the type of storage that is used? We use SAN storage.
I'll rephrase....If the drive that contains .MDF files is shared with other non-SQL Server applications, could this potentially affect SQL Server's read/write performance depending on the storage that is used?
The answer isn't obvious to someone that is new to SQL Server, let alone hardware storage. If everything is located on the same SAN, does it really matter if they are on the same drive? I'm researching and can't find the answer and the only SQL Server hardware book out in the market is from 2011.
