SQL Server Interview | How to approach analysis if sql server started running really slow

Поділитися
Вставка
  • Опубліковано 11 січ 2015
  • SQL Server Interview Question Answer
    "All the sudden, users start complaining that the SQL Server is running slow. What steps you would take to analysis the problem?"
    Complete List of SSIS Interview Questions by Tech Brothers
    sqlage.blogspot.com/search/lab...
  • Наука та технологія

КОМЕНТАРІ • 7

  • @monday6740
    @monday6740 5 років тому

    I would get a visual on the actual problem, then drill down to the source of the problem, either taking the route to the database, or to the application. It wouldn't be the first time a problem is announced, and the problem actually is on the other end.

  • @Hilzy92
    @Hilzy92 3 роки тому +1

    how do i write a query to remove permissions such as create table, insert, update, and execute from a user?

  • @nagababutalasila5023
    @nagababutalasila5023 2 роки тому

    if slowness reported yesterday and asking analysis today how to collect?

  • @AnandNarine
    @AnandNarine 7 років тому +2

    how to check for deadlocks?

    • @srinusql8413
      @srinusql8413 7 років тому

      enable trace on (1222,-1)

    • @manatelugu3779
      @manatelugu3779 2 роки тому

      By using this command
      Dbcc Traceon (3605,1204,-1)

    • @shekaranugu5986
      @shekaranugu5986 Рік тому

      There are Many Ways.. Enable Traceflags and Check in Errorlogs. and By Using Exteneded Events we can find Deadlocks