]
Im Auftrag von LJ Longwing
Gesendet: Donnerstag, 4. Dezember 2008 03:31
An: arslist@ARSLIST.ORG
Betreff: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
I completely agree that we are talking about a like statement on a wide table
that won't use an index with over 500K records
:[EMAIL PROTECTED]
On Behalf Of Martin, Conny
Sent: Thursday, December 04, 2008 2:03 AM
To: arslist@ARSLIST.ORG
Subject: AW: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
There is an option in ar.conf
Select-Query-Hint: NOLOCK
Documentation says:
The text to be used in a query hint
System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing
Sent: Wednesday, December 03, 2008 8:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
I completely agree that we are talking about a like statement on a wide
: AW: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
There is an option in ar.conf
Select-Query-Hint: NOLOCK
Documentation says:
The text to be used in a query hint (in the WITH clause of a SELECT
statement) when queries are supplied to SQL Server databases. This
parameter works
CIV USAF AFMC 96 CS/SCCE
Gesendet: Donnerstag, 4. Dezember 2008 15:17
An: arslist@ARSLIST.ORG
Betreff: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
*** ADDITIONAL THOUGHTS ***
So I was thinking about this last night on the drive home. Here is what I
believe is the anatomy
@ARSLIST.ORG
Subject: AW: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Hi Norm,
If you do a table scan on a huge table, then storage is the bottleneck. The
data must be read from disk and that's slow.
Kind Regards Conny
-Ursprüngliche Nachricht-
Von: Action Request System
, December 04, 2008 7:03 AM
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Thanks for the reply. I'm familiar with the FTS option, but unfortunately
it's not an option because of a) Cost b) The site is running 6.3 and cannot
upgrade (I don't think FTS
04, 2008 6:59 AM
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Thanks! Good article. I wasn't aware of the Select-Query-Hint: NOLOCK
option for the ar.cfg.
While I certainly don't doubt the power of Oracle, if Oracle doesn't lock
the table or row
-Original Message-
From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Sent: Tuesday, November 25, 2008 5:39 PM
To: 'arslist@ARSLIST.ORG'
Subject: RE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, a little bird (ahem...cough...Doug...cough) suggested I double up
my list and fast threads, which
Save Money. Live Better
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Wednesday, December 03, 2008 14:18
To: arslist@ARSLIST.ORG
Subject: UPDATE: Intermittent, Spotty ARS Performance
USAF AFMC 96
CS/SCCE
Sent: Wednesday, December 03, 2008 1:18 PM
To: arslist@ARSLIST.ORG
Subject: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
*** UPDATE ***
Well, it appears I don't have to toilet paper my own house after all.
As I reported below, I attempted to fix my problem
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Is there something going on with that table that locks it when someone
searches? Maybe it is as simple as changing the lockmode from table to
row?
Darrell Reading Systems Engineer
Phone 479.204.5739
[EMAIL
? Write better, smaller queries.
Damn.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Wednesday, December 03, 2008 2:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance
: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, it looks like I found it. Microsoft SQL handles lock escalation
dynamically.
The escalation can, well, escalate to a table lock. Here's Microsoft
article on the issue:
http://support.microsoft.com/kb/323630
I ran the Profiler, and sure enough
(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading
Sent: Wednesday, December 03, 2008 4:10 PM
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
I noticed that you can turn off the escalation and set the tables to
lock row. The problem
)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96
CS/SCCE
Sent: Wednesday, December 03, 2008 2:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, it looks like I found it. Microsoft SQL handles lock escalation
16:43
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
I'm told by my DBA that it's possible to write 'dirty' queries that
won't
lock the DB, but I haven't been able to figure out how to make Remedy
run
them...it's basically an appendage to the end
To: arslist@ARSLIST.ORG
Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
I'm told by my DBA that it's possible to write 'dirty' queries that
won't
lock the DB, but I haven't been able to figure out how to make Remedy
run
them...it's basically an appendage to the end of the sql
: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, that's called SQL injection, but that doesn't apply here, as Remedy
guards against it through parameterized statements.
In this case, the dirty query isn't really dirty, it's just inefficient.
That is, searching a massive diary
, November 24, 2008 8:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
**
Another thing could be your disk space getting full on the Remedy
server. We had that issue recently when one of the operation some user
would do would eventually timeout and would
on the
database to sift through all that garbage.
Norm
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza
Sent: Monday, November 24, 2008 8:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance
)
[mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore
Sent: Tuesday, November 25, 2008 8:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
**
Norm,
Perhaps you need to steal an idea from version 7 and make the worklogs a
parent-child relationship
: Tuesday, November 25, 2008 8:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Good suggestion...I'm pretty familiar with the new worklog model in
version 7 and its advantages and disadvantages. Unfortunately, that
entails a very large coding effort
basis.
Christopher Michaud
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Tuesday, November 25, 2008 8:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance
, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Tuesday, November 25, 2008 8:25 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Good suggestion...I'm pretty familiar with the new worklog model in
version 7 and its advantages and disadvantages. Unfortunately
Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Tuesday, November 25, 2008 11:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yeah, I've already considered that. I've already
] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96
CS/SCCE
Sent: Tuesday, November 25, 2008 9:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yeah, I've already considered that. I've already interviewed the people who
are the culprits and gotten
: Intermittent, Spotty ARS Performance (UNCLASSIFIED) (U)
UNCLASSIFIED
What about creating workflow to copy the final Work Log entry to the
Solution Description field?
Sandra Hennigan
OSD Enterprise Remedy Administrator
Office # 703-601-0789
Apparently, there is nothing that cannot happen today. Mark Twain
)
[mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L.
Sent: Tuesday, November 25, 2008 4:17 PM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
We had a similar problem recently. We found that an Active Link was
causing our problem. It was a newly created
paper my own house.
Norm
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L.
Sent: Tuesday, November 25, 2008 5:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Never
25, 2008 4:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, a little bird (ahem...cough...Doug...cough) suggested I double up my
list and fast threads, which I've done, and that seems -- at least on the
surface -- to have corrected the problem.
I
Hi everyone:
This problem has me perplexed.
At a site I support, the Remedy server inexplicably stops responding to
requests. It's very intermittent. It runs fine for awhile, then
seemingly without warning, it just hangs. Users attempting to log on
get stuck at the Setting server port
: Intermittent, Spotty ARS Performance
Hi everyone:
This problem has me perplexed.
At a site I support, the Remedy server inexplicably stops responding to
requests. It's very intermittent. It runs fine for awhile, then seemingly
without warning, it just hangs. Users attempting to log on get stuck
(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96
CS/SCCE
Sent: Monday, November 24, 2008 10:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance
**
Hi everyone:
This problem has me perplexed.
At a site I support, the Remedy server
1.4.2_14
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Meyer, Jennifer L
Sent: Monday, November 24, 2008 11:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance
**
What java version are you
An: arslist@ARSLIST.ORG
Betreff: Re: Intermittent, Spotty ARS Performance
**
I'm assuming there are no messages going into the arerror.log or
anything like that? How about the armonitor.log? Try turning on Thread
logging (very small output) and see if you can see anything happening
with threads
-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 11:03 AM
To: arslist@ARSLIST.ORG
Subject: Intermittent, Spotty ARS Performance
**
Hi everyone:
This problem has me perplexed
PROTECTED] On Behalf Of Martin, Conny
Sent: Monday, November 24, 2008 11:19 AM
To: arslist@ARSLIST.ORG
Subject: AW: Intermittent, Spotty ARS Performance
**
Hi Norm,
Can you log on with Remedy Administrator while the server ist not
responding?
Kind Regards Conny
Von
, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Norm,
You may want to look closer at the SQL side. Look for locks. Perhaps
someone querying a diary or un-indexed field. Also, are you using SQL
diary searches?
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR
USA MEDCOM USAMITC
Sent: Monday, November 24, 2008 11:20 AM
To: arslist@ARSLIST.ORG
Subject: Re: Intermittent, Spotty ARS Performance
: Monday, November 24, 2008 12:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance
OK, I'm pretty confident the problem was being caused by users
constantly searching the worklog diary field on a form with 200,000+
tickets. I was able to reproduce
WAS: Intermittent, Spotty ARS Performance
We prevent our users from searching the work log on production server
via an active link firing on search.
It's a given performance killer. They have to use the reporting server
to search the work log.
HTH,
Rootuja
discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE
Sent: Monday, November 24, 2008 3:39 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
How do you block searches done on the Advanced Query Bar
)
[mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C.
Sent: Monday, November 24, 2008 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Just turn off the advanced search option from the Form - Current View -
Properties - Menu Access menu
, Matthew C.
Sent: Monday, November 24, 2008 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Just turn off the advanced search option from the Form - Current View -
Properties - Menu Access menu.
-Matt
Matthew C. Gayford
Application Developer
Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC
96 CS/SCCE
Sent: Monday, November 24, 2008 2:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
No...can't do
Sent: Monday, November 24, 2008 1:19 PM
To: arslist@ARSLIST.ORG
Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance
OK, I'm pretty confident the problem was being caused by users constantly
searching the worklog diary field on a form with 200,000+ tickets. I was able
to reproduce
USAF AFMC 96 CS/SCCE [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Monday, November 24, 2008 12:58:53 PM
Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yes, that's my suspicion. I have a big suspicion that people are searching the
worklog diary field.
-Original Message
48 matches
Mail list logo