I have a database called
example.mdf with a total size of 1GB which suffers from performance issues. I checked the allocated hardware and it is higher than required, I double checked the design and every thing looks normal, when I look at the
.mdf files in their physical location (
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\example.mdf) I found that the database is split into multiple files
example_3.mdf, up to
I have another database file on the same SQL Server that has the same issue.
Why does this happen? Does this affect the performance? How can I prevent or stop SQL Server from splitting my
.mdf files? Moreover I need to combine back the already split files.