I had the same issue. Steps to migrate SSISDB from older system to SQL2019 are:

• Install SSIS and the latest CU
• Copy SMK (Service Master Key) from old to new...

• This reply was modified 2 years, 10 months ago by  Vedran Kesegic.

Enable trace flag 1448 on all AG nodes. Without that trace flag, transaction log reader agent STOPS if any asynchronous AG replica is down. That makes transactional replication of AG...

280ms is quite high indeed.

You might want to check the wait stats to confirm that IO is the biggest bottleneck, and not e.g. latch contention on PFS pages in tempdb.

Check...

Thanks Uwe, I'm always glad to hear you. John, thank you also, but your "dying breed" makes me little chilly. Certificate remains for us.

I would rather say that me and...

Thank you all, especially the team that made and run this certification program and learning materials. The learning journey continues, no matter what.

I got the mail starting with "Congratulations!". Passing the lab exam from the first attempt and receiving so wanted MCM certificate makes me very happy! I will celebrate, definitely. I...

After spending almost one year of intense studying, preparation, lot of time and money invested in perfecting my knowledge in Microsoft SQL, now MS says "sorry, that is cancelled"!!?

That sends...

I did use BOL for that one. But it was my last task and end of exam interrupted me.

Pfew! Just finished the lab exam.

Exhausting 6 hours with about 25 minute connection and reconnecting problems.

Really tough exam. It's a race against time.

I solved 12 but some of them probably...

Thanks, Robert!

Thanks, Simon, I really enjoy the journey.

My lab exam is scheduled for tomorrow :w00t:

Preparations were intensive, but we'll see, hope dies last 🙂

I have a question regarding the exam logging...

Login is a server-scope object, not contained within a (user) database. It is stored in a master database.

A database user can be (but does not have to be) mapped to...

Thanks!

How many people passed the lab exam from the first attempt?

Trying to figure out is it really possible or not to hope.

Just found out: I passed the knowlege exam - from the first attempt! Learning and experimenting night and day for 6 months payed off.

Now, the terrifying lab exam is in...

Sysinternals have several tools that might help. One is ProcessExplorer. Look for WorkingSet column. See here.