sys.dm_os_sys_info – Peek behind the curtain at the hardware, scheduling, memory, and even virtualization hypervisor.
sys.dm_db_persisted_sku_features – SQL Server Standard Edition doesn’t allow databases to be restored if they contain certain Enterprise Edition features like compression and mirroring. You can’t restore the database then disable those features, no no – that would be too easy. The restore appears that it works, right up until the very last moment – when it fails. This means you need to know when your developers use advanced features in Developer Edition that won’t work in production on Standard Edition. Same problem if your production server uses Enterprise Edition, but your disaster recovery server uses Standard Edition – whoops, the databases won’t go live.
sys.dm_io_backup_tapes – list of the physical & logical devices.
Here’s some of our favorite queries that take advantage of these DMVs:
- Glenn Berry’s Diagnostic DMV Queries – Glenn makes good use of the sys_info DMVs and explains their contents.
