No announcements
Found 203 threads
-
0 VotesIn-Memory Used Db backup taken from SQL 2016 Std Ed. SP2 CU12 and trying to restore at SQL 2019 Std. Ed. CU4 & gating failed
Trying to restore DB backup from SQL 2016 to 2019 --In-Memory Used Db backup from SQL 2016 Std Ed. SP2 CU12 to restoring at SQL 2019 Std. Ed. CU4 gating failed with below given ...Unanswered | 6 Replies | 2190 Views | Created by Subhash GGN - Wednesday, June 10, 2020 1:12 PM | Last reply by Subhash GGN - Friday, June 12, 2020 8:42 AM
-
0 Votes
Memory Optimized Table and Shrinking Transaction Log
Hi there, I have a database that contains only 1 table and this table is memory optimized. However the transaction log file has grown significantly larger than the datafile yet when ...Unanswered | 2 Replies | 2298 Views | Created by DAPOOLE - Thursday, March 26, 2020 11:17 AM | Last reply by DAPOOLE - Monday, March 30, 2020 11:13 AM -
0 Votes
Loading large amount of data into in-memory table slower vs permanent table
Hi, we have sql server 2014 (sp2) database server, and separate application server, and we're trying to load around 3,000,000,000 rows into following in-memory ...Unanswered | 1 Replies | 2652 Views | Created by Pedja Stojakovic - Friday, February 7, 2020 9:53 PM | Last reply by Erland Sommarskog - Saturday, February 8, 2020 7:59 PM -
0 Votes
In-memory Database in .Net
Hi All, We are planning to use In-memory DB in C# in one of our requirement. Can anybody suggest which one is the best for doing the below ...Unanswered | 1 Replies | 3029 Views | Created by VishnuRao - Monday, November 25, 2019 6:13 PM | Last reply by Javid Doe - Thursday, January 16, 2020 11:12 PM -
0 Votes
OLTP in-memory Performance improvement?
0) , AcceptedTime DATETIME2 NOT NULL DEFAULT (SYSDATETIME()) , CONSTRAINT PK_UserAgreements_UserID_AgreementVersion PRIMARY KEY NONCLUSTERED HASH (UserID, AgreementVersion) ... -
0 Votes
Stored procedure- Release memory after execute
= and DATE TIME FIELDProposed | 3 Replies | 4934 Views | Created by KGIT - Wednesday, February 3, 2016 5:14 AM | Last reply by VishalWalujwar - Tuesday, November 12, 2019 6:56 AM -
0 Votes
Error importing In-Memory tables bacpac to managed instance on Azure (Business critical Tier)
Hello. I'm trying to import a bacpac with in-memory tables in to Managed instance on azure- Business critical Tier and ...Unanswered | 6 Replies | 3287 Views | Created by sqluser786 - Tuesday, November 5, 2019 12:47 AM | Last reply by sqluser786 - Tuesday, November 5, 2019 5:29 PM -
0 Votes
No CrossDB queries but same error for In-Memory Table
Hi All, Will be Great full if any one helps me for a solution. I have implemented SQL Server In-Memory table. I know cross ...Unanswered | 4 Replies | 3194 Views | Created by Kishore Balaji R - Monday, October 21, 2019 5:16 PM | Last reply by Erland Sommarskog - Tuesday, October 22, 2019 9:19 PM -
0 Votes
Optimized file group deletion
Hi, As we have SQL 2016 E.Ed and for performance issues we had created the memory optimized table so with that optimized file group was created inbuilt in our database. After some ...Proposed | 7 Replies | 7394 Views | Created by SUBHASH_DBA - Wednesday, July 19, 2017 10:45 AM | Last reply by RickMcCrea - Tuesday, October 22, 2019 5:42 PM -
0 Votes
Getting FlushCache: messages in SQL 2012 database.
We have a SQL2012 database that runs a batch process every few weeks. This processes millions of records and can take up to 12 hours (ths is from the aplication vendor - i dont have access to the code ... -
0 Votes
In-Memory OLTP container on flash-storage
Hi, our database is located on a flash-storage. 1) In this case, is one container enough? 2) Especially for in-memory table ...Unanswered | 1 Replies | 3549 Views | Created by DB_Devil - Friday, June 7, 2019 7:03 AM | Last reply by Ned Otter - Sunday, August 25, 2019 11:17 AM -
0 Votes
SQL DB Engine 2012 Buffer Cache Hit Ratio is too low
Hello Team, We are randomly getting the below performance notification from our SCOM tool. we get this kind of alert twice a week and not sure if we really need to increase the ...Unanswered | 11 Replies | 4337 Views | Created by Rahulnem - Tuesday, May 21, 2019 5:13 PM | Last reply by TiborK - Wednesday, August 21, 2019 12:50 PM -
0 Votes
Columnstored Index performance issue
Hi All, in SQL 2017, I have a big table with over 100 columns. I created clustered columnstored index on this table. I tried to update some records in this ...Unanswered | 7 Replies | 3708 Views | Created by sqlmania - Tuesday, July 23, 2019 2:09 PM | Last reply by Dmitri Korotkevitch - Wednesday, July 24, 2019 7:28 PM -
1 Votes
DELETE and Native Compiled SP
I have 3 tables that are to be DELETED based on the Input parameter (a table data type) How do i Perform DELETE Operation , since BREAK is not supported ? Please ...Answered | 8 Replies | 4264 Views | Created by Vish_SQL - Thursday, August 3, 2017 7:43 PM | Last reply by A Buddha - Thursday, July 18, 2019 1:43 PM -
0 Votes
In our Environment our PROD 2 DB Server consuming total memory without any operations performed on that server ?
Hi, In our Environment our PROD 2 DB Server consuming total memory without any operations performed on that server. It is taking total memory 8192 MB which we are ...Answered | 10 Replies | 3584 Views | Created by Madhu4804 - Tuesday, June 11, 2019 5:22 AM | Last reply by Shanky_621 - Monday, June 24, 2019 10:45 AM -
0 Votes
Related to dbstartup?
hi We restarted the services in PROD1 and PROD2, from that time it is showing like dbstartup (for User DB's) in ...Unanswered | 5 Replies | 3663 Views | Created by Madhu4804 - Wednesday, June 19, 2019 6:00 AM | Last reply by Shanky_621 - Wednesday, June 19, 2019 7:31 AM -
0 Votes
Sql Server is designed to use all the memory on the server by default?
Sql Server is designed to use all the memory on the server by default? If this sentence is described by microsoft, Please provide the path where this sentence exactly located in ...Proposed | 3 Replies | 3478 Views | Created by Madhu4804 - Friday, June 7, 2019 10:02 AM | Last reply by Tom Phillips - Friday, June 7, 2019 6:12 PM -
0 Votes
transaction log wait XTP_CHECKPOINT
Hi My db transaction log is keep growing. log_reuse_wait_desc says XTP_CHECKPOINT. We did enable the db for inmemory tables. I issued checkpoint and tried changing the ...Proposed | 4 Replies | 11503 Views | Created by RJDBA - Saturday, March 28, 2015 11:25 PM | Last reply by Chris Kulisz - Friday, March 15, 2019 5:04 PM -
0 Votes
Creating Automatic Robot or something like Crawler
My problem is that in Local SQL Server(2016, Not Asure), I have a table which people can request what type of house they want to buy. On the other hand, there's another table for different ...Unanswered | 1 Replies | 4222 Views | Created by Mohammad Amin(Iran) - Monday, December 24, 2018 11:38 AM | Last reply by EitanBlumin - Monday, February 4, 2019 11:30 AM -
0 Votes
High number of XTP_THREAD_POOL sessions
I have a SQL instance with a database containing a memory-optimized filegroup - with no in-memory workload. However, i notice a lot of sessions containing XTP_THREAD_POOL. On a server with 32 logical ... - Items 1 to 20 of 203 Next ›
No announcements
