Forum Discussion

Copper Contributor

Oct 16, 2019

Database configured with 14 extra database files with unique filegroup names

We have a vendor's database that is configured 14 extra unique filegroups. One of them is taking over most of the drives disk space. Usually I have just seen an LDF and an MDF. The first one that was...

MVP

Oct 25, 2019

Good day peter_s

your question is a bit vague...

First of all, you speak about DBSpace which mean that you are probably in the wrong place. The name dbspace is usually related to IBM Informix or sybase and not to SQL Server. This forum is for SQL Server topics.

Please clarify how your question related to Microsoft and to SQL Server.

Secondly, you ask us what someone else (vendor) would do but naturally we cannot read his mind and we cannot tell you what you or he should choose or do without fully familiar your specific system, your needs, your requirements and so on. All we can do in the scope of the forum is discuss some golden rules and answer questions which are focus to the information we have.

In conclusion, if you are speaking about DBSpace which is not related to SQL Server, then I recommend you to search for DBSpace forums

Sorry I could not help more

peter_s
Copper Contributor
Oct 25, 2019
Sorry you are correct!!!!!!!!!!!!!!!!!!!!!!!!! I reworded the question, my apologies!!!!!!
- Ronen_Ariely
  MVP
  Oct 26, 2019
  Hi peter_s
  
  Thanks,
  It is OK 🙂
  
  Regarding the original post: please don't edit in the future messages which already got an answer. By changing the content after someone already responded to it, you make his response irrelevant, which might seen like a spam for someone that did not followed the entire thread and does not familiar with the history.
  
  >> Are these created for performance gains if they are distributed to separate disk drives? Is that the main reason?
  
  It might be related to performance, to administrative reason, to privileges for different users and more...
  
  How can we know why someone else did what he did in your system?!? To answer this we need the ability to read his mind. You should ask the person who did the action
  
  >> Also why is the first one taking up most of the space?
  
  Again, how can we know without examine your database?!?
  
  Did you know that even two tables with the exact same columns, same index, and same content can be in different size? I recommend you to check this post and this post, which give one example of such case.
  
  Have a great day 🙂