Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Otter Database performance using roles as nested containers
-
Hello, I have been using multiple roles that are gathered to one role that I assign to each server as needed. I have two roles that are assigned to each server, one with about 30 roles and another with 15 roles. I do not want to assign these roles to each server individually. Over time, the performance has been getting worse. I have started performance troubleshooting, and have not found any issues (Checked usual Captain Obvious stuff), so I engaged a member of our SQL Support staff. After running a SQL trace, we saw this being executed that was taking between 3-12 seconds a piece. It is called "exec ServerRoles_GetServerRoles " in SQL Server Profiler. Is there a way to optimize this so it does not use excessive CPU? Thanks!
Product: Otter
Version: 2.1.1
-
Can you share your infrastructure configuration with us? Admin > Infrastructure > Export
Feel free to submit this in a ticket, because then it will be secure and it won't need to be public.
With this, we will be able to review and attempt to fix the stored proc.
-
Ticket is submitted along with additional information
