I'd say the first thing to do is try running a few queries with "set statistics io on" and "set statistics time on". Look at the Messages tab in Management Studio when you do that.
Here are a couple of examples:
set statistics time on
set statistics io on
select getdate()
set statistics time on
set statistics io on
declare @Date datetime
;with CTE (Number) as
(select row_number() over (order by t1.object_id)
from sys.all_objects t1
cross join sys.all_objects t2)
select @Date = dateadd(minute, number, '1/1/1900')
from CTE
You'll see messages about how much CPU time was used, how much total time was used, how many scans and reads were done any tables involved, etc.
Check the statistics on some of the more common queries in the databases you administer (assuming you have some).
Once you've seen those numbers, look up any parts that you don't understand specifically. Or ask about them here.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon