• Hi Ron,

    Here is the output of that T-SQL query:

    Object_Name Counter_Name Instance_Name cntr_Value cntr_type

    SQLServer:Buffer Manager Buffer cache hit ratio 2676 537003008

    SQLServer:Buffer Manager Buffer cache hit ratio base 26801073939459

    SQLServer:Buffer Manager Page lookups/sec -2025620116272696320

    etc.......

    I think I was looking for the list of deprecated features that are in my current sql 2000 environment and needs to be modified while going to sql 2008 version

    Thanks & Regards