June 26, 2015 at 11:16 am
Using SSMS 2012, we are experiencing extremely slow response times when opening SQL job steps to edit and also deploying SSIS Pkg's. Sysadmins have no problem. Users in the ssis_admin role have no problem. It's the rest of the users who have issues.
June 26, 2015 at 11:26 am
Our resolution included:
SSMS 2012 Opening a Job step in SSMS 2012 is extremely slow… (30 sec’s to 2 mins)
· Create new role -- do NOT assign any permissions to this role!!
USE [SSISDB]
GO
CREATE ROLE [ssis_regionadmin]
GO
· Modify your existing Security Logins permissions and add to new role: ssis_regionadmin
· Alter the following 21 views to include an additional predicate:
OR (IS_MEMBER('ssis_admin') = 1)
OR (IS_SRVROLEMEMBER('sysadmin') = 1)
becomes:
OR (IS_MEMBER('ssis_admin') = 1)
OR (IS_MEMBER('ssis_regionadmin') = 1) --<< NEW predicate
OR (IS_SRVROLEMEMBER('sysadmin') = 1)
USE [SSISDB]
GO
ALTER VIEW [internal].[execution_info]
ALTER VIEW [catalog].[validations]
ALTER VIEW [catalog].[projects]
ALTER VIEW [catalog].[packages]
ALTER VIEW [catalog].[operations]
ALTER VIEW [catalog].[operation_messages]
ALTER VIEW [catalog].[object_versions]
ALTER VIEW [catalog].[object_parameters]
ALTER VIEW [catalog].[folders]
ALTER VIEW [catalog].[extended_operation_info]
ALTER VIEW [catalog].[explicit_object_permissions]
ALTER VIEW [catalog].[execution_property_override_values]
ALTER VIEW [catalog].[execution_parameter_values]
ALTER VIEW [catalog].[execution_data_taps]
ALTER VIEW [catalog].[execution_data_statistics]
ALTER VIEW [catalog].[execution_component_phases]
ALTER VIEW [catalog].[executables]
ALTER VIEW [catalog].[event_message_context]
ALTER VIEW [catalog].[environments]
ALTER VIEW [catalog].[environment_variables]
ALTER VIEW [catalog].[environment_references]
· Re-test your edit of job step AND deployment of packages to SSISDB
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply