SQL SERVER中获服务器硬件和系统信息SQL语句

原创

于 2024-11-13 16:26:53 发布 · 596 阅读

4 ·

CC 4.0 BY-SA版权

文章标签：

#服务器 #sql #运维

在 SQL Server 中，你可以通过查询系统视图、函数和扩展的管理视图来获取硬件和系统信息。以下是一些常见的 SQL 查询，它们可以提供有关 SQL Server 实例、操作系统和硬件的相关信息。

1. 获取 SQL Server 实例版本、操作系统版本和架构信息

SELECT 
    SERVERPROPERTY('ProductVersion') AS SQLServerVersion,
    SERVERPROPERTY('ProductLevel') AS ProductLevel,
    SERVERPROPERTY('Edition') AS Edition,
    SERVERPROPERTY('EngineEdition') AS EngineEdition,
    SERVERPROPERTY('MachineName') AS ServerName,
    SERVERPROPERTY('IsClustered') AS IsClustered,
    SERVERPROPERTY('MaxDop') AS MaxDegreeOfParallelism,
    SERVERPROPERTY('Collation') AS Collation,
    SERVERPROPERTY('Platform') AS Platform,
    SERVERPROPERTY('OSVersion') AS OSVersion;

2. 获取操作系统的详细信息

SELECT 
    sqlserver_start_time AS SQLServerStartTime,
    cpu_count AS CPUCount,
    physical_memory_in_bytes/1048576 AS PhysicalMemoryMB,
    max_workers_count AS MaxWorkerThreads,
    process_physical_memory_low AS IsMemoryLow
FROM sys.dm_os_sys_info;