But do you have multiple SQL instances running on the same servers? This is the key thing...

PS: I assume it's not possible to have groups of databases directly share listeners?

The GUI doesn't allow you to select an existing listener for an AG, either an existing one...

That is what I would expect, however the...

I found this thread: https://www.sqlservercentral.com/forums/topic/alwayson-listener-port-numbers-and-multiple-listeners

The existing setup for me is:

SQL 2017, Default instance: Instance port 1433,  AG Listener port 1433

SQL 2016, Named instance: Instance port dynamic, AG Listener...

Thanks!

Yeah that's what I mean, there's no option that has all the pros and none of the cons!

Is the instant failover thing really that much of an issue with the...

Thanks for the reply.

This is an active-passive setup, so I'd say that's "share the same active node with multiple instances?"

When you say "a separate cluster would need separate disk space"...

• This reply was modified 5 years, 1 month ago by  lanky_doodle.

Sorry that was a typo. Definitely was "per core, per instance". I...

Thanks. I'm not sure I buy the "talk to MS/licensing reseller" mentality - they're the ones who told me 'per core, per server'! 🙂

Totally agree with this though:

"Now should you...

Thanks. I've read the 2016 guide and the only time it mentions "unlimited instances" is:

Allows customers to run any number of instances of SQL Server 2017 Enterprise Edition

Each server license...

• This reply was modified 5 years, 1 month ago by  lanky_doodle.

PS: This is specifically related to SQL Standard, not Enterprise.

Yeah will do. I've never dealt with cluster SPNs before so wanted to make sure this wasn't actually correct!

Thanks both.

Thanks Sue. Yeah I thought you would do them against the cluster virtual name!

Sorry, what I meant is that the account used for the Agent Service is the only account...

Do you know what, I tried (almost) that. My mistake was having the columns the wrong way around (but seeing it has helped me see why):

a.ACT_Status...

Thanks.

Yes, on dates right at the end of a month that's what I expect. I've changed the label from 'This month' the 'Later this month' to make it clearer.

That's the ticket, thanks so much 🙂

Can you break down the calculation for me. I need to add a "next week" group and doing this works, so the last number...