The price you pay for encryption is the usage of CPU, every time you lookup the encrypted columns the CPU has to go through the process of decrypting the data...

Looks like you are using Always On.

Read this wait info from sqlskills.

https://www.sqlskills.com/help/waits/parallel_redo_worker_wait_work/

"This wait type is one that I usually filter out as a benign wait when doing wait...

You tried to clean the logs manually? if so, did it worked?

The connections you see are the ones that are connected to the instance, there's no history, SQL Server doesn't keep one.

Session_Id> 50 are user sessions these are the ones you...

Check the database mail log.

Database Mail > View Database Mail logs

Its supposed to work fine, are you using your company email? is your company allowing you to send emails to...

I'm gonna go and try a guess. these files must be really large too lol.

change these INTs for BIGINTS.

exec sp_msforeachdb 
'use [?]; 
  select DB_NAME() AS...

You might want to take a look at VLFs ( Virtual log files) in the transaction log.

What are SQL Virtual Log Files aka SQL Server VLFs

September 18, 2020 at 2:15 pm

#3789447

I think Resource Governor can help you with that as long as you have enterprise edition.

Hello,

Looking at Microsoft Traceflags documentations, it looks that it only works on 2017 and higher builds.

Traceflag 460:

Replaces data truncation message ID 8152 with message ID 2628. For more information, see this Microsoft Support article.

Starting...

Changing the compatibility level won't turn them "on" in the way that DBCC Tracestatus will return rows, its gonna be in the engine/database itself, its not something you can see...

Hi Victor,

on a side note before answering the questions:

• When you jump from SQL Server 2012 to 2016(DB level 130) you get the cardinality estimator changes that were made in...

Hey guys,

thanks for the replies.

Yeah i wish we had a monitoring tool but we don't have one specifically for SQL Server and the ones we have only see the requests...

• This reply was modified 4 years, 2 months ago by  Alejandro Santana.

Try using Microsoft tool, Kerberos Configuration Manager, and connect to the Node 1 using your account and check the SPN tab and check the box of SQL AG Listeners, check...

Every time SQL Server starts it will try to register the SPNs and every time you shut down the instance it will remove the SPNs.

Excelent. Make sure to remove the...

Named instance? we are talking about the listener, not a named instance.

Let's get something clear xD

You have 2 nodes and 1 listener right?

• Node 1
• Node 2
• Listener

Nodes = SQL...