2 Replies Latest reply on Apr 22, 2015 2:50 PM by dbnewbie_2007

    Query Resources by SQL Login

    dbnewbie_2007

      Is there a way to query the resources/queries used by a specific SQL Server login? I believe the data is available in the Ignite/DPA repository, as there is a DPA tab called "DB Users" which shows queries by day and SQL login.

      I found this query,  SS TopSQLforOSUser SQL , but the query does not appear to do what I expected or my Ignite repository data structure is different than the query.

       

      Any suggestions, ideas or does anyone have a query they can share?

       

      Thanks!