Stack Overflow
Stack Overflow

Questions tagged [in-memory-oltp]

15 questions
6
votes
2 answers

SQL Server in-memory oltp transaction snapshot isolation

Trying to understand how transaction isolation levels work on SQL Server memory optimized tables (in-memory oltp). If I execute the following query: SET TRANSACTION ISOLATION LEVEL READ COMMITTED BEGIN TRANSACTION SELECT * FROM tm.Tasks An error…
gio
  • 337
  • 3
  • 8
3
votes
0 answers

Write-Write Conflict in In-Memory OLTP SQL Server 2016

We have used the In Memory OLTP feature for our DB. When we are running transactions , we are encountering the below issue. SqlException: The current transaction attempted to update a record that has been updated since this transaction started. The…
Gurmeet
  • 3,094
  • 4
  • 19
  • 43
2
votes
2 answers

The current transaction attempted to update a record that has been updated since this transaction started. The transaction was aborted

I'm trying to update a table which is In-Memory OLTP. There is a scenario where we may have to update a same row in parallel. During concurrent update of a same record I am getting below reported error. Here is my sample update statement. In SQL…
Guna
  • 113
  • 3
  • 9
2
votes
0 answers

SQL Server 2014 in-memory oltp running out of memory

We are trying to load a table from SQL Server Parallel DW APS to In-Memory OLTP SQL Server 2014 Enterprise edition. As we are aware that we have a constraint of 256 GB memory size and total memory on destination server is 500 GB. DBA has allotted…
Nilesh
  • 21
  • 1
2
votes
1 answer

Using In-Memory OLTP Tables instead of temporary tables

SQL Server 2014 introduced what it seems to be a great feature: In-Memory OLTP (In-Memory Optimization). It reminds me of MySQL's MEMORY Storage Engine, which I have tried several years ago and obtained greater performance. I know it has been…
Alexei - check Codidact
  • 22,016
  • 16
  • 145
  • 164
1
vote
1 answer

The path specified by "c:\Data\imoltp_mod1" is not in a valid directory

I am using Sql Server InMemory OLTP for Asp.Net application to store session data in Sql Server using this link After that i found one error like need to create file group for the database which i used for InMemory OLTP. I was able to create the…
V.Prasad
  • 131
  • 4
  • 19
1
vote
0 answers

Bucket count help when creating an in memory table in sql server 2016

I have some business that needs to be run on a daily basis and will be affecting all the rows in the tables. Once a record is fixed and can't change again by the logic it gets moved to an on disk table. At its max there will end up being…
user1663003
  • 149
  • 1
  • 10
1
vote
2 answers

In Memory OLTP table is not visible in SQL Server 2016 Management Studio object explorer

I'm using SQL Server 2016 to learn about in-memory OLTP tables. I created a database mydatabase and then run alter commands on this to create a file group: ALTER DATABASE mydatabase ADD FILEGROUP [mydatabase_mod] CONTAINS MEMORY_OPTIMIZED_DATA;…
Learner
  • 1,277
  • 3
  • 15
  • 34
0
votes
1 answer

How to replace function REPLACE() in Natively-compiled module?

I convert my old stored procedure (SQL Server 2016) to a natively compiled procedure and in one place I receive: SELECT @name = REPLACE(@inname, ':' + @new + ':', ':' + @old + ':') Msg 10794, Level 16, State 93, Procedure usp_2, Line 101 [Batch…
ZedZip
  • 5,794
  • 15
  • 66
  • 119
0
votes
0 answers

Compare SQL Server Performance of In-Memory vs Disk Tables

I want to detect the performance improvements after migrating a table to be In-memory table. Are there any methods/tools that help me to do that?
Ⲁⲅⲅⲉⲗⲟⲥ
  • 608
  • 1
  • 8
  • 31
0
votes
0 answers

MS SQL Server 2016 In-Memory OLTP

I want to migrate a single table to be In-Memory, and I followed these steps: Right click on the table Select 'Memory Optimization Advisor' Follow the wizard steps till the last step, then click 'Migrate' The migration process doesn't complete and…
Ⲁⲅⲅⲉⲗⲟⲥ
  • 608
  • 1
  • 8
  • 31
0
votes
1 answer

Table variables in in-memory oltp procedure

Can I use table variable in memory optimized procedure? DECLARE @tvTableD TABLE ( Column1 INT NOT NULL , Column2 CHAR(10) ); Here it says,…
Magendran V
  • 1,411
  • 3
  • 19
  • 33
0
votes
2 answers

SQL Server memory optimized tables detecting concurrency violation

In SQL Server memory optimized tables, the rowversion data type is not allowed. In my application I still want to be able to detect a concurrency violation where user A opens an item for edit, User B opens the same item, User A saves and User B…
Kyle Reed
  • 71
  • 5
0
votes
0 answers

Speeding up SQL query with multiple joins

I have a .NET e-commerce solution running off a mid-sized SQL Server express database. The system queries the order data which involves many joins (potentially 20 tables) which is quite slow, particularly during periods of heavy use, and I think I…
smartypants
  • 51
  • 1
  • 5
-1
votes
1 answer

Dynamic update or script equivalent in SQL Server in-memory OLTP (Hekaton)

I want to write equivalent stored procedure (contain execute string) in natively compiled stored procedure, but I can't find a way to implement that. Does anyone have an idea?
Hamidreza Shahmoradi
  • 31
  • 1
  • 7