Eugene - It most definitely does lock up tempdb.

Perry - Agreed; however simply trying to understand performance implications between the two.

After some more digging and testing, it would seem that a SELECT INTO does indeed lock some of the system tables.

We're now starting to dissect performance between SELECT INTO and...

No and no 🙁

Ya got me again. Previously I was specifying the database, this time I was not. As soon as I specified the database, it indeed took me to 03.

Thank you much...

Wow! hahaha, that's what it was ... oh my, I feel smart. Yeah, using 0's and 0's probably wasn't the best idea in my test lab.

Thank you!

Even though that did...

Ok, so switched to the engine port #:

-- Configure ReadOnly Routing

ALTER AVAILABILITY GROUP [AG4] MODIFY REPLICA ON N'SQL01\AO1' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = ALL));

ALTER AVAILABILITY GROUP [AG4] MODIFY REPLICA ON N'SQL01\AO1'...

Hi Perry,

So first and foremost, why does using the GUI and specifying the Readable Secondary not take into account any of this? Am I missing something in the AG setup,...

Ok cool, I'll check into it when I get home.

Thanks

Will try later; however I defined the read intent via wizard and it's in the AG creation script above. You have to go back and state read intent a second...

Just went through a new setup:

CREATE DATABASE MyDB4

BACKUP DATABASE MyDB4 TO DISK = 'c:\Backup\MyDB4.bak'

--- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.

:Connect SQL01\AO1

IF (SELECT state FROM sys.endpoints WHERE name...

Found the .xel files locally on the server ... which are accessible via the dashboard. Anyone know if there's a better way to query these?

Thanks

Hi Stewart.

This is just running ssms from a run/cmd line.

Thanks

Nice! You're right, my local SSMS 2012/2014 has...

Hi djj, thanks for the prompt response. Can you please elaborate on that a little further?

Thanks!

Hello Jeff,

Thanks for the reply! We've chatted in the past 🙂

I couldn't agree more with your statements; however I'm really looking for something relatively simplistic without having to recreate the...