No announcements
-
0 VotesSQL server 2016 replay controller cannot start
Hi SQL server replay controller cannot start with the following errors from c:\Program Files (x86)\Microsoft SQL ...Unanswered | 6 Replies | 225 Views | Created by Ah_Ming - Thursday, November 16, 2017 7:28 AM | Last reply by Ah_Ming - Saturday, November 25, 2017 9:18 AM
-
0 Votes
INSERT statement conflicted with FOREIGN KEY constraint
Background: (1) generate a trace file by SQL profiler 2005 (2) replay a trace file by SQL profiler 2016 (3) Found many errors about ...Unanswered | 6 Replies | 113 Views | Created by Ah_Ming - Tuesday, November 21, 2017 8:31 AM | Last reply by Ah_Ming - Wednesday, November 22, 2017 1:08 AM -
0 Votes
Why database DWQueue is involved when distributed replay start?
Hi Anyone know why database "DWQueue" is involved? Thanks! Ming -
0 Votes
Unable to begin a distributed transaction
Hi All, Can someone help me to troubleshoot the below error? I am getting the error executing the below code. CREATE TABLE ...Unanswered | 1 Replies | 117 Views | Created by Rashmita Shanti - Monday, October 23, 2017 12:22 PM | Last reply by Olaf Helper - Monday, October 23, 2017 12:43 PM -
0 Votes
Error when trying to process XEL files using READTRACE
readtrace -I"C:\Temp\Workload\XECapture_0_131375779441360000.xel" -M -o"C:\Temp\Output" -T18 04/26/17 15:29:16.843 [0X000050A8] I/O ...Unanswered | 5 Replies | 1179 Views | Created by Grzegorz Opara - Wednesday, April 26, 2017 1:35 PM | Last reply by jl00008 - Monday, August 14, 2017 3:46 PM -
0 Votes
How to open MSDTC trace files on Windows Server 2008.
MSDTCVTR.bat -tracelog dtctrace.log.2009.filename -o abortedtrace -
0 Votes
Can replay trace be used to sync data between SQL instances?
Howdy. We are using SS2K12 behind an on prem MSCRM install. I have AG's configured for our databases on identical hardware etc.. Unfortunately our CRM releases take a lot of ... -
0 Votes
Failed to get DmpClient HRESULT=0x8007007F
Running SQL Server 2016 developer edition as the default instance on Windows 2012 with all the latest patches Microsoft SQL Server 2016 (RTM-GDR) (KB3194716) - 13.0.1722.0 ...Unanswered | 5 Replies | 2027 Views | Created by Matt7 - Monday, November 14, 2016 6:44 PM | Last reply by AdityaKota - Monday, February 27, 2017 8:10 PM -
0 Votes
Distributed Replay Error: Failed to set proper database for the connection
Hi, I captured a trace file using 'tsql_replay' template on a source machine and am rerunning it on a target machine using Distributed ...Unanswered | 1 Replies | 3264 Views | Created by Mike Cui - Friday, July 18, 2014 9:40 PM | Last reply by Kashif147 - Wednesday, December 14, 2016 5:08 PM -
0 Votes
linked server "LK_SERVER_NAME" was unable to begin a distributed transaction
Hi, I have two DBs namely MS SQL 2008 and ORACLE 11g. I need to transfer data from MS SQL to ORACLE using the linked server. I did the following, I have a ...Unanswered | 2 Replies | 7082 Views | Created by VJ_ANAND - Monday, May 06, 2013 9:52 AM | Last reply by Vien Lee - Friday, October 21, 2016 4:41 AM -
0 Votes
Rename Distributed Replay Controller
Is it possible to RENAME the Distributed Replay Controller i.e., alter the name chosen during setup? JPSUnanswered | 1 Replies | 1600 Views | Created by zonts - Friday, October 14, 2016 4:38 PM | Last reply by Dv111 - Wednesday, October 19, 2016 6:30 AM -
0 Votes
Is it possible to replay the responses back to a client (including the original compute time spent by the database) to mock an existing production database?
This is perhaps a twist on the existing usage of distributed replay, but my goal is to provide a mock/simulator which emulates an existing production database from the perspective of a client ...Unanswered | 1 Replies | 1828 Views | Created by Matt DeBoer - Tuesday, September 06, 2016 10:20 PM | Last reply by SQLGru - Wednesday, October 19, 2016 12:58 AM -
0 Votes
Error DReplay: Could not find any resources appropriate for the specified...
Guys, I have an issue to replay workload using Distributed Replay. I am using SQL Server 2016 ...Answered | 1 Replies | 2543 Views | Created by Grzegorz Opara - Wednesday, September 21, 2016 12:38 PM | Last reply by Grzegorz Opara - Wednesday, September 21, 2016 2:36 PM -
0 Votes
Dreplay Preprocess - Process multiple trace files
What is the exact syntax if we have more than one trace file to process? I found information on this link: ...Unanswered | 1 Replies | 2521 Views | Created by Bernard_B - Thursday, May 19, 2016 4:48 PM | Last reply by Henry Weng - Tuesday, August 09, 2016 2:29 PM -
0 Votes
dreplay replay very slow
dreplay preprocess -m "Lenovo-PC" -i "H:\DR_Trace\DR_Replay_new.trc" -d "H:\DR_Trace\Read y_To_Process" -f 20 2015-05-13 ...Unanswered | 3 Replies | 4306 Views | Created by Mohammad-Sufian - Tuesday, May 12, 2015 4:40 PM | Last reply by Bernard_B - Thursday, May 19, 2016 5:48 PM -
0 Votes
Distributed Replay changing data.
Hi .. Just a quick question . When executing a DR replay on "any" given environment, does the DR controller only simulate the execution of statements without ...Unanswered | 1 Replies | 2473 Views | Created by Wynand Coetzee - Tuesday, April 12, 2016 1:10 PM | Last reply by JohnSterrett - Wednesday, April 20, 2016 5:45 AM -
0 Votes
Log Shipping
What is mechanism Log Shipping for availability ?Answered | 10 Replies | 3374 Views | Created by Lanhale - Sunday, December 06, 2015 6:39 PM | Last reply by Anis Bakkali - Monday, February 29, 2016 3:10 PM -
0 Votes
Upgrade Assistant Tool for SQL Server 2012
Hi Experts, We are planning to upgrade SQL 2005 to SQL 2012. Would like your advise on how effective Upgrade Assistant Tool for SQL Server 2012 is for finding application code ...Discussion | 6 Replies | 4505 Views | Created by VG2014 - Wednesday, November 12, 2014 1:15 PM | Last reply by SQLMojoe - Wednesday, January 20, 2016 6:44 PM -
0 Votes
how to design a good database for the Horse show event.
Hello All, I want to design a database for horseshow . Kindly help me in best design of the database. Below are some of my ... -
0 Votes
log shipping on SQL Server Express
I am using SQL Server Express but can getting the log shipping options .How can I get it ?Answered | 5 Replies | 3636 Views | Created by Lanhale - Monday, December 07, 2015 6:30 AM | Last reply by Shanky_621 - Monday, December 07, 2015 9:21 AM - Items 1 to 20 of 63 Next ›
No announcements
