We want to monitor a client of ours with DPA but they have a very particular architecture. They have a single DB instance with multiple databases, and we only own one of the databases. We would need DPA to be able to monitor that one DB and only that DB without being able to touch the other DBs in the same instance for the client to agree to the monitoring. Could this be done?
I found this article Success Center, but it would allow us to change DPA to access other DBs if we wanted. I think they would be looking for something like setting up all permissions for DPA and we use those specific users in DPA so they feel confident we can't see other DBs.
On the same vein, does DPA need access to read the master DB? That could also cause us issues trying to get the permissions approved.
I'm not the expert but from my experience I don't think it is possible to restrict the access as you want.
Also if you have a look on the article "SQL Server permissions for DPA monitoring" Success Center then there are a couple of required privileges on MS SQL instance level.
Thank you Fabian,
Yeah, I saw that article and thought it might not be an option, but if we tell the client what permissions to create and restrict them to the one DB then maybe it would help. I knew it was a long shot, but seems like it might be impossible.
You might want to try adjusting the quickpoll_where_clause per the article link: Success Center
You can limit the quickpoll to just grab wait data for one database. Keep permissions the same though as DPA will need access to DMVs still.
All charts and other polls are driven by the QP, so limiting at that granular of a level should produce the results you are looking for.