Here we will discuss how we can easily know which content database one site collection is using in SharePoint 2016 or SharePoint 2013. We can see how we can know this by out of box way and also we can see how we can know using PowerShell.
Out of box approach:
We can get to know from the central administration. Open SharePoint 2016 central administration. Then click on Application Management.
Then under Site Collections, click on View all site collections.
In this page you can see the particular site collection and then in the right side you can see the content database name like below:
Also read: How to get content database size using PowerShell in SharePoint 2016 and using SharePoint server object model
Using PowerShell also we can be able to know which content database one site collection is using.
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
Hope this will be helpful.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.