Sql dba unnara va evarina..

[ranku_mogudu]

11 hours ago, chapstick said:

Is this not developers work ?

performance tuning  in most of the companies is DBA task

[ranku_mogudu]

4 minutes ago, dasari4kntr said:

then..

try the memory optimized tables...like below...

may be..you need to little research on that option....

 

CREATE TABLE dbo.ShoppingCart (   
    ShoppingCartId INT IDENTITY(1,1) PRIMARY KEY NONCLUSTERED,  
    UserId INT NOT NULL INDEX ix_UserId NONCLUSTERED
        HASH WITH (BUCKET_COUNT=1000000),
    CreatedDate DATETIME2 NOT NULL,   
    TotalPrice MONEY  
    ) WITH (MEMORY_OPTIMIZED=ON)   
GO  

Memory optimization works better in 2016.not on 2014..just an info

[ranku_mogudu]

current performance metrics enti? execution plan emani chepthundhi cheppa radhu @Sarvapindi