What is new in SQL Server 2012 - Denali - SQL Server 2012 Denali- Column name changes in sys.dm_os_sys_info DMV.

Getting Started with Adobe After Effects - Part 6: Motion Blur


	What is New

Upload Image

Close it

Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators


	Like

Invite Friends

Top Categories · View All

TSQL Enhancements	28
Discontinued Features	16
SSIS Enhancements	10
SSMS Enhancements	10
Database Engine	10
Database Administration	8
Security	3
Full Text Search	2
DataTime	1
Breaking Changes	1

Browse by Tags · View All

Denali	82
SQL Server 2012	79
SSIS	9
SSMS Enhancements	9
Analytic Functions	8
Usability Enhancements	5
SQL11	4
TSQL	4
Security	3
Database Engine	3
Datetime	3
Query Hints	2
OVER Clause	2
DMV	2
Groups	2
Dynamic Management Functions	2
DMF	2
System stored procedures	2
DBA	2
FTS	2

Browse by Release · View All

All	58
RC0	20
SQL Server 2012 Denali	2
CTP3	2
SQL Server Denali	1

What is new in SQL Server 2012 - Denali

Features · Categories · Submit a feature · Most Liked · Most Discussed · Info · News · Fans (73) · Preferences

SQL Server 2012 Denali- Column name changes in sys.dm_os_sys_info DMV.

Feb 2 2012 11:04AM by Fazal Vahora

Some column name have been renamed are follows:

    Previous Column Name    		New Column Name
--------------------------------------------------------------------------- 
    physical_memory_in_bytes    	physical_memory_kb	
    bpool_commit_target 			committed_target_kb	
    bpool_visible   				visible_target_kb	
    virtual_memory_in_bytes 		virtual_memory_kb	
    bpool_commited  				committed_kb

Read More

Reference 1 [30 clicks]
Reference 2 [32134 clicks]
Reference 3 [32134 clicks]

Have you written a blog post or article related to this feature and want to get them added here? Read More...

Category :	Database Engine
Release :	SQL Server 2012 Denali
Tags :	sys.dm_os_sys_info,DMV

Previous: SQL Server 2012 - OVER Clause is enhanced with ROWS/RANGE Clause to limit the rows
Next:

Fazal Vahora

21 · 9% · 2806

Liked


Post this to my facebook wall
Tweet this
Like This
I know a usecase where I can use this feature rightaway
I may use this sometime in the future
Interesting feature, but not my area of expertise
I dont think this feature adds any "real" value


	Submit

Your Comment

Sign Up or Login to post a comment.

"SQL Server 2012 Denali- Column name changes in sys.dm_os_sys_info DMV." rated 5 out of 5 by 4 readers

Moderators

What is new in SQL Server 2012 - Denali

SQL Server 2012 Denali- Column name changes in sys.dm_os_sys_info DMV.

Your Comment