Powershell获取SQL实例

# 导入SQL Server模块
Import-Module -Name SqlServer

# 连接到SQL实例
$serverInstance = "localhost"
$connectionString = "Server=$serverInstance;Integrated Security=true;"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

# 获取SQL实例信息
$server = New-Object Microsoft.SqlServer.Management.Smo.Server($connection)
$instanceName = $server.InstanceName
$version = $server.VersionString
$state = $server.Status.ToString()
$databaseList = $server.Databases | Select-Object Name
$configuration = $server.Configuration | Select-Object -Property *
$performanceCounters = $server.PerformanceCounters | Select-Object -Property *

# 输出SQL实例信息
Write-Host "实例名称: $instanceName"
Write-Host "版本信息: $version"
Write-Host "运行状态: $state"
Write-Host "数据库列表:"
$databaseList | ForEach-Object { Write-Host "- $_.Name" }
Write-Host "配置信息:"
$configuration | ForEach-Object { Write-Host "- $_.Name: $_.Value" }
Write-Host "性能指标:"
$performanceCounters | ForEach-Object { Write-Host "- $_.CounterName: $_.RawValue" }

# 关闭连接
$connection.Close()