A) not sure what the xml files are but they aren't query plan(s) of the actual process. Looks like you may have trapped msdb job activity?

B) the code you...

Read my comment - it says why. I didn't want you trying to bring back a billion rows and crashing the machine you were running the query from. ...

sqlguy-736318 (1/12/2014)

---

I have an incident table with a column named ticketnumber. Ticketnumber has a varchar data type but I want to select the rows that have a ticketnumber int...

PrometheusRising (1/10/2014)

---

All of us have probably encountered generic error messages while looking through the SQL Server logs. I was wondering if anyone had written, in a single white paper,...

1) Have you done a wait stats and file IO stall analyses during both sets of runs?

2) Do you have vCPU Hot Plug enabled in VMware?

3) Reference this to check...

Read up on sp_cycle_errorlog in BOL and see if it will help you here.

There are unix-type tools out there you can run on windows that will allow you to take...

PLE is not a very useful metric on modern hardware. And the 5 minute guideline is exceptionally inappropriate these days. I would look elsewhere for your baselining/tuning needs.

I had totally forgotten about the fact that you cannot change the query code. With that limitation, combined with the fact that the queries can use a wide array...

I didn't verify the statement that this IS available in SQL 2012, but if it turns out to not be I do know there has been an (unsupported) workaround for...

1) It is the 15% mismatch between estimated and actual rows that is getting you...

1) 68GB is pretty damn fat for just 200M+ rows!!

2) Those are estimated plans. Not helpful for what I need to see. Can you provide actuals?

3)...

How are you determining that SQL Server is not using all the memory you think it should be using?

Run DBCC memorystatus and search online for the documentation for...

Backend is EMC SAN so I'd be surprised if IO is the issue, although it is reading a good amount of data (each test query returns several million rows into...

1) Please post sample actual queries for both.

2) Please attach actual query plans for both too.

3) 3 minutes to scan 200M rows is HORRIBLE performance, even if the...

So the migrated package runs fine in 2012 BIDS? Or the pre-migrated 2008R2 package runs fine in 2008R2 BIDS?

Is that the full error message?

What are you validation...