Ask A Question

View Question

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

Answer Question