sqlsever查询服务器资源
时间: 2023-08-04 15:30:12 浏览: 46
可以使用以下 SQL 查询语句查询 SQL Server 服务器资源:
1. 查询 CPU 使用情况:
```
SELECT cpu_count AS [Number of Logical CPUs], scheduler_count AS [Number of Schedulers],
CAST(cpu_count/scheduler_count AS DECIMAL(10,2)) AS [AvgTaskPerCpu],
idle_scheduler_count AS [Number of Idle Schedulers],
active_worker_count AS [Number of Active Workers],
active_scheduler_count AS [Number of Active Schedulers]
FROM sys.dm_os_schedulers WITH (NOLOCK)
WHERE scheduler_id < 255 OPTION (RECOMPILE);
```
2. 查询内存使用情况:
```
SELECT (physical_memory_in_use_kb/1024) AS [SQL Server Memory Usage (MB)],
(locked_page_allocations_kb/1024) AS [SQL Server Locked Pages Usage (MB)]
FROM sys.dm_os_process_memory WITH (NOLOCK) OPTION (RECOMPILE);
```
3. 查询磁盘使用情况:
```
EXEC xp_fixeddrives;
```
注意:这些查询语句使用了系统表和视图,可能会对 SQL Server 的性能产生一定的影响。建议在非生产环境中测试和使用。