]
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
-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
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
.
Ideas?
Norm
-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
: 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
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
)
[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
list(ARSList)
[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
, 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
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
replication? In particular, are snapshots turned on?
Christopher Michaud
-Original Message-
, 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
: 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 (UNCLASSIFIED)
Classification: UNCLASSIFIED
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
35 matches
Mail list logo
