Activity overview
Latest activity by fllouw
An update: I found the reason for the performance difference. The large database had a single encrypted object (a 5-line stored procedure), and the option to decrypt encrypted objects was checked (it is checked by default). Unchecking the option to decrypt encrypted objects solved the performance issue.
Thanks,
Francois / comments
An update: I found the reason for the performance difference. The large database had a single encrypted object (a 5-line stored procedure), and the option to decrypt encrypted objects was checked (...
I can confirm the same behavior. When registering the SQL database, SQL Compare 10.7 gets stuck at "Reading object text" on a large and complex database. Running sp_who2 against the database shows that the SPID is "SUSPENDED".
Checking the logs, I see:
Populate ObjectText start.
Remembered which version of System.Data.SQLite is in use: System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139
Then, nothing.
Interesting: this database is about 250GB. A database with a similar schema but not data on the same server registers just fine.
Update: I ran a Trace and I see that SQL Compare is executing DBCC PAGE commands while the interface is unresponsive.
Thanks,
Francois / comments
I can confirm the same behavior. When registering the SQL database, SQL Compare 10.7 gets stuck at "Reading object text" on a large and complex database. Running sp_who2 against the database shows ...