It looks like I may have to increase worker threads on MSSQL and/or add more vCPUs:

How It Works: SQL Server – VDI (VSS) Backup Resources[/url]

I currently have above 200 databases...

So I have a very interesting meeting with IT. It's not only my SQL backups the ones that are failing, the VSS backups are failing too. Basically, whoever "grabs the...

TheSQLGuru (5/20/2016)

---

1) Spread out your schedule to minimize overlap. I can't tell you how many times I see umpteen jobs starting at 00:00 (or on the hour) at clients!!! NEXT-NEXT-NEXT...

sql-lover (5/20/2016)

---

Michael L John (5/20/2016)

---

You will see "strange" entries in the msdb tables that correspond to backups created by Nimble protection manager.

While the Nimble may be showing once second,...

Michael L John (5/20/2016)

---

You will see "strange" entries in the msdb tables that correspond to backups created by Nimble protection manager.

While the Nimble may be showing once second, the...

Lynn Pettis (5/20/2016)

---

sql-lover (5/20/2016)

---

TheSQLGuru (5/20/2016)

---

sql-lover (5/20/2016)

---

TheSQLGuru (5/19/2016)

---

I have no idea about your Nimble stuff, but the backup start and end times should be set by the actual backup process in...

TheSQLGuru (5/20/2016)

---

sql-lover (5/20/2016)

---

Thanks for...

Thanks for reply

I guess...

ChrisM@Work (3/24/2016)

---

sql-lover (3/24/2016)

---

ChrisM@Work (3/24/2016)

---

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

Rule #1 when dealing with a deadlocking...

ChrisM@Work (3/24/2016)

---

Can you post the actual (not estimated) execution plan as a .sqlplan attachment please? It will answer a lot of questions.

Rule #1 when dealing with a deadlocking query -...

Sachin Nandanwar (3/23/2016)

---

You can use a UpdLock lockhint on Table1.Updlock allows other reads to acquire Shared locks but will block other transactions from trying to get update or X lock...

Lowell (3/22/2016)

---

yeah i think you need to use sp_executesql and pass the two out parameters to get the errors that Redgates SQL Backup will return;

it will tell you the exact...

None!

It just does not run...

Thanks for reply.

But agree with Grant. Extended Events is more lightweight and I am trying to force myself...

Grant Fritchey (3/10/2016)

---

sql-lover (3/10/2016)

---

Grant,

I just tried that Extended Event session on my Dev box and it's not capturing anything 🙁 I tried a simple store procedure reading from a...