SQL Socket & Core information
Get socket, physical core, and logical core count from the SQL Server Error log It can help you confirm your SQL Server licensing model
Server Informantion
List of all global trace flags that are enabled
Find all global trace flags that are enabled TF 3226 – Suppresses logging of successful database backup messages to the SQL Server Error Log TF 6534 – Enables use of native code to improve performance with spatial data TF 7745 – Prevents Query Store data from being written to disk in case of a failover …
SQL Configuration Values
Microsoft Help
SQL Information
SQL Server 2019 Builds — Build Description Release Date URL to KB Article— 15.0.1000.34 CTP 2.0 9/24/2018— 15.0.1100.94 CTP 2.1 11/7/2018— 15.0.1200.24 CTP 2.2 12/6/2018— 15.0.1300.359 CTP 2.3 3/1/2019— 15.0.1400.75 CTP 2.4 3/26/2019— 15.0.1500.28 CTP 2.5 4/23/2019— 15.0.1600.8 CTP 3.0 5/22/2019— 15.0.1700.37 CTP 3.1 6/26/2019— 15.0.1800.32 CTP 3.2 7/24/2019— 15.0.1900.25 RC1/RC1 Refresh 8/29/2019— 15.0.2000.5 RTM …
Check Memory pressure on the server
Possible System Memory State values:* Available physical memory is high* Physical memory usage is steady* Available physical memory is low* Available physical memory is running low* Physical memory state is transitioning sys.dm_os_sys_memory
Get a count of SQL connections by IP address
dm_exec_connections dm_exec_sessions
Find Server property using TSQL code
Let us check this query which use internal objects and get more information about installed SQL server using TSQL Below query show result in single row This query show result in two column
Find SQL Server collation
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type. Case sensitivity If A and a, B and b, etc. are treated in the same …
Server OS information
To find information where SQL server is installed using TSQL.
