Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning How to Use SQL Profiler RE: How to Use SQL Profiler

  • February 19, 2013 at 6:27 am

    #1589174

    thbaig1 (2/19/2013)

    thank you very much SSCrazy. These queries are really great to have. Can I modify these queries to extract queries executed by specific user?

    No.

    thbaig1 (2/19/2013)

    I want to use profiler too, as I have to save records in table for some historical analysis of application benchmark 🙁

    Can you guide me for profiler too ?

    OK, I guess that all you probably need is "SQL:StmtCompleted" with the columns "TextData", "SPID", "Duration", "StartTime", "EndTime", "Reads" and "Write" selected.

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/