Performance and tuning in SQL Server 2000

I have 2 table around 60 million records and grow substantially. The table i
s
created with non-clustered index (int datatype). Jobs are scheduled and
running in the background. Is there any way to see in the profiler what
queries are being run. I could not see the queries as the jobs are running.
How do i need to optimize the query in case i get the query.If you are using SQL Server 2005, you can save a .trc file (started before
the job rns and ending afterward) and give it to the database engine tuning
advisor.
In SQL Server 2000, you can do something similar with the index tuning
wizard.
A
"Sathya" <Sathya@.discussions.microsoft.com> wrote in message
news:558C10E8-7555-475C-852D-BF71685618F4@.microsoft.com...
>I have 2 table around 60 million records and grow substantially. The table
>is
> created with non-clustered index (int datatype). Jobs are scheduled and
> running in the background. Is there any way to see in the profiler what
> queries are being run. I could not see the queries as the jobs are
> running.
> How do i need to optimize the query in case i get the query.