No announcements
-
0 VotesIn-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 ...
-
0 Votes
Stored procedure- Release memory after execute
= and DATE TIME FIELDProposed | 3 Replies | 1816 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 | 512 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 | 609 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 | 3597 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 | 898 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 | 1160 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 | 882 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 | 1450 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 | 935 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 | 990 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 | 790 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 | 7329 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 | 1496 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 ... -
0 Votes
SQL server Performance Issue
Hi All, we have performance issue on most of the SQL production server. and we are facing disk idea time is very less during production time. Please find the below artifact. ...Unanswered | 3 Replies | 1635 Views | Created by karthik1202 - Wednesday, January 30, 2019 6:59 AM | Last reply by TiborK - Wednesday, January 30, 2019 9:23 AM -
0 Votes
Met Error When Executing "CREATE CLUSTERED COLUMNSTORE INDEX"
Hi Guys, I am exercising the tutorial at https://www.microsoft.com/en-us/sql-server/developer-get-started/csharp/win/step/3.html. I don't know why but when I execute ...Unanswered | 1 Replies | 1578 Views | Created by Derek_Wang - Sunday, December 30, 2018 9:17 AM | Last reply by Erland Sommarskog - Sunday, December 30, 2018 10:29 AM -
0 Votes
Is there a way (clean or unclean) to eliminate a OLTP data file on a production database?
Is there a way (clean or unclean) to eliminate a OLTP data file on a production database? Because I want to set up a database mirroring (and OLTP ...Unanswered | 2 Replies | 1560 Views | Created by gabriele don - Friday, November 30, 2018 4:58 PM | Last reply by Olaf Helper - Thursday, December 20, 2018 6:57 AM -
1 Votes
SQL Server 2017 log file growth with memory optimized table
I'm start to using the memory optimized table, the problem that I have is the log file growth also with the database put in simple mode. On my maintenance ...Unanswered | 2 Replies | 2203 Views | Created by Cigliutti A - Thursday, September 20, 2018 6:38 AM | Last reply by Mohsin_A_Khan - Thursday, December 20, 2018 1:07 AM - Items 1 to 20 of 199 Next ›
No announcements
