Are you using a failover cluster or an availability group? If you are using an availability group then the dmv's here https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/always-on-availability-groups-dynamic-management-views-functions?view=sql-server-2017 might help you build some monitoring. I know...

Thanks for the re-assurance. I didn't feel you rebuked me, my comments came from my own caution, not your comments.

As you realised I was using the wrong event.

Whilst I corrected...

• This reply was modified 6 years ago by as_1234.

Thanks for your help.

I am trying to get the sql statement to be one of the result columns. I use profiler to see sql statements and their cpu and io...

Edit to remove original reply. I misunderstood the question.

I'm having problems with the mkfs command. The output from lsblk is as follows :

sda                 8:0    0   40G  0 disk

+-sda1              8:1    0   39G  0 part /

+-sda2              8:2    0    1K  0...

Also understand how the data is secured. Something else you want to know before it's urgent.

Grant is, of course, also correct. Make sure you can restore your databases. Just because...

Hello,

I think the maintenance plan should have created a SQL Server agent job. Can you have a look at the history of that job and see if it shows any...

Hello,

I can't give you a definite answer as the setup I had was different to yours. If it helps I had the same issue on our cluster and brought the...

Hello,.

I can't provide a direct answer but an answer to the following question might help others provide advice:

You said that you ran some tests. What were you using to measure...

I am by no means a SQL expert...

All,

I am trying the command:

wget -q https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -

I get the error "no valid OpenPGP  data found"

Can anyone advise what I might be doing wrong?

I also tried...

Sorry, a DR site with a separate IP range is getting beyond my knowledge. That's not something I've setup.

Maybe the distributed availability group feature will be of use to you?...

This is a very vague guess but could there be a .net framework difference between the old and new server that's causing the issue? I've not had problems with it...

If I understand correctly then the two servers that you need in the cluster are on different IP ranges? If so then I'm not sure about that as the servers...

I can't remember the details but I had something similar. The situation I had was as follows:

I tried to create the cluster.

The domain admin found some missing permissions and gave...