| QueryId | TotalExecutions | avg_duration_ms | max_duration_ms | avg_cpu_ms | avg_logical_reads | avg_memory_mb | PlanCount | has_forced_plan | QueryText |
|---|
| 399 | 9 | 5,32 | 10,32 | 3,71 | 78,00 | 0,00 | 1 | 0 | insert #SVer exec master.dbo.xp_msver |
| 402 | 9 | 0,29 | 0,47 | 0,29 | 3,00 | 0,00 | 1 | 0 | (@SmoAuditLevel int,@NumErrorLogs int,@SmoLoginMode int,@SmoMailProfile nvarchar(512),@BackupDirectory nvarchar(512),@SmoPerfMonMode int,@InstallSqlDataDir nvarchar(512),@ErrorLogPath nvarchar(512),@SmoRoot nvarchar(512),@ServiceStartMode int,@LogPath nvarchar(512),@MasterPath nvarchar(512),@ServiceAccount nvarchar(512),@NamedPipesEnabled int,@TcpEnabled int,@InstallSharedDirectory nvarchar(512),@SqlGroup nvarchar(512),@FilestreamLevel int,@FilestreamShareName nvarchar(512),@cluster_name nvarchar(128),@quorum_type tinyint,@quorum_state tinyint)SELECT
@SmoAuditLevel AS [AuditLevel],
ISNULL(@NumErrorLogs, -1) AS [NumberOfLogFiles],
(case when @SmoLoginMode < 3 then @SmoLoginMode else 9 end) AS [LoginMode],
ISNULL(@SmoMailProfile,N'') AS [MailProfile],
@BackupDirectory AS [BackupDirectory],
@SmoPerfMonMode AS [PerfMonMode],
ISNULL(@InstallSqlDataDir,N'') AS [InstallDataDirectory],
CAST(@@SERVICENAME AS sysname) AS [ServiceName],
@ErrorLogPath AS [ErrorLogPath],
@SmoRoot AS [RootDirectory],
CAST(case when 'a' <> 'A' then 1 else 0 end AS bit) AS [IsCaseSensitive],
@@MAX_PRECISION AS [MaxPrecision],
CAST(FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') AS bit) AS [IsFullTextInstalled],
SERVERPROPERTY(N'ProductVersion') AS [VersionString],
CAST(SERVERPROPERTY(N'Edition') AS sysname) AS [Edition],
CAST(SERVERPROPERTY(N'ProductLevel') AS sysname) AS [ProductLevel],
CAST(ISNULL(SERVERPROPERTY(N'ProductUpdateLevel'), N'') AS sysname) AS [ProductUpdateLevel],
CAST(SERVERPROPERTY('IsSingleUser') AS bit) AS [IsSingleUser],
CAST(SERVERPROPERTY('EngineEdition') AS int) AS [EngineEdition],
convert(sysname, serverproperty(N'collation')) AS [Collation],
CAST(ISNULL(SERVERPROPERTY('IsClustered'), 0) AS bit) AS [IsClustered],
CAST(ISNULL(SERVERPROPERTY(N'MachineName'), N'') AS sysname) AS [NetName],
ISNULL(SERVERPROPERTY(N'ComputerNamePhysicalNetBIOS'),N'') AS [ComputerNamePhysicalNetBIOS],
ISNULL(@ServiceStartMode,2) AS [ServiceStartMode],
@LogPath AS [MasterDBLogPath],
@MasterPath AS [M |
| 397 | 14 | 0,15 | 0,32 | 0,15 | 4,00 | 0,00 | 1 | 0 | SELECT
(SELECT SUM(CAST(df.size as float)) FROM sys.database_files AS df WHERE df.type in ( 0, 2, 4 ) ) AS [DbSize],
(SELECT SUM(CAST(df.size as float)) FROM sys.database_files AS df WHERE df.type in (1, 3)) AS [LogSize] |
| 400 | 9 | 0,10 | 0,21 | 0,10 | 14,33 | 0,00 | 1 | 0 | insert #SVer select t.*
from sys.dm_os_host_info
CROSS APPLY (
VALUES
(1001, 'host_platform', 0, host_platform),
(1002, 'host_distribution', 0, host_distribution),
(1003, 'host_release', 0, host_release),
(1004, 'host_service_pack_level', 0, host_service_pack_level),
(1005, 'host_sku', host_sku, ''),
(1006, 'HardwareGeneration', '', ''),
(1007, 'ServiceTier', '', ''),
(1008, 'ReservedStorageSizeMB', '0', '0'),
(1009, 'UsedStorageSizeMB', '0', '0')
) t(id, [name], internal_value, [value]) |
| 398 | 9 | 0,10 | 0,14 | 0,10 | 0,00 | 0,00 | 1 | 0 | select case when authenticating_database_id = 1 then 0 else 1 end from
sys.dm_exec_sessions where session_id = @@SPID |
| 304 | 9 | 0,08 | 0,14 | 0,04 | 0,00 | 0,00 | 1 | 0 | (@cluster_name nvarchar(128),@quorum_type tinyint,@quorum_state tinyint)SELECT @cluster_name = cluster_name,
@quorum_type = quorum_type,
@quorum_state = quorum_state
FROM sys.dm_hadr_cluster |
| 401 | 9 | 0,06 | 0,15 | 0,06 | 3,00 | 0,00 | 1 | 0 | SELECT
( select Value from #SVer where Name =N'host_platform') AS [HostPlatform] |
| 306 | 9 | 0,05 | 0,07 | 0,05 | 0,00 | 0,00 | 1 | 0 | select host_platform from sys.dm_os_host_info |
| 302 | 9 | 0,04 | 0,06 | 0,04 | 2,00 | 0,00 | 1 | 0 | (@Slash varchar(1),@MasterPath nvarchar(512))select @MasterPath=substring(physical_name, 1, len(physical_name) - charindex(@Slash, reverse(physical_name))) from master.sys.database_files where file_id = 1 |
| 303 | 9 | 0,02 | 0,04 | 0,02 | 2,00 | 0,00 | 1 | 0 | (@Slash varchar(1),@LogPath nvarchar(512))select @LogPath=substring(physical_name, 1, len(physical_name) - charindex(@Slash, reverse(physical_name))) from master.sys.database_files where file_id = 2 |