1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
| --Конфигурация Сервера
set nocount on
go
declare @CPU table (F00 int, F01 sql_variant, CPU int, F03 varchar(5))
insert @CPU exec xp_msver 'ProcessorCount'
declare @RAM table (ID int, F01 sql_variant, RAM decimal(10,2), F03 varchar(64))
insert @RAM exec xp_msver 'PhysicalMemory'
declare @version varchar(4)
select @version=CONVERT(varchar(4), serverproperty ('PRODUCTVERSION'))
select @version=
case
when @version like '8%' then '2000'
when @version like '9%' then '2005'
when @version like '10.0%' then '2008'
when @version like '10.5%' then '2008 R2'
when @version like '11%' then '2012'
when @version like '12%' then '2014'
when @version like '13%' then '2016'
when @version like '14%' then '2017'
when @version like '15%' then '2019'
end
declare @server varchar(50) select @server=convert(varchar(50),serverproperty('servername'))
declare @edit varchar(50) select @edit =SUBSTRING(convert(varchar(255),serverproperty('EDITION')),0,CHARINDEX('Edition',convert(varchar(255),serverproperty('EDITION'))))
declare @level varchar(10) select @level =convert(varchar(10),serverproperty('ProductLevel'))
declare @build varchar(50) select @build =convert(varchar(50),serverproperty('ProductVersion'))
declare @port varchar(10) select @port =convert(varchar(10),local_tcp_port) from sys.dm_exec_connections where session_id=@@SPID
declare @cores varchar(10) select @cores =CPU from @CPU
declare @minmem varchar(50) select @minmem=convert(varchar(50),value) from sys.configurations where name like '%min server memory%'
declare @maxmem varchar(50) select @maxmem=convert(varchar(50),value) from sys.configurations where name like '%max server memory%'
declare @RAMmem varchar(20) select @RAMmem=convert(varchar(4),ROUND(convert(DECIMAL(10,2), RAM/1024.0),1)) from @RAM
print ' Server: '+@server
+char(13)+' Version: '+@version
+char(13)+' Edition: '+@edit
+char(13)+' Level: '+@level
+char(13)+' Build: '+@build
+char(13)+' Port: '+@port
+char(13)+'min_memory: '+@minmem
+char(13)+'max_memory: '+@maxmem
+char(13)+'RAM_memory: '+@RAMmem+' GB'
+char(13)+'CPU_cores : '+@cores
go |