Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-25 Thread Michaud, Christopher W Mr CTR USA MEDCOM USAMITC
Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often

Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-24 Thread Michaud, Christopher W Mr CTR USA MEDCOM USAMITC
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-

Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance (UNCLASSIFIED)

2008-11-24 Thread Michaud, Christopher W Mr CTR USA MEDCOM USAMITC
: 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