this is a common problem and you have various methods to resolve this.

1) stop log shipping - put database into simple- reindex - restart log shipping

2) intersperse your indexing with...

you'll find it's not easy to profile against tempdb. Most likely it's index rebuilds and checkdb commands. Or you have lots of processes creating and populating tempdb. One extreme way...

sql mag has, in my opinion, declined in usefullness of late. I'd probably say this site, msdn and technet are better. The Technet magazine has some pretty good stuff on...

you need to be very careful with single user mode - you should be able to stop and restart the service from windows services if no other way.

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2007/07/16/more-tom-davidson-magic.aspx

the docs are also on my website http://www.grumpyolddba.co.uk

I'm sure sql central also has loads of scripts for sorting out blocking as it's a fairly common issue

think I covered this on my blog , but the disk counters I use, from perfmon, are :-

avg disk sec/transfer, avg disk sec/write, avg disk sec/read, disk idle time %,...

sorry, I hate to dispute other posts but:- Disk Queue doesn't apply when connected to a SAN or NAS - use io completion time - a much better counter.

Pages per...

I've some info on my blog here

http://sqlblogcasts.com/blogs/grumpyolddba/archive/tags/Trending+and+Statistics/default.aspx

service pack 3 is on its way, this year, but you should continue to apply the cumulative rollups - we could have a poll on which CU will be the...

transactions are only a measure you use to compare workload, the actual figures are pretty meaningless. You might find batches and/or compilations a slightly better measure. I use databases -...

you really need other trace flags, depending upon what i want to do I use 1204,1205 and 1206. 1204 isn't sufficient to get all the data.

Jeff you are so right!

that's always been my experience too, it's still best practice to qualify objects within procs ( with owner/schema )

this is pretty well known - remote queries can do some horrible things - Alan Mitchell wrote an excellent paper on this, he had the same problem. Can't remember...

It doesn't work like that sadly. In general terms the processor clock speed will impact execution time, so a single threaded call to a 2.2Ghz quad will run slower than...