Well-tuned queries - in an OLTP system - genarally should not parallellize. This is almost certainly a case of a suboptimally tuned system.

Is auto-updatestats, auto-createstats turned on for your databases?

Do...

Arun (10/12/2008)

---

Nothing beats actually using the skills to gain experiences at work

oh thats really true.. but i wonder if some DBA of today would really work in an environment where...

Thank you, I think it's clear to me now.

Matt Miller (10/17/2008)

---

TheSQLGuru (10/17/2008)

---

So it looks like the only difference between what you guys are saying and what the TheSQLGuru is saying is in the fill factor for the NC...

Matt Miller (10/17/2008)

---

Marios Philippopoulos (10/17/2008)

---

TheSQLGuru (10/17/2008)

---

Since (it seems...

TheSQLGuru (10/17/2008)

---

Since (it seems that) the data is...

Jeff Moden (10/16/2008)

---

Marios Philippopoulos (10/16/2008)

---

Thank you both for your replies.

I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once,...

I think it's settled. I will ask the developer to create the non-cl. idxs with 60% fill factor.

Thanks for your help.

Matt Miller (10/16/2008)

---

The data rows of the underlying table are not sorted and stored in order based on their nonclustered keys.

I think this statement corroborates my earlier interpretation of how...

Matt Miller (10/16/2008)

---

Marios Philippopoulos (10/16/2008)

---

I've always thought that ONLY the clustered index stores its key values in (logical) order, and that storage of the non-clustered index data just follows the...

I've always thought that ONLY the clustered index stores its key values in (logical) order, and that storage of the non-clustered index data just follows the order of the clustered...

It's true that the ordering of the other 2 columns - FKID and Dt - is not sequential, as is that of the AID column.

Let's for a moment assume -...

Thank you both for your replies.

I'm not sure I follow though. How would the non-clustered indexes get fragmented? The table population is done all at once, in a sequential fashion...

I think I got it. 🙂

After adding the performance view, I also added a dashboard view.

While creating the dashboard view I clicked on the "Click to add a view"...

I have successfully created the rule according to the information in the article.

I have also created a performance view in the Monitoring tab of the Ops Mgr console and configured...