How to check what databases are accessible?
Using the following SQL statement we can check what databases as accessible
Read Windows Registry from SQL server
Recommended value for intensive I/O patterns from VMware is: RequestRingPages=32,MaxQueueDepth=254 https://kb.vmware.com/s/article/2053145 https://www.sqlskills.com/blogs/glenn/processor-selection-for-sql-server/ https://www.cpuid.com/softwares/cpu-z.html
SQL Server Services information
Microsoft help
Get Memory Clerk Usage
dm_os_memory_clerks
SQL Server NUMA Node information
Gives you some useful information about the composition and relative load on your NUMA nodes Check an equal number of schedulers on each NUMA node Check on a physical or virtual machine with more than four sockets or more than 24 physical cores Microsoft help Other Link https://www.sqlskills.com/blogs/glenn/balancing-your-available-sql-server-core-licenses-evenly-across-numa-nodes/
Get Server properties
Microsoft Help
Get Volume statistics (Storage Partition)
Returns information about the operating system volume (directory) on which the specified databases and files are stored in SQL Server. Use this dynamic management function to check the attributes of the physical disk drive or return available free space information about the directory. sys.dm_os_volume_stats (Transact-SQL)
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
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
