Everyone,

Thanks for the feedback so far. Keep it coming. Any details on any of the horror stories would be very welcome.

Hello to the water cooler and all the ships at sea.

I could use a little help on some research. Swing by here and contribute. Also, please share it with others...

When SQL Server 2005 was released, there was an upgrade to ADO. The previous version of ADO had a particular call structure (I forget the precise details, it has been...

I'd say the same thing. Knowing what the wait statistics were before you moved the SAN and after will tell you a lot. Same thing with query metrics. If you...

tindog (6/29/2016)

---

ChrisM@Work (6/29/2016)

---

tindog (6/29/2016)

---

ChrisM@Work (6/29/2016)

---

The Welsh aren't like...

You have to capture performance metrics from the old system and the new system and compare them. You'd want to look at the wait statistics, percentage of cpu, i/o and...

What's the goal here? To join everything to everything and bring back all the data? To what purpose?

Also, you say "single row per record". What do you mean by this?

You're saying deadlock. Do you mean that the SELECT query in question is being chosen as a deadlock victim and it's transaction is being rolled back? Or do you mean...

You've got two choices on capturing this information within SQL SErver 2012 and one more with SQL Server 2016 (and Azure SQL Database).

First, extended events. You can capture rpc_completed event...

And just so you know, the way filtering works in Trace, it captures the events first, using whatever memory & cpu it needs to do that, then determines if the...

Each of the individual statements are going to reflect the statement, but the whole RPC will include any round trip waits between the statements as the data moves back to...

Gary Varga (6/28/2016)

---

Grant Fritchey (6/28/2016)

---

OK, you'll have to explain that to me better. If Azure releases are bad, that makes the SQL Server release better? I don't get that.

Microsoft is...

OK, you'll have to explain that to me better. If Azure releases are bad, that makes the SQL Server release better? I don't get that.

Microsoft is releasing SQL Server more...

Without seeing the error, it's hard to say. However, if you start a transaction and that transaction fails, you will get a rollback of that transaction.

You'll have to set up an Azure account too. If you have access to MSDN, you can get a free account with a limited amount of funds for each month....