SQL Server Performance

Monitoring AS Server through Profiler

Discussion in 'Analysis Services/Data Warehousing' started by california6, Oct 4, 2007.

  1. california6 New Member

    Hello,
    Is it possible to run Profiler against our AS running on 2000 to monitor all the queries? Some how when i am runing profiler against the AS, it say's server is not available. Even though the AS is available up and running. Any reason why i cant run profiler?
    Appreciated any input.
    Thanks,
  2. bradmcgehee New Member

    Profiler can run agains SQL Server 2005 AS, but not 2000 AS.
  3. california6 New Member

    Thanks for the answer.
    Is it possible to run 2005 Profiler against 2000 AS?
    Thanks,
  4. bradmcgehee New Member

    Profiler 2005 can access most 2000 events, but unfortunately, it can't access 2000 AS events.
  5. satya Moderator

Share This Page