Tag Archives: DMV

  1. Finding the worst running query in a stored procedure

    14

    September 10, 2015 by Kenneth Fisher

    The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something …
    Continue reading

  2. Who’s using that database?

    Leave a comment

    March 9, 2015 by Kenneth Fisher

    A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
    Continue reading

  3. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

  4. 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

  5. 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

  6. Negative session_ids

    2

    January 27, 2014 by Kenneth Fisher

    I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
    Continue reading

  7. The “most_recent_sql_handle” column

    1

    January 22, 2014 by Kenneth Fisher

    While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
    Continue reading

  8. Brad Shultz’s blog on reviewing your database

    1

    September 17, 2013 by Kenneth Fisher

    This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
    Continue reading

  9. 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

  10. 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,236 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,236 other followers