Post reply

Difference Between SQL Server 2005 Performance Dashboard And Profiler

  • October 26, 2008 at 6:00 pm

    #195075

    can any one please say me the difference between Performance Dashboard and Profiler...i know dat Peformance Dashboard does not work on Windows 2000 server...are there are functional differences between these two and which one is suggested for diagnosing for SQL server..thx

  • October 27, 2008 at 12:50 am

    #889834

    Profiler records events that occur on the server. The events range from SQL queries executed to locks acquired, to logins/logouts, to deprecations, deadlock and a whole lot more.

    Performance dashboard is a front end on top of some of the 2005 DMVs.

    Which you use depends what you're trying to do.

    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

  • October 27, 2008 at 3:55 am

    #889884

    thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

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