Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

wish back the performance on custom RBAC web reports - fix performance problem on TVF(fn_rbac_R_System_Valid)

I have build many custom RBAC web reports, cince moving to CB massive performance problems appear on this reports.

As part of a man day analysys i noticed that the most of them has a validation join to the TableValuedFunction "fn_rbac_R_System_Valid".

And finaly 6 hours of searching i found the bug that produces this performance Problem in the function named above.

Attached are the orginal and my improved DropAndRecreate.SQL Files.

The following sql query needs - executed with my own UserSIDs - needs more than 5 minutes without, and only 2 secounds with the improvement:

SELECT Netbios_Name0 FROM dbo.fn_rbac_R_System_Valid(@UserSIDs);

4 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Torsten Hoffmann shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base