TSQL Determine Table Size
Determine the size of database tables in a MSSQL Server Database. SELECT DB_NAME() AS DatabaseNase , GETDATE() AS DateCreated , TableName, Rows …
Monitor CPU usage MS SQL Server
Ensure the user has permission USE master; GRANT VIEW SERVER STATE TO username; GO Select from view sys.dm_os_sys_info select * from sys.dm_os_sys_info