Privilege

Get-DbaPrivilege

Klaas Vandenberghe (@PowerDBAKlaas)

Get-DbaPrivilege View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Retrieves Windows security privileges critical for SQL Server performance from target computers. Description Audits five Windows privileges that directly impact SQL Server performance and functionality: Lock Pages in Memory, Instant File Initialization, Logon as Batch, Generate Security Audits, and Logon as a Service. These privileges are essential for SQL Server service accounts to achieve optimal performance and proper operation.

Set-DbaPrivilege

Klaas Vandenberghe (@PowerDbaKlaas)

Set-DbaPrivilege View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Grants essential Windows privileges to SQL Server service accounts for optimal performance and security. Description Configures critical Windows privileges for SQL Server service accounts including Lock Pages in Memory (LPIM), Instant File Initialization (IFI), Logon as Batch, Logon as Service, and Generate Security Audits. These privileges are essential for SQL Server performance optimization and proper service operation, eliminating the need to manually configure them through Local Security Policy.