Hi,
I would verify the indexes that are present on Application Pending form to
ensure that the field 'C501' has an index.
Also, you may want to check the number of records in this form and delete
entries that are not required (by default, processed records should be removed).
_
My first question is, Which system is having the cpu hit 100%? If it is
the db then indexes should help. If it is the application server then you
have either too much data being sent back or too much workflow firing on
all the records.
I would first check to see how many records you have in the
Brian,
If you look into docs, the N being outside of the ' indicates that the
string is going to be an nvarcharone thing this indicates to me is that
the query is NOT Remedy generated, but maybe a direct sql statement or
somethingbut I'm not 100% sure.
On Wed, Jan 22, 2014 at 6:48 AM,
Hi all,
LJ, ARS absolutely WILL generate nvarchar strings (using the N prefix) on
unicode servers, though I have no idea if this particular SQL is being
generated by ARS or not.
On my 8.1 dev box, Application Pending form has no defined indexes, so
there's only the clustered index on the request
Charlie,
Thank for that piece, I've never used a Unicode Remedy install, so that
would be why I haven't seen that nomenclature used by Remedy itself :)
On Wed, Jan 22, 2014 at 8:30 AM, Charlie Lotridge lotri...@mcs-sf.comwrote:
**
Hi all,
LJ, ARS absolutely WILL generate nvarchar strings
://www.missingpiecessoftware.com/
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Charlie Lotridge
Sent: 22 January 2014 15:30
To: arslist@ARSLIST.ORG
Subject: Re: CPU utilization sometimes goes up to 100%
**
Hi all,
LJ, ARS absolutely WILL generate
6 matches
Mail list logo