I'm positive I'm not the first to ask this, but I spent about 20 minutes looking for the answer must have lost my ability to search today...
Can someone point me to instructions on how to filter DPA dashboards by username that's running the SQL? I don't want to exclude stuff from the normal view, I just want to be able to zoom in on what a particular user is running.
What database engine are you looking at? SQL/Oracle/etc.?
If SQL, then when you are in an instance, you can filter a couple of ways:
Users running SQL against a specific database:
If you don't want to specify a database, then skip the click on databases tab - skip to go into a day, then interval to 1 day, click in and now look at DB Users tab.
Edit: Yes I'm in SQL Server.
Admin has already filtered my view to the DB for our team, but basically I like the way I can drill down by time slice to the sql id from the normal tabs, but I don't like the way it drills down from the User tab. It isn't the same. What I want is to see the main normal dashboards, but have them filtered to only show sql being ran by a specific user. So I can zoom in and monitor the performance of my stuff, and other team members can get in and check out their stuff.
Beyond the day view, I don't believe you can filter the timeslice view like you want to (basically by selecting one of the elements in any of the dimensional tabs across the top). It would be a good feature request though!
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. Learn more today by joining now.