Category Archives: DMV

  1. Getting a query plan

    1

    February 19, 2014 by Kenneth Fisher

    Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
    Continue reading

  2. Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

    1

    January 29, 2014 by Kenneth Fisher

    I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
    Continue reading

  3. What port is my instance listening on?

    8

    January 8, 2013 by Kenneth Fisher

    I just had the interesting task of finding the port number that one of the instances I deal with is …
    Continue reading

  4. Logins vs Users

    18

    December 3, 2012 by Kenneth Fisher

    Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems. …
    Continue reading

  5. Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

    3

    November 12, 2012 by Kenneth Fisher

    I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,235 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,235 other followers