When using memory-optimized tables, it is still possible to experience waiting. There are other wait types, such as waiting for a log write to complete. However, logging while updating memory-optimized tables is much more efficient than logging for disk-based tables. Wait times are much shorter. And, there are no waits for reading data from disk and no waits for locks on data rows. [1] Feature Set The best execution performance is obtained when using natively compiled stored procedures with memory-optimized tables. However, there are limitations on the TSQL language constructs allowed inside natively compiled stored procedures compared to the rich feature set available with interpreted code in the TSQL language. In addition, natively compiled stored procedures can only access tables and cannot reference disk-based tables. [1] What is RPM? The Resource and Project Management (RPM) application is a Microsoft IT LOB application. RPM automates much of the resource management functionality. But it does not replace the level of communication required among RMs, EMs, and Team Members for Resource Management to be effective. The RPM application includes the following: Allows RMs visibility to meet demand through resource requests. RMs are able to match a resource to an engagement based on different criteria, such as Skill and Availability. RM’s are able to view global and local, resources and can request global assistance if needed. Allows requestors and RMs provide a clear description of requirements for an engagement and view the progress and status of resource requests and bookings. Allows PDMs to tailor the training of consultants to the needs of the market by providing supply and demand data. View various reports that track lead time, how quickly requests are being filled, bench time, and many other factors. The various systems that interact with RPM include the following:
When using memory-optimized tables, it is still possible to experience waiting. There are other wait types, such as waiting for a log write to complete. However, logging while updating memory-optimized tables is much more efficient than logging for disk-based tables. Wait times are much shorter. And, there are no waits for reading data from disk and no waits for locks on data rows. [1] Feature Set The best execution performance is obtained when using natively compiled stored procedures with memory-optimized tables. However, there are limitations on the TSQL language constructs allowed inside natively compiled stored procedures compared to the rich feature set available with interpreted code in the TSQL language. In addition, natively compiled stored procedures can only access tables and cannot reference disk-based tables. [1] What is RPM? The Resource and Project Management (RPM) application is a Microsoft IT LOB application. RPM automates much of the resource management functionality. But it does not replace the level of communication required among RMs, EMs, and Team Members for Resource Management to be effective. The RPM application includes the following: Allows RMs visibility to meet demand through resource requests. RMs are able to match a resource to an engagement based on different criteria, such as Skill and Availability. RM’s are able to view global and local, resources and can request global assistance if needed. Allows requestors and RMs provide a clear description of requirements for an engagement and view the progress and status of resource requests and bookings. Allows PDMs to tailor the training of consultants to the needs of the market by providing supply and demand data. View various reports that track lead time, how quickly requests are being filled, bench time, and many other factors. The various systems that interact with RPM include the following:
Fitment%20of%20Hekaton%20against%20RPM%20SQL%20Server%202014%20CTP1.docx