Is there any practical sense in separating SQL tables, procedures, etc. modules into separate databases? Will the load on the database, server decrease?

Question

Transact SQL

Good afternoon!
Is there any practical sense in separating tables, procedures, etc. modules into separate databases? Will the load decrease?
Or does it make no sense, and is it even better to store everything in one big database?

Answer 1

The load will increase.