SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures

Earlier I wrote a blog post about the Location of Natively Compiled Stored Procedure and Naming Convention. In this blog post, I wrote about location of natively compiled stored procedures.

In the blog post, I have used following image.

SQL SERVER - Extension of the SQL Server Natively Compiled Stored Procedures inmemnativelocation2

Solarwinds

One of the questions which I have received was what do various extensions like c, dll, obj etc means. My friend Balmukund Lakhani explains that very well in the his blog post, however for the reference it is listed here once again.

File ExtensionUsage
.cC source file generated by In-Memory engine
.dllNatively compiled DLL to be loaded into SQL Server process
.mat.xmlMAT export file
.objObject file generated by C compiler
.outCompiler output file
.pdbSymbol file for the dll. Used for debugging code issues.

Let me know what do you think of the native stored procedure. Tell you the truth, I have not used this feature so far and I have very limited experience, but again, Microsoft has included this feature in the SQL Server so I assume there will be demand of this feature and some of the biggest customers must be using this feature across their big applications.

Let me know what is your opinion in the comment section.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
,
Previous Post
SQL SERVER – Performance Dashboard – Historic Information
Next Post
SQL SERVER – How to Check Snapshot Isolation State of Database

Related Posts

Leave a Reply

Menu