SQL Instance Configuration Error

Jul 16, 2014 at 11:40 AM
An error is generated when running the script "SQL Configure Instance.sql". The problem seems to be the column "physical_memory_in_bytes" in table "master.sys.dm_os_sys_info". The column name differ between versions of sql server and no check for this is included in the script.

SQL 2012, 2014
The column name is called physical_memory_kb

Pre 2012
The column name is called physical_memory_in_bytes

As you can see the values are also different (kb and bytes)

Jul 17, 2014 at 10:13 AM
Thanks for letting us know. Hopefully you can write a fix for this yourself for now, but a permanent fix for this will be published after it is tested.
Jul 17, 2014 at 10:15 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.