MS SQL Express has database size limit of 10 Gb, so how to know when to switch to another edition of MS SQL?
To check current database size of AD Connect you can use following commands:
"C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SqlLocalDB.exe" info .\ADSync Name: ADSync Shared name: ADSync Owner: NT SERVICE\ADSync Instance pipe name: np:\\.\pipe\LOCALDB#SHD66A55\tsql\query "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\SQLCMD.EXE" -S "np:\\.\pipe\LOCALDB#SHD66A55\tsql\query" -Q "sp_helpdb ADSync;" > ADSync.txt
You can also connect to ADSync database with Invoke-Sqlcmd cmdlet from SQLPS PowerShell module:
Invoke-Sqlcmd -ServerInstance "(localdb)\.\AdSync" -Query 'sp_helpdb ADSync'