Least cost to do this is extended events. However, since you're in 2008, there is no GUI for consuming the results (or setting things up). You'll need to query XML...

gdrummer83 (4/11/2016)

---

I have been using Asigra for a little over 2 years. I like the interface and think it's pretty streamlined and to the point. Not only that,...

Sean Lange (4/11/2016)

---

Stating the relative cost of the batch when compared to the...

Modify the database. Anything else you do is going to be bandaid that creates technical debt. Technical debt, like any kind of debt, adds up and will disable you eventually....

Also no experience with Asigra backup.

However, I can tell you one thing about ANY third party backup, make them do a restore. Make them do a point in time restore....

It depends on what we're talking about. If we're talking features that are now on the deprecation list, they just haven't been removed yet. If we're talking features that have...

BL0B_EATER (4/8/2016)

---

Would anyone find an article on Azure's SQL elastic pools worth reading? More on the basic setup and screen navigation? Just to understand where you would add a...

The plan is stored before execution completes, but it's stored just before execution starts. You're trying to capture the plan before execution. There's no way to do that without running...

Not sure where you're getting that traceflags have to be set to work with extended events. As Gail says, that isn't true.

If I were going to use extended events to...

Winning!

Brandie Tarvin (4/7/2016)

---

Grant Fritchey (4/7/2016)

---

Since you're on SQL Server 2012, have you tried using extended events to capture query metrics? They're not free (nothing is, TANSTAAFL always applies), but they...

TheSQLGuru (4/7/2016)

---

Brandie Tarvin (4/7/2016)

---

Grant Fritchey (4/7/2016)

---

Since you're on SQL Server 2012, have you tried using extended events to capture query metrics? They're not free (nothing is, TANSTAAFL always applies), but...

I'm wrestling with an Octopus install gone horribly wrong.

A single query across multiple instances can be done many different ways (AWS or not).

You can look to Multi-Server Management utilities. You can do linked servers, but you're just going...

Since you're on SQL Server 2012, have you tried using extended events to capture query metrics? They're not free (nothing is, TANSTAAFL always applies), but they are much lower cost...