this email
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ali A. Musa
Sent: Wednesday, 27 March 2013 4:38 PM
To: arslist@ARSLIST.ORG
Subject: Re: Long running query
Check the column included in where and ensured they are inde
)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Rajesh
Sent: Wednesday, March 27, 2013 1:09 AM
To: arslist@ARSLIST.ORG
Subject: Long running query
Have seen a post similar this, but since i could not find this out i am posting
Have seen a post similar this, but since i could not find this out i am posting
this again.
We are facing performance issue and while going throught the DB log we can see
following query run and it is taking log time to execute
Allow unqualified search is checked
T1141 :- SLM measurement and t
unstat customer can implement
> indexes.
>
> ** **
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] *On Behalf Of *Ashtaputre, Anay
> *Sent:* Wednesday, January 09, 2013 1:54 PM
>
> *To:* arslist@ARSLI
)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ashtaputre, Anay
Sent: Wednesday, January 09, 2013 1:54 PM
To: arslist@ARSLIST.ORG
Subject: Re: Long Running Query
**
Following Defect & Knowledge article can be referred -
SW00443560
KA380785
Following fields will need to be indexed -
'C23009'
)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Vishal Navale
Sent: Wednesday, January 09, 2013 1:13 AM
To: arslist@ARSLIST.ORG
Subject: Re: Long Running Query
**
Thanks Rick for the answer.
Modify the query and indexing - do you have some suggestions for how to do this.
Thanks
Vishal
Thanks Rick for the answer.
Modify the query and indexing - do you have some suggestions for how to do
this.
Thanks
Vishal
On Tue, Jan 8, 2013 at 2:00 PM, Rick Cook wrote:
> modifying the query,
___
UNSUBSCRIBE or a
My guess would be that it is refreshing the Overview Console. If you have
lots (like 100,000+) being returned, this constantly refreshing table will
bog your system down. You might look at reducing table sizes, modifying
the query, adjusting indexes, or all three.
Rick
On Tue, Jan 8, 2013 at 1
Hi,
I am seen below long runnnig query on Remedy Server which causes
performance issues. Does anyone knows what is his query?
Thanks
Vishal
895060 SQL 218104 Prv:390680 390680 Remedy Application Service Tue Jan
08 2013 09:20:30.1500
SELECT TOP 2001
T1916.C1,C100161,C301626500,C1
Just an update on this old thread, the 'Large-Result-Logging-Threshold'
setting has finally been added to the product docs in 7.6.04 Optimizing and
Troubleshooting Guide starting on pg. 100.
Jason
On Wed, Aug 25, 2010 at 10:32 AM, Jason Miller wrote:
> I was going to mention that we should start
Thank you.
On Wed, Aug 25, 2010 at 1:32 PM, Jason Miller wrote:
> ** I was going to mention that we should start adding these things to the
> Undocumented Config Settings section on ARSWiki (and was going to add it)...
> and what do you know? It is already there!
>
> http://arswiki.org/wiki/Undo
I was going to mention that we should start adding these things to the
Undocumented Config Settings section on ARSWiki (and was going to add it)...
and what do you know? It is already there!
http://arswiki.org/wiki/Undocumented_Config_Settings
Jason
On Wed, Aug 25, 2010 at 10:10 AM, Jason Mille
Hi Frank,
Add 'Large-Result-Logging-Threshold: 100' to the ar.cfg/ar.conf file.
I *think* the 100 is bytes of memory. NOTE: we added an extra zero from
Mark Walter's suggestion (POST: "ARS 7.1 server group issue" from 2/25/09).
You will end up with something like this in the arthread.lo
I remember seeing a posting to the list within the last few months about a
ARS 6.3 setting in the conf file that would allow the logging of long
running queries. I believe this is an undocumented feature.
I have tried searching the archives but am not able to find the email.
Anybody have or rememb
14 matches
Mail list logo