>I am running a 3-tier VFP/Transaction Server/SQL Server 6.5 application using Windows NT 4.0 on all four tiers. It seems that some queries (and even some pretty simple ones) tap the CPU on the Transaction Server at 100%.

Bob, could you be a little more specific on how TS is configured. Does it run on all machines, or is it running on it's own machine, or on the SQL Server machine?