question

Wasabiman avatar image
Wasabiman asked

Should I add a Data File to my Database

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?

storage
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM ·

I think that depends. Adding additional data files can help with performance, however, what performance problem are you experiencing? I wouldn't add data files just because.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.