We have a site collection, hr (Human Resources), with it's own content database:
Site collection URL: https://sharepoint/hr Database name: SP2013_PROD_HR
The database has grown to 150GB and we want to create a new content database before we exceed the 200GB recommended limit. However, we still would like the URL for the new content DB and site collection to use the same base site collection url. Not sure if that is possible or recomended. I can already see the problem of two sites, one in each site collection, potentially having the same name/url.
What have others of you done in this situation? I am thinking we'll have no choice but to have separate urls and try to make them as close as possible, like: