SQL Server Performance

SQL 2008 data collector??

Discussion in 'SQL Server 2008 General DBA Questions' started by MichaelB, Jun 23, 2009.

  1. MichaelB Member

    I am interested in performance data collection using SQL 2008. Does it require all sources to be from SQL 2008? I read that it can pull from a multiple of sources but none seem defined. I cant find an answer to this anywhere so I thought I would ask you smart guys:)Mike
  2. ndinakar Member

    If you are talking about the Management Datawarehouse in SQL 2008, it only work for SQL 2008 servers... the information it collects uses some new DMVs that were introduced with 2008 so you cannot configure a 2005 server for data collection.

Share This Page