March 4, 2004 at 7:51 am
We have extensive use of the remedy Action Request System which runs on a SQL 2k background. Remedy is supposed to manage the indexes itself, however looking at the queries that get run it does not do a very good job, for example clustered indexes just don't seem to be something that it has ever heard of.
Does anyone have experience with changing the indexes on the underlying ARSystem tables? I want to know if there is potential to cause problems further down the road by doing this.
March 5, 2004 at 11:35 am
We have got Peregrine ServiceCenter.
From the principle it's the same. It is ganarating the indexes itself..
As it was quite poorle defined I've put some additional indexes on and have removed some unnecessairy one.
It worked fine for me without any problem.
Bye
Gabor
March 5, 2004 at 11:55 am
We use Remedy here too but haven't experienced any performance issues yet. However, before making any changes to the tables you may want to review your service contract if you have one. Sometimes if you alter a 3rd party product, the vendor won't continue to support it.
Also, there are admin functions within the application that drops / creates objects (at least in version 4.0.3 that we're using). I placed a trigger on a table that kept disappearing and found out that the application admin was making changes. Instead of altering the table the GUI dropped / recreated it (copied data etc.). Anyway, if you add pk's or indexes they might not stay 🙂
Linda
March 5, 2004 at 12:14 pm
So I should probably create the indexes and have a job go out once a week or so and confirm that they are still there?
My main concern is to place some clustered indexes on there, and also add a couple of indexes to some searchable fields.
March 5, 2004 at 12:27 pm
Actually, that's what I did too--create a job to look for my trigger. If your application is pretty much done with modifications and the indexes help performance, I think you should definitely go for it.
March 5, 2004 at 12:54 pm
We don't do much in the way of schema changes through the Remedy tool, and when we do (because we replicate a lot of the data) I am around when we do so I should be able to just take care of those indexes at the time.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply