You can also look at SET STATISTICS IO ON and see the reads and writes that are required.

What about a delay between the start of execution? Or call 1 proc and have it fire the other 2?

I think Profiler is the best way if you suspect a problem. If you are trying to troubleshoot, get the user to open another connection and see what comes through....

This is an incredibly broad question. I think you should read the articles on this site as well as keep an eye on the active posts in this forum to...

They can be, depending on how it's posted.

Apologies for the mistake. And yes, these things get through QA sometimes. I didn't catch the different table names because I cut and paste the query into QA, create the...

There isn't a good way. You can run sp_who2 on each system every 5 minutes and get a high water mark for connections. That would tell you the per server...

Express is replacing MSDE. Here's the datasheet: http://www.microsoft.com/sql/express/

Logs are usually in /program files/microsoft sql server/msql/logs. check there or the Windows Event log for details on why it won't start.

http://www.sqlservercentral.com/columnists/bknight/stepbystepclustering.asp

Not sure what the criteria is, but I've used underscores with no issues. Tried running it all together, no separators?

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp

Links to the other 3 parts.

If 8000 users access the servers, you'd license on a per seat basis and license 8000 users. The CAL is by user, not workstation or app.

If you have significantly less...

Beware that the values are not necessarily unqiue. If you delete a partial range and reset the identity values, then you may or may not overwrite other values. Also, if...

What do you mean calculate performance?