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.
MediThwack 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 an xEvent session to capture deadlock details.
This architecture allows for DPA to have a minimal footprint. The metrics returned are a great way to see what is happening inside of the database engine.
Noting for the record:
DMV Dynamic Management Views
T-SQL .Transact SQL
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.