PowerShell
-
Verify Allocation Unit Size for SQL Server
Why Do I Care? Everything in SQL Server is stored on disk in 8K pages. The Microsoft recommended best practice is to format using a 64K allocation unit size. Processes such as the checkpoint and Lazy Writer try to write in extents when possible. Extents are a collection of 8 pages and since each page…
-
Sync SQL Logins and Jobs
In this post I’ll point you to some options to sync SQL logins and then I’ll demo my favorite option in a video. If you are using Availability Groups or Mirroring you know you need to sync SQL logins and jobs among replicas. What are your options to sync SQL Logins and maybe even jobs? …
-
syspolicy_purge_history Job Fails
The syspolicy_purge_history SQLAgent job is used by Policy Based Management in SQL server to clear out the policy evaluation history kept by PBM. The job consists of the following three steps. First to check to see if PBM is enabled and exit if it is not. Run the msdb.dbo.sp_syspolicy_purge_history system stored procedure to clear the history Use…