The transaction log growing for a database participating in an AG is a sign that the secondary replica had not caught up at the time of your trans log backup. ...

"WHERE

a.SQL2 like 'Select%' AND a.SQL2 like '%Plan FROM%'" *might* work if you can guarantee there is a constant number of spaces between "Plan" and "From".

Another possibility if you...

You can try replacing

"WHERE

a.SQL2 like 'Select%Plan%' "

with

"WHERE

a.SQL2 like 'Select%' AND a.SQL2 like '%Plan%'"

Maybe this will ease your mind. I had the same issue two weeks ago and did the same thing that Gail is advising. The results were three tables...

This is a good read on MAXDOP and the associated CXPACKET wait type:

http://www.brentozar.com/archive/2013/08/what-is-the-cxpacket-wait-type-and-how-do-you-reduce-it/

For what it's worth, we have a vendor application database set to a MAXDOP of 2...

When I saw "VM" and "backup" and "SQL won't start" it reminds me of an incident a few months ago. I'll pass this along in case it helps.

One of...

If you have more space on one drive than another and you are wanting to put more on the drive with more space, what you can do is stripe the...

I just completed setting up an automated backup of SQL Express databases, so I'll share what I did.

The Maintenance Plans and SQL Agent are not available in SQL Server Express....

I have a BS in Business Administration. After getting my degree, I went back to college to become a teacher and taught in high school for a few years....