| title | sys.dm_linux_proc_sql_maps (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 02/09/2017 | ||||
| ms.prod | sql-vnext | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | article | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 0d0e134a-3a7a-4c68-995b-26b47753f47b | ||||
| caps.latest.revision | 6 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ssLinx-xxxx-xxxx-xxx]
This dmv is based off of the linux /proc/self/maps file. It provides information about the mapped memory regions of [!INCLUDEssNoVersion_md].
| Column name | Data type | Description |
|---|---|---|
| address | nvarchar(256) | The address space in the process that the mapping occupies. |
| perms | nvarchar(256) | Set of permissions: r: read w: write x: execute s: shared p: private (copy on write) |
| offset | nvarchar(256) | The offset into the file. |
| dev | nvarchar(256) | The device (major:minor). |
| inode | bigint | The inode on that device. 0 indicates that no inode is associated with the memory region, as would be the case with BSS (uninitialized data). |
| pathname | nvarchar(256) | The file that is backing the mapping. |
Returns an empty row set when called on a Windows computer.
Requires VIEW SERVER STATE permission.
The following queries return information about specific paths:
SELECT * FROM sys.dm_linux_proc_sql_maps WHERE pathname LIKE '%stack%';
SELECT * FROM sys.dm_linux_proc_sql_maps WHERE pathname LIKE '%mssql%';
SELECT * FROM sys.dm_linux_proc_sql_maps WHERE pathname LIKE '%/usr/%';