ranku_mogudu Posted July 13, 2021 Report Share Posted July 13, 2021 11 hours ago, chapstick said: Is this not developers work ? performance tuning in most of the companies is DBA task Quote Link to comment Share on other sites More sharing options...
ranku_mogudu Posted July 13, 2021 Report Share Posted July 13, 2021 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 1 Quote Link to comment Share on other sites More sharing options...
ranku_mogudu Posted July 13, 2021 Report Share Posted July 13, 2021 current performance metrics enti? execution plan emani chepthundhi cheppa radhu @Sarvapindi Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.