/sp_whoisactive

sp_whoisactive

Primary LanguageTSQLGNU General Public License v3.0GPL-3.0

sp_WhoIsActive

licence badge stars badge forks badge issues badge

sp_WhoIsActive is a comprehensive activity monitoring stored procedure that works for all versions of SQL Server from 2005 through 2019 and Azure SQL DB.

sp_WhoIsActive is now officially versioned and maintained here on GitHub.

The license is now GPLv3.

Documentation is still available at http://whoisactive.com/docs

If you have enhancements, please consider a PR instead of a fork. I would like to continue to maintain this project for the community.





Microsoft Dynamics AX 2012 - Database Performance

Sometimes it's hard do find what user are executing something that can hurt the SQL Server environment performance. This fork of sp_WhoIsActive enable the DBA to show the name of Microsoft Dynamics AX 2012's user that are quering something.

Pre-requisites

Usage

Parameter Type Description
get_dax_user BIT When 1, enable the procedure to join the DAX database
get_dax_database VARCHAR The DAX database where UserInfo table is located

Example

    EXEC sp_WhoIsActive
        @get_dax_user = 1,
        @get_dax_database = 'CONTOSO';