Check SQL Server supports of In-Memory OLTP ( SQL Server 2014)

On 13 Apr, 2015

MS SQL DBA

By : Charith Silva

No Comments

In-Memory OLTP is a memory-optimized database engine integrated into the SQL Server engine. The SERVERPROPERTY() built in metadata system function with IsXTPSupported Property can be used to identify whether Server supports In-Memory OLTP.

USE [master];

GO

SELECT CASE SERVERPROPERTY('IsXTPSupported ')  
WHEN 0 THEN 'Server does not supports In-Memory OLTP'
WHEN 1 THEN 'Server supports In-Memory OLTP'  
ELSE 'Unknown'
END as [Is SQL Server supports In-Memory OLTP ?]

USE [master];

SELECT CASE SERVERPROPERTY('IsXTPSupported ')

WHEN 0 THEN 'Server does not supports In-Memory OLTP'

WHEN 1 THEN 'Server supports In-Memory OLTP'

ELSE 'Unknown'

END as [Is SQL Server supports In-Memory OLTP ?]

Previous Post Next Post

About The Author

Charith Silva

Charith Silva is a Microsoft certified SQL Server developer and database administrator who was graduated at Buckinghamshire New university in the UK. His career was started in 1998, primarily into Web application development, and later diversified into database development. He has got a vast experience in SQL Server database development, Database administration and Business Intelligence development. He believes that sharing the knowledge is key to the success.

Number of Posts : 87

All Posts by : Charith Silva