]
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
*** 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 with spotty,
intermittent performance by increasing my fast and list threads from 5
to 30. That did nothing. I still have the same problem.
The issue is most
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
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 with spotty,
intermittent performance by increasing my fast and list threads from 5
to 30
(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
19 matches
Mail list logo
