No there is no WHERE clause in the statement.

I have tried suggesting this to the vendor before but they dismissed it and said that they query could not be optimised...

Yes, it makes no sense to me really.

This is what they have said, they have sensitive information in certain tables, but they still want to be able to connect from...

****Update on this****

It seems that the inital issue was another team who started to run a Denormalisation process on the database that was really intensive and just killed the server.

After...

I had started to log sp_whoisactive into a table.

I found that there was a long running process of the application that was running a very intensive denormalisation process on the...

• This reply was modified 3 years, 10 months ago by  garryha.

Node 1 is the Primary for HH-SQL-D11 AG with a listener, this has a secondary replica on HH-SQL-D10.

Node 2 is primary for HH-SQL-D10 AG with a listener, this has a...

I do believe the heartbeat is using the same network as everything else.

I use a monitoring tool as well and at the same time this happened to the cluster, the...

• This reply was modified 4 years, 5 months ago by  garryha.

Thank you both for your help.

As far as I know Index maintenance has not been undertaken at my workplace for a long period of time if at all and I would be setting it up...

I thought it may be permissions, but I gave the install domain account sysadmin over the SQL Server and admin on the server so it should be able to do...

• This reply was modified 4 years, 11 months ago by  garryha.

Thanks, I am planning to keep the port number the same.

I ask because a certain team want the port changed to static to upgrade a programme that needs it to...

Yes its due to the change of IP address to the other box that SQL is failed over to.  The IP address used in the Listener is the IP of...

So I created a test setup - two VMs and a read scale Availability group between them, got an entry created in DNS for the Instance IP address and the...

I understand a read scale AG to be a clusterless AG primarilly to provide ability to offload reads to a secondary replica.  However I wanted to use it to provide...

I have tried changing the SQL Server Agent account first through Configuration Manager.  However after entering the new service account name and password and hitting the apply button I get...

No, there are no no-AG databases.  Ok thanks for the reply seems simple enough - failover AGs to primary, change SQL Server/Agent accounts on secondary and then do the same...