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 from 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:
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.
-: FREE PDF e-Book Download :-
51 JSOM Examples in SharePoint Online