I have a User Database that consists of an MDF & LDF file and is 200 GB in total size.
It is on a SQL Instance with 100 other user DB's
The DB's are stored on a NAS system and the SQL Instance just had a 2nd logical 2 TB Storage space added to the Instance.
Is it worthwhile to add one or more NDF files to the new storage to help with the Database performance?