<?xml version="1.0" encoding="utf-8" ?>
<hermeticus name="Memory" level="Server" folder="Server"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Corpus.xsd">
<header>
<description lang="fr" tooltip="Mémoire utilisée" label="Mémoire utilisée" />
</header>
<queries>
<query versionMajor="*">
<![CDATA[
DECLARE @serverVersion INT;
SET @serverVersion = CAST (LEFT(CAST(SERVERPROPERTY('productversion') AS NVARCHAR(128)),CHARINDEX('.', CAST(SERVERPROPERTY('productversion') AS NVARCHAR(128)),1)-1) AS INT)
IF @serverVersion >= 11
EXEC sp_executesql N'SELECT
cpu_count AS [Logical CPU Count]
, scheduler_count, hyperthread_ratio AS [Hyperthread Ratio]
, cpu_count/hyperthread_ratio AS [Physical CPU Count]
, physical_memory_kb/1024 AS [Physical Memory (MB)]
, committed_kb/1024 AS [Committed Memory (MB)]
, committed_target_kb/1024 AS [Committed Target Memory (MB)]
, max_workers_count AS [Max Workers Count]
, affinity_type_desc AS [Affinity Type]
, sqlserver_start_time AS [SQL Server Start Time]
, virtual_machine_type_desc AS [Virtual Machine Type]
FROM sys.dm_os_sys_info WITH (NOLOCK)
OPTION (RECOMPILE)'
ELSE
EXEC sp_executesql N'SELECT
cpu_count AS [Logical CPU Count]
, scheduler_count, hyperthread_ratio AS [Hyperthread Ratio]
, cpu_count/hyperthread_ratio AS [Physical CPU Count]
, physical_memory_in_bytes/1024/1024 AS [Physical Memory (MB)]
, bpool_committed/128 AS [Committed Memory (MB)]
, bpool_commit_target/128 AS [Committed Target Memory (MB)]
, max_workers_count AS [Max Workers Count]
, affinity_type_desc AS [Affinity Type]
, sqlserver_start_time AS [SQL Server Start Time]
, virtual_machine_type_desc AS [Virtual Machine Type]
FROM sys.dm_os_sys_info WITH (NOLOCK)
OPTION (RECOMPILE)'
]]>
</query>
</queries>
</hermeticus>