問題描述
我想使用內(nèi)存優(yōu)化表，但出現(xiàn)以下錯誤 - 我該如何解決?任何想法都會有所幫助.
I want to use a memory optimize table and I got below error - how can I fix it? Any idea will be helpful.
消息 41337，級別 16，狀態(tài) 100，第 1 行
無法創(chuàng)建內(nèi)存優(yōu)化表.要創(chuàng)建內(nèi)存優(yōu)化表，數(shù)據(jù)庫必須有一個在線的 MEMORY_OPTIMIZED_FILEGROUP 并且至少有一個容器.
Msg 41337, Level 16, State 100, Line 1
Cannot create memory optimized tables. To create memory optimized tables, the database must have a MEMORY_OPTIMIZED_FILEGROUP that is online and has at least one container.
代碼:
CREATE TABLE dbo.Account
(
AccountID INT IDENTITY(1, 1) PRIMARY KEY NONCLUSTERED
) WITH (MEMORY_OPTIMIZED=ON)
推薦答案
必須先創(chuàng)建一個文件組:
you must create a file Group first :
創(chuàng)建文件組:
imoltp 是一個示例數(shù)據(jù)庫
imoltp is a sampledatabase
ALTER DATABASE imoltp ADD FILEGROUP imoltp_mod
CONTAINS MEMORY_OPTIMIZED_DATA;
將數(shù)據(jù)庫文件添加到您的文件組:
Add DatabaseFile To Your File Group :
ALTER DATABASE imoltp ADD FILE (
name='imoltp_mod1', filename='c:\data\imoltp_mod1')
TO FILEGROUP imoltp_mod;
創(chuàng)建內(nèi)存優(yōu)化表:
CREATE TABLE dbo.Account(
AccountID INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED
) WITH (MEMORY_OPTIMIZED=ON)
看看這個以獲得更多信息:https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/creating-a-memory-優(yōu)化表和本地編譯存儲過程?view=sql-server-ver15更多詳情
take a look at this for get more Info : https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/creating-a-memory-optimized-table-and-a-natively-compiled-stored-procedure?view=sql-server-ver15 for more detail
這篇關(guān)于如何修復(fù) SQL Server 中創(chuàng)建內(nèi)存優(yōu)化表中的錯誤消息 41337、級別 16、狀態(tài) 100的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！