sp_who2 and sys.dm_exec_requests return me difference rows

Posted on 2007-10-12
Last Modified: 2008-01-09
In sql2005 I run sp_who2 and found bunch of rows with this sp then I try with DMV select * from sys.dm_exec_requests but it return me very less process, why?
so if sys.dm_exec_requests only return me less process as compare to sp_who2 what will be the benefit of using this DMV?
Question by:motioneye
    LVL 25

    Accepted Solution

    when you loock at the status or cmd you'll see the diffrence

    status 'suspend' or cmd 'awaiting command'   are not realy active tasks
    LVL 27

    Assisted Solution

    jogos is right.

    The view, sys.dm_exec_requests, contains one row for every currently executing process.
    The view, sys.dm_exec_sessions, returns information on each session. The procedure,sp_who2, returns the current activity on the database (in whatever state).

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now