[Hyper-V] 安裝 Windows 11 Pro 虛擬機器（使用本機帳戶 Local Account 登入）
更新日期：2025/07/30
ISO 檔版本：
前言
Build Information
|
Note
|
| SQL Server Version |
SQL Server 2019
|
| Product Version |
15.0.2070.41
|
| Product Level |
RTM
|
| Product Edition |
Enterprise Edition (64-bit)
|
| Database Internal Version |
904
|
-- V2_SQL Server system and build information
-- Applies to: SQL Server 2019
SELECT @@SERVERNAME 'InstanceName',
CASE WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '8%' THEN 'SQL Server 2000'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '9%' THEN 'SQL Server 2005'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.0%' THEN 'SQL Server 2008'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '10.5%' THEN 'SQL Server 2008 R2'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '11%' THEN 'SQL Server 2012'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '12%' THEN 'SQL Server 2014'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '13%' THEN 'SQL Server 2016'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '14%' THEN 'SQL Server 2017'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('ProductVersion')) like '15%' THEN 'SQL Server 2019'
ELSE 'unknown'
END AS 'SQLServerVersion ',
CASE WHEN SERVERPROPERTY('IsClustered') = 1 AND SERVERPROPERTY('IsHadrEnabled') = 1 THEN 'Failover Cluster + Availability Groups'
WHEN SERVERPROPERTY('IsClustered') = 1 THEN 'Failover Cluster'
WHEN SERVERPROPERTY('IsHadrEnabled') =1 THEN 'Availability Groups'
ELSE 'unknown'
END AS 'High-Availability',
host_distribution 'HostDistribution', host_release 'HostRelease',
SERVERPROPERTY('ProductVersion') 'ProductVersion',
SERVERPROPERTY('ProductLevel') 'ProductLevel',
SERVERPROPERTY('Edition') 'ProductEdition',
SERVERPROPERTY('ProductUpdateLevel') 'ProductUpdateLevel',
SERVERPROPERTY('ProductBuildType') 'ProductBuildType',
SERVERPROPERTY('ProductUpdateReference') 'ProductUpdateReference',
DATABASEPROPERTYEX('master','Version') 'DatabaseInternalVersion'
FROM sys.dm_os_host_info
GO
-- DBCC TRACEON(8666) -- Find out Statistics used to Execution Plan from Plan Cache.
DBCC TRACEON(8666)
SELECT TOP 100 st.text [TSQL], DB_NAME(st.dbid) [DB],
qs.last_elapsed_time/1000000.0 [LastElapsedTime(sec)],
qs.last_worker_time/1000000.0 [LastCPUTime(sec)],
qs.last_logical_reads LastLogicalReads,
qs.last_physical_reads LastPhysicalRead,
qs.last_logical_writes LastlogicalWrites,
qs.last_rows LastRows,
cp.usecounts [ExecutionCount], cp.size_in_bytes/1024.0 [PlanSize(KB)],
cp.cacheobjtype [CacheObject], cp.objtype [ObjType], qs.plan_generation_num [PlanRecompile],
qp.query_plan.query('declare namespace ns="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
(/ns:ShowPlanXML/ns:BatchSequence/ns:Batch/ns:Statements/ns:StmtSimple/ns:QueryPlan/ns:ParameterList/ns:ColumnReference[@Column])') [ParameterList],
qp.query_plan.query('declare namespace ns="http://schemas.microsoft.com/sqlserver/2004/07/showplan";
(/ns:ShowPlanXML/ns:BatchSequence/ns:Batch/ns:Statements/ns:StmtSimple/ns:QueryPlan/ns:InternalInfo/ns:EnvColl/ns:Recompile)') [Statistics],
qp.query_plan [QueryPlan], cp.plan_handle, qs.last_execution_time, qs.creation_time
FROM sys.dm_exec_cached_plans cp INNER JOIN sys.dm_exec_query_stats qs
ON cp.plan_handle = qs.plan_handle
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st
CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp
WHERE st.dbid = DB_ID('Northwind')
-- CHARINDEX ('Products', st.text) >0
-- st.text LIKE '%xxx%'
ORDER BY qs.last_execution_time DESC;
DBCC TRACEOFF(8666)
GO
