R

Hi,

I am using Sql Server 2005 64bit on a quad processor server with 6GB memory. When I run a some TSQL that uses a cusor the average processor never goes too much above 25%. Memory using is about 300-400K for sql server.

Using perfmon it appears the disk queue length is 0 (or very close to it), can anyone suggest some perfcounters that would help me identify why my sql box isn't flying?

Thanks for your help

Graham

I highly recommend you read this excellent whitepaper.
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx