No Profiler Trace Results

  • Hello,

    I created a custom template on and select existing connection, rpc:starting, rpc:completed, sp:completed, sql:batchcompleted, sql:batchstarting. I then filter on the database id. I started a new trace and selected the template name. Then I ran a SQL script containing a variety of SQL statements and nothing showed in my trace. Nothing.

    My account has sysadmin role. What did I miss?

    Joe

  • I assume that you specified the correct Database ID and that there is not a leading or trailing space embedded in the Database ID Filter?

    What happens if you remove the filter? I had a problem like before...

    If that does not work you may want to try adding some additional events or create a new Trace and start removing events and adding filters, etc.

    Just a thought.:-)

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Yes, it is very odd. What I was doing was to start a new trace, then select the custom template I made, and check the events within the template, and then run. I think that you cannot do that. I saw a couple of times that the database id was fine but then SQL was putting things in the NOT Like part of the filter, something like that.

    So, I stopped everything tracing. Started a new trace, selected my template, did not look at it, ran the trace. Then I went into a New Query and ran my script of SQL statements and they showed up fine.

    The concern I have is that I tried this several times before it finally worked. Why did it not work? Oh, and the other thing I did was to raise the permissions for my account on the database I want to trace to dbowner. I added the dbcreator, processadmin, serveradmin to go along with the sysadmin role I already had. Hmmm, and then it worked.

  • If you are a member of the SysAdmin Role you do not need to grant any Database Roles.

    If you are a member of the DBOwner FIxed Database Role then you inherit all of the Database Fixed roles with the exception of db_denyreader & db_denywriter.

    I hope this helps.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • --------------------------------------------------------------------------------------------

    I saw a couple of times that the database id was fine but then SQL was putting things in the NOT Like part of the filter, something like that.

    ---------------------------------------------------------------------------------------------

    I suspect that it may have been the Database ID Filter... 🙂

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply