Viewing 15 posts - 16 through 30 (of 179 total)
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...
November 17, 2020 at 3:50 pm
You tried to clean the logs manually? if so, did it worked?
November 17, 2020 at 3:43 pm
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...
November 6, 2020 at 1:44 pm
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...
October 8, 2020 at 3:36 pm
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...
October 1, 2020 at 1:29 pm
You might want to take a look at VLFs ( Virtual log files) in the transaction log.
I think Resource Governor can help you with that as long as you have enterprise edition.
September 15, 2020 at 3:35 pm
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...
September 9, 2020 at 1:19 pm
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...
September 5, 2020 at 2:28 am
Hi Victor,
on a side note before answering the questions:
September 5, 2020 at 1:45 am
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...
September 5, 2020 at 1:30 am
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...
September 4, 2020 at 7:11 pm
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...
September 2, 2020 at 6:06 pm
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?
Nodes = SQL...
September 2, 2020 at 5:48 pm
When you run the klist.exe tickets its not supposed to return the service account, its gonna return the ticket from the server if its using kerberos, if you connect to...
September 2, 2020 at 4:10 pm
Viewing 15 posts - 16 through 30 (of 179 total)