Re: Performance Issues - Multitenancy

2016-11-28 Thread Brian Pancia
, Doug <doug_muel...@bmc.com> Sent: Tuesday, November 22, 2016 12:50 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues - Multitenancy ** Just some background to help hereā€¦. Implementing an effective row level security model is actually quite an involved operation. It is about securi

Re: Performance Issues - Multitenancy

2016-11-22 Thread Mueller, Doug
a Sent: Monday, November 21, 2016 8:17 AM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues - Multitenancy ** Shawn, Thanks. That ended up being the fix. Brian From: Action Request System discussion list(ARSList) <arslist@ARSLIST.ORG<ma

Re: Performance Issues - Multitenancy

2016-11-21 Thread Brian Pancia
.ORG Subject: Re: Performance Issues - Multitenancy ** We had a similar issue and were provided the following by BMC: The Engineer assisting us with this issue has reviewed the information provided and agrees the query we see taking to complete are running row level access. He would like

Re: Performance Issues - Multitenancy

2016-11-18 Thread Shawn Scutchings
) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Friday, November 18, 2016 1:03 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues - Multitenancy ** Brian, Turn on SQL Logging and perform the same search between the two different users and compare the SQL, maybe even provide

Re: Performance Issues - Multitenancy

2016-11-18 Thread LJ LongWing
Brian, Turn on SQL Logging and perform the same search between the two different users and compare the SQL, maybe even provide the sql here for analysisthe 'slow vs fast' queries should be fairly obvious what's causing the difference. On Fri, Nov 18, 2016 at 11:24 AM, Brian Pancia

Re: Performance Issues - Multitenancy

2016-11-18 Thread Roger Justice
2016 1:25 pm Subject: Performance Issues - Multitenancy ** We are running into some serious performance issues with multitenancy. We're on BMC ITSM 9.1 SP1 and SQL Server 2012. If I do a search on a form like CTM:People with an account that has unrestricted access the search comes back in about

Performance Issues - Multitenancy

2016-11-18 Thread Brian Pancia
We are running into some serious performance issues with multitenancy. We're on BMC ITSM 9.1 SP1 and SQL Server 2012. If I do a search on a form like CTM:People with an account that has unrestricted access the search comes back in about 2-3 seconds for 13 records. That same search with a