I apologize for the late reply. I spoke with the PTB and we have decided that under a second SLA is not necessary for this query. Also I didn't...

One dataset in particular is returning 650K + rows. It's supposed to pass through an API so the end user will be able to import it into their system and...

The table is pretty large and it was becoming a little cumbersome to manage (it is a detailed table). I could provide some time of sums for this table but...

Okay.... I have tried both the UNION ALL option and the Select with all of the data in one table and the performance is roughly the same. I think I...

I actually switched the partitions to other tables that follow a <tablename>_yyyymm format so I would have the data in each table for that particular month. I am starting...

I believe that to be the issue as well, but I have to be able to prove...

I have a PowerShell job that pulls the performance counters every 5 minutes. I have noticed that during the times of the timeouts that we have an excessive number of...

Thank you that answered my question. I know there isn't any data on that side of the partition because the date field I am using uses getdate() as the default....

GilaMonster (11/28/2014)

---

You will always get a lock on the table. It should be short-lived. Make sure that your split isn't forcing data to move from one partition to another, as...

I kind of figured that would be the answer. I was hoping someone was smarter than I and discovered some type of work around.

Yeah I was just wondering if a cte could be used to improve the performance, but I see the census is that it will have no added value; therefore, I...

not sure that is why I asked. I guess if I did a union inside of a CTE it would be the same as doing it without one.

I was hoping I could avoid a union but I guess it is unavoidable. Would a CTE be more effective?

It turned out that the configuration for the NIC teaming was the issue along with errors in the switches. Once they were corrected, the timeouts went away.

Thank you. I figured as much.