SQL Server 2019 SE adoption of in-memory OLTP table consideration
0
votes
1
answer
462
views
i have an SQL Server database, that is almost a read-only db (the write procedure will happen at scheduled time, tipically twice a day).
I have recently discovered about the in-memory table (i'am a developer not a DBA expert) and wondering if can be a good idea to move the DB into a "in memory" version; and what are the general issue of this configuration.
In-memory tables is a new topic to me, I am quite confused about the fact if those table are good for speed up only IO operation, or also simple queries (in particular queries that are alredy discrete).
Also i am curious to understand if this technology is a good choiche also when the SQL Server can use discretely fast SSD.
I don't wanto to be too broad in my question, but i am also courious about possible known issues that may happen during migration to this technology.
PS :
To give you a bit of background, the idea come to my mind, because i am facing a little performance issue. Query are already quite performant, but i have few of them (already optimized as much as i can) that take roughtly 0.2-0.3s, too much for my need.
Just for curiosity, i will add that this timing need is due the fact that those "slow" queries are bound to a web request, that should complete in less than a second.
Asked by Skary
(368 rep)
Jul 7, 2023, 10:55 AM
Last activity: Jul 7, 2023, 12:15 PM
Last activity: Jul 7, 2023, 12:15 PM