Source of DPA Data

From where exactly does DPA pull its data? Is there an agent on the DB Server? WMI? 

Is it a good reflection of the SQL server engine point of view? Thank you.


Top Replies

  •  DPA does not require an agent, it runs T-SQL to query DMVs and return data. WMI collection was turned off starting with version 10 (although you can enable this if desired). DPA also creates…