Post reply

How do I find what process is making the server slow ?

  • March 3, 2016 at 3:02 pm

    #305454

    Anyone,

    Can you share with us some SQL that is making the SQL server very slow ?

  • March 3, 2016 at 3:52 pm

    #1862954

    "sp_who2" works for me...

    Wonder whether someone could pass some SQL that will list everything that we get as output from sp_who2

  • March 3, 2016 at 4:33 pm

    #1862958

    Take a look at sp_whoisactive by Adam Machanic.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • March 3, 2016 at 6:34 pm

    #1862974

    Alan.B (3/3/2016)

    Take a look at sp_whoisactive by Adam Machanic.

    +1000000

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 3, 2016 at 10:46 pm

    #1862988

    To know how to use sp_WhoIsActive you can take the help of this link: https://www.brentozar.com/archive/2010/09/sql-server-dba-scripts-how-to-find-slow-sql-server-queries/

  • March 3, 2016 at 11:07 pm

    This was removed by the editor as SPAM

  • March 3, 2016 at 11:09 pm

    #1862992

    I didnt know about it... have to learn..

    Thanks

  • March 4, 2016 at 3:39 am

    #1863042

    In addition to the DMVs exposed through sp_whoisactive, you need to be focused on wait statistics[/url]. That tells you what is literally causing the server to run slow.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 4, 2016 at 3:45 am

    #1863044

    TheSQLGuru (3/3/2016)

    Alan.B (3/3/2016)

    Take a look at sp_whoisactive by Adam Machanic.

    +1000000

    I'm asking myself why is not that SP a part of the master's sps, but we have to create it on every new instance?

    Igor Micev,My blog: www.igormicev.com

  • March 4, 2016 at 5:59 am

    #1863068

    tony28 (3/3/2016)

    I didnt know about it... have to learn..

    Thanks

    Adam posted a 30-day blog post series on SQLBlog.com about all the ins-and-outs of sp_whoisactive. Read and learn.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • March 4, 2016 at 9:03 am

    #1863172

    TheSQLGuru (3/4/2016)

    tony28 (3/3/2016)

    I didnt know about it... have to learn..

    Thanks

    Adam posted a 30-day blog post series on SQLBlog.com about all the ins-and-outs of sp_whoisactive. Read and learn.

    Yes , I found this, I am at 8/30 ... 2weeks little more activity here and I found lot of good tips and features

    Thanks

Viewing 11 posts - 1 through 10 (of 10 total)

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