Get-DbaClientProtocol View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server client network protocol configuration and status from local or remote computers.
Description Retrieves the configuration and status of SQL Server client network protocols (Named Pipes, TCP/IP, Shared Memory, VIA) from local or remote computers. This function helps DBAs audit and troubleshoot client connectivity issues by showing which protocols are enabled, their order of precedence, and associated DLL files.
Get-DbaComputerSystem View Source Shawn Melton (@wsmelton), wsmelton.github.io Windows, Linux, macOS Synopsis Retrieves comprehensive hardware and system information from Windows computers hosting SQL Server instances.
Description Collects detailed system specifications including processor details, memory configuration, domain membership, and hardware information from target computers. This function is essential for SQL Server capacity planning, pre-installation system verification, and troubleshooting performance issues by providing complete hardware inventory data.
The function queries WMI classes (Win32_ComputerSystem and Win32_Processor) to gather CPU details, determines hyperthreading status, checks total physical memory, and identifies domain roles.
Chrissy LeMaire (@cl), netnerds.net | Jakob Bindslet
Get-DbaDiskSpace View Source Chrissy LeMaire (@cl), netnerds.net , Jakob Bindslet Windows, Linux, macOS Synopsis Retrieves disk space and filesystem details from SQL Server host systems for capacity monitoring and performance analysis.
Description Queries Windows disk volumes on SQL Server systems using WMI to gather critical storage information for database administration. Returns comprehensive disk details including capacity, free space, filesystem type, and optional fragmentation analysis.
Essential for SQL Server capacity planning, this function helps DBAs monitor disk space before growth limits impact database operations.
Get-DbaInstanceProtocol View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS Synopsis Retrieves SQL Server network protocol configuration and status from target computers.
Description Retrieves the configuration and status of SQL Server network protocols (TCP/IP, Named Pipes, Shared Memory, VIA) by querying the WMI ComputerManagement namespace. This is essential for troubleshooting connectivity issues, auditing network configurations for security compliance, and managing protocol settings across multiple SQL Server instances.
The returned protocol objects include Enable() and Disable() methods, allowing you to manage protocol states directly without opening SQL Server Configuration Manager.
Get-DbaLocaleSetting View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Retrieves Windows locale settings from the registry on SQL Server computers for regional configuration analysis.
Description Retrieves Windows locale settings from the Control Panel\International registry key on one or more computers. These settings directly impact SQL Server’s date/time formatting, currency display, number formatting, and collation behavior.
Useful for auditing regional configurations across your SQL Server environment, troubleshooting locale-related issues, or ensuring consistent settings before SQL Server installations.
Get-DbaMemoryUsage View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Collects memory usage statistics from all SQL Server services using Windows performance counters
Description Collects detailed memory usage from SQL Server Database Engine, Analysis Services (SSAS), and Integration Services (SSIS) using Windows performance counters. This helps you troubleshoot memory pressure issues and understand how memory is allocated across different SQL Server components on the same server.
Gathers counters from Memory Manager (server memory, connection memory, lock memory), Plan Cache (procedure plans, ad-hoc plans), Buffer Manager (total pages, free pages, stolen pages), and service-specific memory usage.
Get-DbaOperatingSystem View Source Shawn Melton (@wsmelton), wsmelton.github.io Windows, Linux, macOS Synopsis Retrieves comprehensive Windows operating system details from SQL Server host machines.
Description Collects detailed operating system information from local or remote Windows computers hosting SQL Server instances. Returns comprehensive system details including OS version, memory configuration, power plans, time zones, and Windows Server Failover Clustering status. This information is essential for SQL Server environment assessments, capacity planning, and troubleshooting performance issues that may be related to the underlying OS configuration.
Get-DbaPageFileSetting View Source Klaas Vandenberghe (@PowerDBAKlaas) Windows, Linux, macOS Synopsis Retrieves Windows page file configuration from SQL Server host computers for performance analysis.
Description This command uses CIM to retrieve detailed Windows page file configuration from SQL Server host computers. Page file settings directly impact SQL Server performance during memory pressure scenarios, making this essential for capacity planning and troubleshooting performance issues.
The function returns comprehensive details including current usage, peak usage, initial and maximum sizes, and whether page files are automatically managed by Windows.
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.
Get-DbaRegistryRoot View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Discovers Windows registry root paths for SQL Server instances to enable direct registry configuration access
Description Queries SQL Server WMI to locate the exact Windows registry hive path where each SQL Server instance stores its configuration settings. This eliminates the guesswork when you need to manually edit registry keys for troubleshooting startup issues, modifying trace flags, or automating configuration changes that aren’t exposed through T-SQL or SQL Server Configuration Manager.
dbatools