DBCC is running from 5 days

• NorthernSoul

  SSCertifiable

  Points: 6869

  More actions

  March 30, 2017 at 12:51 pm

  #1935823

  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: 1000539

  More actions

  March 30, 2017 at 8:34 pm

  #1935897

  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)
  Intro to Tally Tables and Functions