You guys play with this all you want. You can grapple seconds left and right.

You want quantum leap improvement? You make that index with all the included columns.

The...

I'll let Jeff take that one... but it looks like you're missing key details in your question about GB on the machine & all.

Since you're not really looking for a paid consult, here's the best any of us can offer... written by Gail

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2

@Gail the OP is from South Africa so I guess this...

Don't worry about it. Except for the comparaison, I was agreeing with you 100% :-D.

Grant Fritchey (10/17/2011)

---

Kiara (10/17/2011)

---

Grant Fritchey (10/16/2011)

---

BTW, I've just been deleting Thread emails for the last week. It was easier than trying to keep up. Did I miss anything big? Marriages,...

ruan.keyser (10/17/2011)

---

I have read a little about the CXPACKET wait type.

Now this is one of our top waits.

Would increasing the MDOP to 4 help this out?

I have requested from one...

ruan.keyser (10/17/2011)

---

Thanks for the update.

I would love to have some one's email address, as I believe this is going to be a looooong problem.

I've been put in an environment that...

Unless you want to include pretty much every other columns in that table, that looks like the most-ish plan you can expect.

Might be worth it, might now. I don't...

Lowell (10/17/2011)

---

i don't believe the index_creation_date / modify date exists(or at least is exposed); i posed a similar question ofn when is a server side trace Creation_date...it's not available eaither...jsut...

Ah, how 1 little word changes everything!

expect except!

And no I have no idea where to get that info.

It's not in sys.indexes, sys.stats, indexproperty nor sys.dm_db_index_physical_stats dynamic management function and the...

Easy way to test for filters.

Start a new trace and start the standard (default) trace.

Depending on how SSRS plays here you might see something like SP_EXECUTESQL ... 'EXEC yourProcNameHere'

pwalter83 (10/17/2011)

---

Ninja's_RGR'us (10/14/2011)

---

From your last message I assume that you have seen the command in profiler sent from either BIDS or SSRS.

Please paste it here.

P.S. You won't see the full...

My bad here. I missed the active / active part.

If you have 2 servesr running at the same time on the same machine you probably need to limit both...

Jeff Moden (10/15/2011)

---

Ninja's_RGR'us (10/14/2011)

---

Brandie Tarvin (10/14/2011)

---

Why is Remi's screen shot showing my numbers up top instead of his?

Or is there something in the code that makes even a screen shot...

Micro manager...