Phil Parkin (1/25/2011)

---

Derrick Smith (1/25/2011)

---

I always try to keep my queries as SPs on the database itself, and then reference the SP from the package. Makes maintenance/troubleshooting much easier.

That would...

I always try to keep my queries as SPs on the database itself, and then reference the SP from the package. Makes maintenance/troubleshooting much easier.

That would also fix this issue...

Ahhh, found it, and it's working now.

The SQL job step that starts the agent needed to have -Continuous in the command line.

Oddly enough, I never changed this and it was...

Have you tried disabling hyperthreading yet?

Sure. You're overthinking it:

CREATE PROCEDURE Vendors @GPCompany CHAR(5)

AS

BEGIN

DECLARE @Location CHAR(5)

SET @Location = (SELECT [Location]

...

Script out the table in SSMS and recreate it with a new name, migrate data, delete old table, rename new table to old name.

I got this error quite a few...

Why are you using dynamic sql for this?

Whoops - sorry about that. Force of habit on the PARTITION BY.

What if you execute the SP manually from SSMS passing the same variables?

Start at the very bottom and work your way up.

First thing that pops into my head is Hyperthreading (as also mentioned by someone else).

I had a similar issue where everything was just dragging and I couldn't figure out why...turns...

SELECT [RN] = Row_number() OVER (PARTITION BY NAME ORDER BY NAME)

,[name]

INTO #RuleList

FROM sys.objects

WHERE type = 'P'

...

Can you post the code for the proc? From my limited C# knowledge it sounds like there's an internal transaction in the SP and no results are being returned. What...

This is basically the exact reason linked servers exist.

Why don't you want to use them?

Agreed..

When a server is inexplicably slow, this is usually the order of things I check:

1) CPU

2) SAN Cache (may not be applicable)

3) Blocks

4) Spids that are Runnable (usually looking for...

Doesn't seem to work on clustered instances..at least not the 3 I tried. 🙁

Very handy in any case though for all non-clustered servers. Going to get much use out of...