Here are the basic definitions.
Full Scans/sec – Number of table or index scans done per second.
Checkpoint pages/sec – Number of data pages written to disk per second during the checkpoint process
Transactions/sec – Number of active transactions per second in the database
User Connections – Number of sessions currently active in the server
Average Wait Time (ms) = Average amount of time sessions are waiting for resources to become available (locks, disk, cpu, etc)
Lock Waits/sec – The number of locks which are initialed per second
Number of Deadlocks/sec – The number of deadlocks per second
Target Server Memory(KB) – The maximum amount of memory the SQL Server can use.
Total Server Memory (KB) – The total amount of memory the server has installed
Batch Requests/sec – The number of baches being executed per second against the SQL Server instance.
Here are some numbers to keep in mind.
Full Scans/sec – As low as possible. The closer to 0 the better.
Checkpoint pages/sec – This is really out of your control.
Transactions/sec – This is really out of your control
User Connections – This is really out of your control
Average Wait Time (ms) – You want this as low as possible. The longer this is the longer your queries take to run
Lock Waits/sec – You want this as low as possible. The longer this is the longer your queries take to run
Number of Deadlocks/sec – This should be 0.
Target Server Memory(KB) – How ever much memory you set SQL Server for. About 75% of physical memory.
Total Server Memory (KB) – This is how much memory is installed.
Batch Requests/sec – This is really out of your control