Skip to content

Latest commit

 

History

History
38 lines (29 loc) · 1.25 KB

1.VerifyDeployment.md

File metadata and controls

38 lines (29 loc) · 1.25 KB
Raw

Verify Deployment

1 = Personal or Desktop Engine 2 = Standard 3 = Enterprise 4 = Express 5 = SQL Database 6 = SQL Data Warehouse 8 = SQL Managed Instance

https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs

--Gets back db name, dtu limits, cpu limits, memory limits, size limits, log limits etc
SELECT * FROM sys.dm_user_db_resource_governance -- Only available in Azure SQL DB and MI

/* verify installed physical memory, memory usage, memory model, service startup time */
SELECT	
	CEILING(physical_memory_kb / 1024.0 / 1024.0) AS physical_memory_GB,
	CEILING(committed_kb / 1024.0) AS committed_memory_MB,
	CEILING(committed_target_kb / 1024.0) AS committed_target_memory_MB,
	CEILING(visible_target_kb / 1024.0) AS visible_target_memory_MB,
	sql_memory_model_desc,
	sqlserver_start_time
FROM sys.dm_os_sys_info;

/* verify databases, COMPATIBILITY LEVELS, recovery models, if snapshot isolation modes are enabled */

SELECT [name],database_id,[state_desc],[compatibility_level],recovery_model_desc,snapshot_isolation_state_desc,is_read_committed_snapshot_on
FROM sys.databases;

SELECT io_stall_write_ms/num_of_writes as avg_tlog_io_write_ms, * 
FROM sys.dm_io_virtual_file_stats
(db_id('Adventureworks'), 2);
GO