Wait Stats

When a reqeust is made to sql server that isn’t immediately served a wait state occurs.  Sql Server tracks these waits for your viewing pleasure.  Query the following:

select * from sys.dm_os_wait_stats
order by wait_time_ms desc

wait_type is the name of the wait type.   (click here for explanations)
waiting_tasks_count: count of times it occurred
wiat_time_ms: total time in milliseconds
max_wait_time_ms: the maximum time this wait occurred
signal_wait_time: difference between when it started and when it ended

This gives you a good snapshot of what is going on and what is dragging your server through the mud.  It’s a starting point for what to fine-tune.