Well....max parallelism of 1 simply means that only one cpu will work on any given query....which of course means that if a query takes 10 seconds to retrieve....with only 1 cpu, it'll stay at 10...with that set to 2, it'll be 5, etc. If your DBA's not willing to budge, and your indexes are fine, then there is nothing more to do :)
I'm not sure what to say about the central config.... On Wed, Aug 21, 2019 at 12:16 PM Reiser, John J <[email protected]> wrote: > LJ, > > That’s my problem. For some reason I cannot get the centralized config > form to accept any new plugins. > > I’ve had nothing but trouble with this install and my support contract is > in limbo while the PO gets corrected. > > We have terrible performance and a DB team who will not entertain a > settings change recommended in a troubleshooting guide I found on BMC’s > website. > > Has to do with Cost Threshold of Parallelism and the Max Degree of > Parallelism. > > We have it set at Cost = 5 and Max degrees =1. That 1 pretty much makes > the Cost setting useless to the MS SQL server. > > But, hey, you know, the DBA knows exactly what should be done even if the > vendor specified something else to try. > > Sorry for the rant. I’ve been fighting this for 3 weeks now. > > > > > > Thank you, > > --- > John J. Reiser > Building 760-J202 > Remedy AR System Developer > > Senior Software Development Analyst > Lockheed Martin - RMS Moorestown Region > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > > *From:* ARSList <[email protected]> *On Behalf Of *LJ LongWing > *Sent:* Wednesday, August 21, 2019 11:32 AM > *To:* ARSList <[email protected]> > *Subject:* EXTERNAL: Re: ARS 9.1.06 aka 18.08 Centralized Configuration > of PLUGINS > > > > John, > > when I add it to the pluginsvr_config.xml, it adds it to the central > config...if it's not, then there are problems. You should be able to add > it through the central config as well, so that the two are in sync. > > > > On Wed, Aug 21, 2019 at 6:48 AM Reiser, John J <[email protected]> > wrote: > > Hey Listers, > Has anyone figured out how to manage your plugins with the centralized > configuration forms? > If you add something to pluginsvr_config.xml it doesn't show up in the > centralized form and if you make a change to a plugin in the Centralized > Configuration Generic UI it rewrites the pluginsvr_config.xml and wipes out > what you added there. > I had one of the Report plugins get dropped from the pluginSet so I > corrected the labels in the Configuration Generic UI form. Then the Restful > API from APL Remedy (Thanks LJ) stopped working. > When I check the pluginsvr_config.xml the Restful Plugin values were > removed from the file. I added them and sometime overnight the plugin > started working again. But it was not incorporated into the Plugins > Configuration form. It's working by being in the pluginsvr_config.xml file > but if something else updates the centralized form I'm afraid it will > remove the Restful Plugin entries again. > > Side question: Has anyone setup Restful API in the centralized > Configuration form with any success? > > > Thank you, > --- > John J. Reiser > Building 760-J202 > Remedy AR System Developer > Senior Software Development Analyst > Lockheed Martin - RMS Moorestown Region > The star that burns twice as bright burns half as long. > Pay close attention and be illuminated by its brilliance. - paraphrased by > me > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
