SQL Server sharing drive location 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.
&quot;could this potentially affect SQL Server's read/write performance?&quot;

yes.  Here are some things to consider:
1 - The type of file(s) matters in context of performance.  Files which are often read/written to will of course share the resources with the SQL Server files. Files which aren't being accessed when SQL Server files are being accessed won't noticeably affect performance.
2 - The type of storage matters.  Shared IO has more severe performance consequence on spinning disk storage than SSD.
The idea is similar to the &quot;Placing both data AND log files on the same device can cause contention for that device, resulting in poor performance. Placing the files on separate drives allows the I/O activity to occur at the same time for both the data and log files.&quot; as stated in Microsoft docs.  Read placing any two files with simultaneous IO demand on the same device can cause contention for that device, resulting in poor performance.
Will it cause poor performance? Far too many variables to take into consideration such as storage specs &amp; config, workload patterns of both SQL Server and w/e is sharing its resources, etc. to have concrete answer.