Skip to content

Commit 367f050

Browse files
authored
Update max_server_memory.sql
Removed errant reference to DMV.
1 parent 7f69ce4 commit 367f050

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

‎max_server_memory.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -45,7 +45,7 @@ DECLARE @numaNodesAfinned TINYINT;
4545
DECLARE @maxWorkerThreadCount INT;
4646
DECLARE @threadStack DECIMAL(20, 4);
4747

48-
SELECT @cpuArchitecture = CASE WHEN @@VERSION LIKE '%<X64>%' THEN 2 WHEN @@VERSION LIKE '%<IA64>%' THEN 4 ELSE 0.5 END FROM sys.dm_os_windows_info WITH (NOLOCK);
48+
SELECT @cpuArchitecture = CASE WHEN @@VERSION LIKE '%<X64>%' THEN 2 WHEN @@VERSION LIKE '%<IA64>%' THEN 4 ELSE 0.5 END;
4949
SELECT @numaNodes = COUNT(DISTINCT parent_node_id) FROM sys.dm_os_schedulers WHERE scheduler_id < 255 AND parent_node_id < 64;
5050
SELECT @numaNodesAfinned = COUNT (DISTINCT parent_node_id) FROM sys.dm_os_schedulers WHERE scheduler_id < 255 AND parent_node_id < 64 AND is_online = 1;
5151
SELECT @maxWorkerThreadCount = max_workers_count FROM sys.dm_os_sys_info;

0 commit comments

Comments
 (0)