DBCC is running from 5 days

Question

DBCC is running from 5 days

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

Jeff Moden - Thursday, March 30, 2017 8:37 AM
NorthernSoul - Thursday, March 30, 2017 2:34 AM
I notice you've raised another topic regarding memory pressure. Is this happening on the same server?
Heh.... yeah.... the one with 27GB allocated to SQL Server?

That's the one. I've just re-read the other thread and its been confirmed that both topics are related.

Jeff Moden SSC Guru Points: 1004402 More actions · Answer 2

NorthernSoul - Thursday, March 30, 2017 12:51 PM
Jeff Moden - Thursday, March 30, 2017 8:37 AM
NorthernSoul - Thursday, March 30, 2017 2:34 AM
I notice you've raised another topic regarding memory pressure. Is this happening on the same server?
Heh.... yeah.... the one with 27GB allocated to SQL Server?
That's the one. I've just re-read the other thread and its been confirmed that both topics are related.

Interesting. According to this thread, they have a "huge database in TB size" and they haven't enough memory to deal with a likely size table. If the database truly is that size and the company won't even spring for some extra RAM, then I honestly feel sorry for the OP. If the OP is making any of this up, then I feel sorry for the company the OP works for. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)