We are currently experiencing a problem where CPU is up and down but running a steady 80%. One application running WebSphere, so the jdbc connections call and use dynamic stored procedures. Initially the stored procedures were coming and going faster than I could count...but I have that fixed and recompile are now 0. RPC complete times are usually around 100 occasionally 300, all being way to high. 7 millisecond response times when invoked hundreds of times equate to a user experience of 20-30 seconds. Can't run profiler traces through index optimizer as it can't read the stored procedures and make suggestions. Nightly reindex, and 100% sample for stat updates Buffer Cache hit ratio is constant > 99.8% for the past 4 days. Disk Queue is 0 for all disks. Microsoft SQL Server 2000 - 8.00.2187 (Intel X86) , running windows 2003 enterprise 4gig ram, pae, awe and 3GB Any help would be great...just as an example here's a query... SELECT PARENTIDKEY,CONTRACTKEY,COMPANYKEY,BACKENDKEY,RELATIONKEY,ORIGINATINGOBJECTTYPE, RELATEDOBJECTTYPE,RELATIONROLECODE,RELATIONDESCRIPTION,NAMEFROMRELATEDOBJECT,KEYFROMRELATEDOBJECT, STARTDATE,ENDDATE,DEPENDENT,INTERESTPERCENT,VOLUMESHAREPCT,SEQUENCE,RELATEDREFID,RELATEDREFIDTYPE, PRIMARYADDRESSID,PRIMARYPHONETOCALLID,PRIMARYEMAILID,BENEFICIARYSEQNUM,BENEFICIARYSHAREMETHOD, BENEFICIARYCOMMONDISASTERPERIO,BENEFICIARYDESIGNATION,IRREVOKABLEIND,DURATION,ID,ORIGINATINGOBJECTID, RELATEDOBJECTID,PARTICIPANTID,SECONDARYADDRESSID,DATAREP FROM "RELATION" WHERE PARENTIDKEY = @P1 AND CONTRACTKEY = @P2 AND COMPANYKEY = @P3 AND BACKENDKEY = @P4 This query has the following from profiler...Duration 219, CPU 15, and reads 22492 Relation table has a measly 406400 rows and a clustered index on parent, contract, company, backend, and id Any help would be fantastic!