Hi guys,

Today we have big problems with Availability Group (AG) synchronization.
Secondary cannot catch up with Primary.
It prevents Transaction Log Truncate to do the work.
Transaction Log...

I noticed 
SQL Full-text Filter Daemon Launcher (MSSQLSERVER) service is running on that machine.
Do we need it? What is it?
I'm afraid somebody just accidently started it.

Kevin,
May I please ask you to clarify some of your your comments.

1) Any time I see nvarchar(4000) parameters I think ORM, mismatched data types, and a...

Guys,
Just wanted to mention that our concern has been always about Disk Latency.
We have SOLARWINDS tool.
Here is a screenshot from today's SOLARWINDS "Files" perfromance.
As you can see, sometimes we spend...

Paul Randal script
sometimes returns transactions with [Begin Time] = NULL
What does it mean?

I tried Adam Mechanic sp_WhoIsActive.
It returns a column open_tran_count
Total count is 23.

I don't have permissions for most of DBCC commands like this one.
Remember i am an ETL Developer with slightly elevated access permissions.
Is there any other way to catch...

Yes, bmg002.
I am storing the results in "tempdb_usage" table in utility database.

Kevin / bmg002,
It very well might be the case that we have a lot of open transactions.
I use this...

Thanks for a script guys.
Here are the results.
Should I focus on columns like
num_of_bytes_read ?
What exactly these columns represent?

Jeff,
"...SQL will probably be exclusively hitting that one - RVO could check by looking at the virtual file stats DMV to see where all the IO is...."

Can...

Jeff,
Just a reminder.
TEMPDB size is 225 GB. Not 120GB.

One of the TEMPDB files size is actually not close at all.
It's around 2GB. All others are...

Jeff,
Agree. I already monitoring the content of TEMPDB and try to identify the biggest performance "killers".
I use this query below.
Should I focus on biggest [Total Allocation MB] queries ?
SELECT...

Performance did not get substantially worse yet since last reboot on January 29th.
My guess one of these things could help:
----We ran UPDATE STATISTICS 2-3 times since last reboot

We just had a meeting with Infrastructure team.
They say there is no evidence of "main resources throttled or yanked out from under them".
They say they monitor it. It...