Activity overview
Latest activity by JerryMA
Eddie, Thanks for quickly getting back on this issue. So I went to turn on verbose logging and realized the option was not there since I was still running version 11.5. I overlooked fact that after upgrading the Tool Belt both instances remained side-by-side. I have since ran the same database compares using the 13.7 version and I'm no longer experiencing the indefinite hanging. Now I am seeing the expected hanging only when database activity is blocking the Redgate process. I will continue testing and if I encounter issues will update this ticket. Thanks again for your help and I hope you can assist James successfully as well. Jerry / comments
Eddie,Thanks for quickly getting back on this issue. So I went to turn on verbose logging and realized the option was not there since I was still running version 11.5. I overlooked fact that after ...
Hi Grant, I agree 100% with James that the performance when comparing has degraded. I've been using SQL Compare consistently over the past 2.5 years on a weekly, sometimes daily, basis and. In my case it just appears to hang indefinitely on some comparisons. Please note that the underlying databases being compared are the same I've been comparing over past 2.5 years and schema changes only slightly over time. Also note that in past whenever I've seen it hang it was due to blocking due to open transaction or pending DDL change. However in these cases I see no blocking. In fact, after running sp_who2 the process is just waiting and there is zero activity on the server at the time. The largest of these databases is only ~400 tables, ~400 indexes, ~200 views, ~125 procs, 1 CLR function, 0 triggers, 1 partition function, ~15 synonyms. Data size is ~600GB. These are SQL Server 2012 SP4 boxes. Thanks in advance for looking into this. Jerry / comments
Hi Grant,I agree 100% with James that the performance when comparing has degraded. I've been using SQL Compare consistently over the past 2.5 years on a weekly, sometimes daily, basis and. In my ca...