Oh yeah..forgot. We are using stored procs and huge views that are not indexed.

Okay, I'll take a look at these suggestions and get back to you.

Also, I ran the trace while while running perfom monitor and came up with 3 queries that took...

Hi guys,

    well I did some research and this is what I have:

1 SCSI controller in use

2 CPUs (In task manager, 4 CPUs are shown for the history)

4 Gig of...

Thank you so much!  THis helps a great deal.  I found info about everything on profiler but this. So you are right.  It is VERY hidden.

When the CPU is at 80% it's SQL server using it. There is nothing else running on the box.

Disk quwuing goes up and down but never stays up for...