SharePoint Pain

[Tested on SharePoint 2016 only] Suppose the following error occurs while creating a new site collection with a farm admin user account: ## Assume all declared variables are correct ## PS C:\FarmAdminUserAccount> New-SPSite -Url $spSite -Name $scName -Description $scDesc -ContentDatabase $cdb -QuotaTemplate $scQuota -Template $scTemplate -Language 1033 -OwnerAlias $scPrimaryAdmin -OwnerEmail $scPrimaryEmail -SecondaryOwnerAlias $scSecondaryAdmin -SecondaryEmail $scSecondaryEmail ********************** PS>CommandInvocation(Out-String): "Out-String" >> ParameterBinding(Out-String): name="InputObject"; value="Calling extension methods on object Microsoft.SharePoint.Administration.SPContentDatabase+<>c__DisplayClass16 failed with exception(s): The UPDATE permission was denied on the object 'MSP_TVF_WEB_ADMIN', database 'WSS_Content_DbName', schema 'pjpub'." New-SPSite : Calling extension methods on object Microsoft.Sha...

Applies to SharePoint 2016; not tested on other versions of SharePoint.   Symptoms   SharePoint Central Admin’s Health Analyzer shows "Drives used for SQL databases are running out of free space". For example:     Diagnosis The value of Autogrowth for the database files are not set optimally for the free disk space that the Health Analyzer calculates. For example: Remedy   Set the Autogrowth to the correct value . Do not use a percentage or a non-binary unit as a fixed value. Inform the DBA. For example:       Note: - The Health Analyzer Rule Definition and the Error Status pages look very similar and share the same title, "Drives used for SQL  databases are running out of free".  Make sure you're looking at the right page by checking the URLs (../Lists/HeathRules/... vs. ../Lists/HealthReports/...) and the Ribbon: -   For getting into the depth of the error and calculating the correct value, you can refer to  https:/...