How to improve performance of SQL Server in a Very Large DataBase

Good Afternoon,

I would like to know how can i improve the performance of sql server2000.

But i can't improve the hardware because the enterprise i work doesnt want to spend money. And the tables exits by default(with indexs) because it's an ERP.

There is 21 DB with nearly 3000 tables by DB.

There is any way to optimize and improve the performance os Sql Server????

Thank you a lot for your time

Miguel Bártolo

PS - Someone said to me that putting logs files in a diferent directory could raise the performance is this true???????

The best thing to do is analyse your indexes and make sure that the fields that you are searching on are indexed correctly and maybe fields that are not searched for that much but are indexed are no indexed anymore. Also look at the SQL queries, if you are using a lot of functions in the SQL see if they can be done via code easily. See which is more efficient. Also the more primary keys in a table the slower it goes, i have seen some DB apps where they have quad-primary keys and they were running really slow.