Questions tagged [memory-optimized-tables]
Memory Optimized Tables typically refer to tables where the rows in the table are stored in the server's RAM.
104
questions
0
votes
0
answers
17
views
Restoring of OLTP In-Memory DBs in SQL 2022 on Ubuntu really slow
We've started using OLTP In-Memory tables (schema durability only) in a small DB (DB properties show 137 MB of Row data, 1GB of In-Memory data, BAK size of 152MB) and the recovery times (either ...
0
votes
1
answer
52
views
What happens when you try to use more than 32 GB of memory-optimized data in a database on Standard Edition?
In SQL Server 2019, you cannot put more than 32 GB of memory-optimized data in a database on Standard Edition. What happens if you try anyway?
I'd try it myself, but I don't want to risk discovering ...
- 545
4
votes
2
answers
569
views
In-memory OLTP databases take very long to recover during startup
we use SQL Server 2019 on Windows with in-memory oltp activated on some databases. After a server reboot/service restart, the in-memory databases take very long to be available (more than an hour) ...
- 43
0
votes
1
answer
253
views
Why use a memory-optimized table variable instead of a temp table or normal table variable?
Table variables have a bad reputation, mostly due to cardinality estimates. However, this reputation was earned before the introduction of memory-optimized table variables. Microsoft covers some use-...
- 545
0
votes
1
answer
85
views
If memory-optimised tables always live in RAM, how do they survive a server reboot?
I clearly have a missing piece in my understanding of in-memory OLTP. Suppose that I have a memory-optimised table that is set up to persist both schema and data. Given that these tables always live ...
- 545
0
votes
2
answers
388
views
What is the quickest and most efficient way to remove an in-memory filegroup from a large SQL Server 2019 database?
I have a database with an in-memory filegroup that I want to remove (I won't go into many details why, but I want to move the database to another place without this filegroup).
I'm trying to move the ...
- 29
0
votes
0
answers
155
views
LocalDB build and Memory Optimized table types
We have a DevOps pipeline for our DB Build/Release process and we're using VS SQL Database projects. We have one DB which makes extensive use of memory optimized table variables. Used for transfering ...
- 45
14
votes
1
answer
2k
views
Why does a simple natively compiled stored procedure run out of memory when table variables are used?
My version of SQL Server is SQL Server 2019 (RTM-CU18). The following repro code requires that an in memory filegroup is created. For anyone following along, please remember that an in-memory ...
- 32.5k
0
votes
0
answers
2k
views
"There is insufficient system memory in resource pool 'default' to run this query" error with MEMORY_OPTIMIZED tables
I use Memory-Optimized Table in my SQL Server. However the error "There is insufficient system memory in resource pool 'default' to run this query" occures after several drop/create/insert ...
- 1
-2
votes
1
answer
118
views
DELETE ... INTO ... FROM (SELECT)
I am wondering why this is coded this way.
declare @messages table
([SEQUENCE_ID] BIGINT,
[MESSAGE_ID] BIGINT
PRIMARY KEY CLUSTERED ([SEQUENCE_ID]))
;
delete T
output deleted....
- 21
0
votes
1
answer
116
views
Are there any special considerations for a log-shipping role change when the database has memory optimzed files?
We're noticing a problem with our log-shipping setups when the database contains a memory-optimized file. Specifically, after changing the primary/secondary roles, restoring log backups taken after ...
0
votes
1
answer
488
views
SQL Server 2017 freezing during bulk insert of large file into in-memory staging table
Running SQL Server 2017 CU20 Standard on a dedicated Dell PowerEdge with 28 cores and 192GB of RAM.
I have a stored procedure that processes large files (~7GB each) in a loop by bulk inserting them ...
- 123
1
vote
1
answer
2k
views
Can I downgrade from SQL Server 2017 CU25 to CU20?
New instance of SQL Server 2017. I chose to install up to CU25 during the initial installation. Been using the database for a few months, but it seems to have a memory leak when using memory-optimized ...
- 123
1
vote
0
answers
163
views
Bogus SQL Server (XTP) in-memory error 41842 claiming 4B rows updated [closed]
We run a large, very active set of in-memory (schema-only) tables - the main table has been split (sharded) into 5 separate databases because the table is a total size of > 50gb (Standard Edition ...
- 29
2
votes
2
answers
2k
views
SQL Server 2016 database backup fails to restore on SQL Server 2019
We were trying to restore the database from SQL Server 2016 Developer Edition to SQL Server 2019 Developer Edition and it was failing with an exception.
Details about this DB:
It has in-memory ...
- 744