Spinning up the Demo DB on a VM Workstation and I’ve been sitting at near the end of “Load table from file” for about, mmmm, 30 hours. I’m seeing SQLServer activity so it’s not hanging. Thoughts from the on-prem gurus?
Thanks!
@Mark_Wonsil In the sql activity monitor does it show what query is currently running? I have never loaded 700 but had a conversion that got stuck like this.
It’s not the “Finished dialog box is hidden behind another window” problem is it?
Processes launched in EAC are notorious for this. The EAC puts up a “Please wait …” dialog, then launches the process in a modal form. When the launched process completes, it usually gives a “Complete, press OK” dialog. But if that ends up behind the EAC window, you just see EAC’s original “Please wait … dialog”. And it looks like the process is till running, when it is just waiting for you to hit that last “OK” button.
I just tried on our test environment, it took 26 minutes to create the demo DB. Which Task # is it getting stuck on?
Obs, lots of memory pressure. I think the VM only has 4G but I could allocate more. Since this is just a play around version for me, app server and sql on same machine. Again, this is just for me.
Took 8 minutes for that step for me. I have 20GB assigned and 17 are being used by SQL Server.
Ok, shut it down. Dropped the database. Added two cores + 4GB and rebooted. When the reboot finished, I saw a feature (PowerShell 2.0 + .Net 3.5) complete. 
It has since blown past step 420. While I’m sure the extra processor and memory are helping, I think I needed a reboot in the requisite step that I missed. 
1 Like
Ahhh, the IT life. Where seemingly random things destroy everything you are trying to do.
2 Likes
Yep. The whole process took less than 13 minutes… sigh.
So it was like spaced out at “420” ?
1 Like
1 Like
