Sync. Schema for All Tables - How Long?

OldNavDog

Hi all,

I am attempting to Convert a 2013 (not 2013 R2) Database to 2015, using this MSDN Article as a guide:

https://msdn.microsoft.com/en-us/librar ... 0(v=nav.80).aspx

So, everything is going ok, then I get down to Task 2, Steps 6 and 7, where it wants to Synchronize the Schema for All Tables.

I launched this from the Dev. Environment (rather than using the PowerShell cmdlet).

NOTE: This is a non-Multi-Tenant situation, with only one Company.

Long story short: It has been running for nearly 24 hours (without error) on a 7.5 GB Database. Is this to be expected? According to the Windows Task Manager, it is consuming around 25% of the available CPU. The CPU utilization goes up and down a little, but stays between 25 and 27 percent. I am reluctant to stop it, in case it is "almost finished", but thanks to Microsoft, they didn't see fit to provide us poor developers with a Progress Bar, or any other reasonable indication that the process is not simply "hung".

This is a fairly highly-customized Database, with dozens of additional tables.

I saw mention of using the SQL Profiler to monitor the process, but I am not familiar with using this tool, and the example blog post seemed WAY too complicated to monitor this task (but maybe not?).

So, how can I tell if this is still working, or just "off in the weeds" somewhere? As I said, there are no errors, and it seems like it might be doing something; but how to know for sure?

Also, am I missing something, or is there an "overlap" between the "procedures" as set forth in these two MSDN Articles, one "step" of which (converting the database) is "contained" in the other (upgrading the data)? It seems like they have you "converting" the data TWICE, once in the "Converting a Database" and then AGAIN in "Upgrading the Data". Is that correct?

https://msdn.microsoft.com/en-us/librar ... 9(v=nav.80).aspx

https://msdn.microsoft.com/en-us/librar ... 8(v=nav.80).aspx


Thanks In Advance!

vremeni4

Hi,

One good and easy way to monitor this is to use Activity Monitor in the SQL Server.
Start SQL studio manager -> connect to the SQL Server, Right click on the SQL Server and select "Activity Monitor".
Open section "Processes", and in the column "Database" set a filter on your database.
In the column "Task State" and "Command" you can see the activity on the database.

In general I had much more better performance when running Sync-NAVtennat form Powershall.

I hope this helps.
Thanks.