SQL Server SEE license / Purchase Model.

SQL Server SEE license / Purchase Model.

Here is the query to find the Detail.

SELECT create_date AS 'SQL Server Installed Date',
Expiry_date AS 'SQL Server Expiry Date',
DATEDIFF(dd,create_date, GETDATE()) 'No_of_Deys_Used',
ABS(DATEDIFF(dd,expiry_date,GETDATE())) 'No_Of_Daiys_Left'
FROM
(SELECT sp.create_date, DATEADD(dd, 180, sp.create_date) AS Expiry_date
FROM sys.server_principals sp
WHERE sp.name = 'NT AUTHORITY\SYSTEM') as exp_date_tb

&

Select @@VERSION

Additionally,

The Memory Utilization can be observed from DBCC MEMUSAGE.

There are other techniques to find the utilisation Database Wise.

SELECT DB_NAME(database_id),
COUNT (1) * 8 / 1024 AS MBUsed
FROM sys.dm_os_buffer_descriptors
GROUP BY database_id
ORDER BY COUNT (*) * 8 / 1024 DESC
GO