Post reply

SQL query log

  • July 19, 2010 at 4:50 pm

    #141223

    Hello All,

    I m looking for something similar than the MYSQL that I can see in real time the queries that is been running at the back .

    How on SQL server I can be looking on real time all queries that is been executing and what it is

    Example let's imagine that the user has send a request using the GUI to collect the telefone number

    I want to be able to see in the log

    SELECT Tel FROM Contacts or similar

    how Can I do that

  • July 19, 2010 at 4:54 pm

    #1195216

    Use SQL Server Profiler

    Thanks

    SQLBuddy

  • July 20, 2010 at 12:43 am

    #1195308

    Thanks you are a STAR

  • July 20, 2010 at 2:15 am

    #1195342

    However you should not use the Profiler GUI to trace a busy production server. It can have an adverse impact on the server's performance. If you're doing long-term traces, use the server-side trace functionality and trace to a file.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 3, 2010 at 9:39 am

    #1258517

    How do I turn on Server side trace and file trace?

  • December 3, 2010 at 10:02 am

    #1258533

    I found Gail's article to turn on trace.

  • December 3, 2010 at 12:38 pm

    #1258610

    I don't recall having written an article on Trace. Grant wrote one that was published earlier this week and should still be on the front page. Make sure you've read that.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 3, 2010 at 1:48 pm

    #1258645

    GilaMonster (12/3/2010)

    I don't recall having written an article on Trace. Grant wrote one that was published earlier this week and should still be on the front page. Make sure you've read that.

    Could be one of those cases where you've forgotten more than some of us will know 😀

Viewing 8 posts - 1 through 8 (of 8 total)

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