A Little About Hash Aggregate Spills and SLEEP_TASK Waits In SQL Server

Поделиться
HTML-код
  • Опубликовано: 21 окт 2024
  • Become a member! / @erikdarlingdata If you like what you see here, you'll love my advanced performance tuning training:
    training.erikd... Click here for 50% off a health check: training.erikd...

Комментарии • 7

  • @mortezasafaee6981
    @mortezasafaee6981 3 месяца назад +1

    Who is saaaam... i will come saaaam with darling data... thanks erik❤

  • @Chompingbits
    @Chompingbits 3 месяца назад +1

    Every server deserves more RAM. Under powering your SQL servers is like keeping a Malamute in a NYC studio apartment.

    • @ErikDarlingData
      @ErikDarlingData  3 месяца назад

      Yeah, especially when you compare the cost of licensing vs memory, it’s hard to understand why anyone would skimp.

  • @leniskotte
    @leniskotte 3 месяца назад +1

    You go girl

  • @Variant55
    @Variant55 3 месяца назад

    So how do I solve these problems?

    • @ErikDarlingData
      @ErikDarlingData  3 месяца назад

      That depends on why they’re happening.