SQL Server Wait Types, Queues & Wait Statistics (by Amit Bansal)

Поделиться
HTML-код
  • Опубликовано: 3 дек 2024

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

  • @thayal123
    @thayal123 Год назад

    Thoroughly enjoyed this video. Thank you

  • @marco2carriloo436
    @marco2carriloo436 6 лет назад

    It is advisable to partition the hard drive for databases or it is better to link servers with indexes?

  • @youtubeshort6469
    @youtubeshort6469 7 лет назад +1

    What is solution of wait types

    • @youtubeshort6469
      @youtubeshort6469 7 лет назад +3

      Every explain but no one provide solution

    • @sandeepkolanu7666
      @sandeepkolanu7666 6 лет назад +1

      Buddy have a look here www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/ and then try to read Paul's knee jerk analysis on waits, you would get an insight have to solve waits and vs whats symptom and root cause

    • @jayadevkrishnatheeram4617
      @jayadevkrishnatheeram4617 5 лет назад

      I have seen blockings occurring with CXPACKET wait type and cause high CPU usage on the server. This is mainly because of parallel plans running.

  • @Ramesh_Anandh
    @Ramesh_Anandh 3 года назад

    4