Determine if SQL Server has been patched against Meltdown/Spectre
This only checks the SQL Server patch status, not the operating system or hardware
This works for SQL Server 2008 through SQL Server 2017
You can use a Microsoft-provided PowerShell script to check your
operating system and hardware patch status as decribed in this Microsoft KB
Windows Client Guidance for IT Pros to protect against speculative execution side-channel vulnerabilities
https://support.microsoft.com/en-us/help/4073119/protect-against-speculative-execution-side-channel-vulnerabilities-in
For more info:
https://www.sqlskills.com/blogs/glenn/checking-your-sql-server-instance-for-spectremeltdown-patches/
https://www.sqlskills.com/blogs/glenn/checking-your-meltdown-and-spectre-mitigation-status-in-windows/