Was able to resolve the issue. I thought somebody had restarted the server after I installed the Polybase feature last week but I was wrong. I took a maintenance window...

Yes - both instances have 2 Polybase services each that are set to auto start. I can confirm all are currently running.

This seems correct according to my understanding.

😀

Some people say no and couldn't get the right people to stand behind them or support them even if they...

Here are the CUs and hotfixes that I felt applied, some strongly and some weakly.

Cumulative update package 4

FIX: The query performance is slower when you run the query in SQL...

I'll check that out SQLGuru.

Thx all!

I applied CU #10 in STG and it made a considerable difference. I'll keep the thread updated in case anybody else comes across a similar problem. When I get a...

Looking through the various CU's for SQL Server 2005 SP2, I see 3 hot bugs regarding server-side cursor performance changes when upgrading from 2000 to 2005. I'm going to apply...

I turned RCSI OFF in FSSTG, tried the query again and it timed out (runs slow through 2-tier, past the 3-tier's timeout).

Interesting to note that this doesn't affect ALL queries......

master1ON0

tempdb0OFF0

model0OFF0

msdb1ON0

CRMSTG0OFF1

FSSTG0OFF1

PPSTG0OFF1

CRMDMO0OFF1

FSDMO0OFF1

PPDMO0OFF1

CRMDEV0OFF1

FSDEV0OFF1

PPDEV0OFF1

CRM ?

FS 8.9

PeopleTools 8.47.14.

I think... I'll double-check when I'm back in the office tom.

Thx,

Rob

It is...

Thanks Lynn. I did update stats after the upgrade. We run jobs nightly that defrag indexes that get over 10% fragmentation.

This particular table has 9 indexes. The clustered index...

Update: problem resolved.

We kept trying to delete that SPN but didn't have the right syntax. The AD admin got it to work though with the following:

Thanks...