most dbcc commands will use multiple processors.

write a rubbish view or query that forces a parallel plan - monitor processor use.

write a number of heavy cursor based inserts/updates - run...

I've two thoughts - there are some procs which register and deregister extended proc calls.

Why are you changing dll's if you think processes are running? If you're worried about that...

at a rough guess I'd say permissions.

use remote procedure calls via linked server enabled for rpc calls only. Check out BOL

Clusters are not too bad as long as you ALWAYS remember to administer the sql server in cluster administrator. NEVER try stopping or starting the sql/agent service other than in...

Performance tuning is all about establishing baselines and trending statistics so that you can evaluate and diagnose performance.

Best practices should establish  regular maintenence routines and processes to optimise the database(s)...

Question is too vague. If you're inferring parallel threads causing multiple spids which block the same user then search the forums , under parallelism, as it's been listed far too...

Hi John

Normally you'd set tempdb on its own array because it has a lot of heavy useage, I monitor the throughput on all my databases so if tempdb is doing...

why don't you modify your script to take account of multiple files?

It's the process of attempting to resolve the question that is of interest to the interviewer not the answer.You wouldn't believe how hard it can be to lead someone to...

very strange - you could use perfmon/task manager to figure out what is using ther page file.

I usually try to place the page file on a fast drive . I...

There's no magic wand to wave for index tuning - I make most of my living performance tuning applications and servers. Ultimately each problem query needs attention, it may take...

I'm fortunate in as much as I usually only get to pose the technical questions - senior managers do the rest. As I usually work within production environments I have...

ps .. restart sql service.

should be easy to see what's happening, run up a perfmon to check. There should be no, well almost, paging at all on a sql server.

There should be some free...