I forgot to mention in my first post. This is a virtual machine not running on NUMA architecture.

Thanks for the verification. Yes, I agree that there is much more that goes into determining what is wrong. Yes, I am sure the wait stat is a daily count....

ChrisM@Work (3/24/2014)

---

tfendt (3/24/2014)

---

ChrisM@Work (3/24/2014)

---

Have a look at the NTILE function in Books Online (SQL Server help).

NTILE(n) splits the data into n equal-sized partitions numbered 1 to n in a...

ChrisM@Work (3/24/2014)

---

tfendt (3/24/2014)

---

ChrisM@Work (3/24/2014)

---

Have a look at the NTILE function in Books Online (SQL Server help).

NTILE(n) splits the data into n equal-sized partitions numbered 1 to n in a...

ChrisM@Work (3/24/2014)

---

Have a look at the NTILE function in Books Online (SQL Server help).

NTILE(n) splits the data into n equal-sized partitions numbered 1 to n in a user-defined order...

tfendt (3/24/2014)

---

ChrisM@home (3/23/2014)

This query works only because of the sequence of RepairId in table2, which already orders most-used tyres ahead of least-used tyres, probably by accident. If table2 really is...

ChrisM@home (3/23/2014)

This query works only because of the sequence of RepairId in table2, which already orders most-used tyres ahead of least-used tyres, probably by accident. If table2 really is artificially...

Lynn Pettis (3/21/2014)

---

Added two more orders for the same tire and Dealer 3 shows up but only reports the tire as 66% of the total when in actuality it is...

Thanks for the tip. I will make sure to change it in my query.

I also posted this question in StackOverflow. Here is the solution they came up with:

select DealerId, Tire, count(*) as RepairsOfThisTire,

max(cnt) as TotalRepairs,

...

The Preagg query is just counting the total number or records per dealer in table 2.

I switched the inner join to a left outer join and got some crazy results....

It is close to what I wrote in my example.

Your query returns this:

DealerIDTire ...

Thanks everyone for the input. I will just focus on the short term waits stats and clear out the rest.

See the picture above. The total wait I am using for disk if at the top under resource waits. I use a program to store all performance and wait statistics....

There was no error.