I have as stored procedure that creates a ridiculous amount of overhead. The processor reaches its maximum due to a high DPC count. I visited Microsoft’s Tech Net site and it mentioned something about needing to check my network hardware or upgrade my processors on my SQL box.
The query consists of a create table, a couple of select statements (with a few unions), and an insert into the created temp table. I am pulling from a table that has over 9 million rows.
How can I keep the DPC’s down so that my SQL box won’t crater every time I run this Stored Proc? Any help would be appreciated
RogueSuit
The query consists of a create table, a couple of select statements (with a few unions), and an insert into the created temp table. I am pulling from a table that has over 9 million rows.
How can I keep the DPC’s down so that my SQL box won’t crater every time I run this Stored Proc? Any help would be appreciated
RogueSuit
