You have two options with 8Gb of ram - I assume you have enterprise version as extra memory can't be used with std edition.

set the /3gb switch + /PAE +...

sorry just noticed you're using std edition so there's not much you improve memory wise. I never use the cache hit ratios - check page life expectancy that'll give a...

DO NOT increase worker threads - guessing is not a good reason - use umsstats to see if your workers are waiting, my guess is you'll have a bottleneck elsewhere.

try reading the counter from sysperfinfo table ( in master ) You'll need to check out a KB to find out how to use the figures as they're not quite...

I measure throughput on tempdb as well as other databases - see this link on counters to use etc. It may help.

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

I figure if tempdb has more throughput then the...

a gig sounds good but i expect that's also your network bandwidth and I bet at times response may not be as good as you hope! Mirroring is very simlar...

never understood why anyone would recommend raid 5 for a backup which is a write intensive operation so raid 5 would be the absolute worst choice ( well actually...

you should be aware, as we're talking about modes, that merely changing the mode to 9.0 is not always the same as creating the database in 2005 native.

I was never...

I seem to have been posting somewhat terse replies today! I wonder if you really read what you posted? You've going to set up a high availability link, untested and...

sounds like you have a client config issue - either enable your server to use named pipes or force your client to use tcp/ip. I've had problems when limiting...

at small sizes indexes and tables are usually not worth rebuilding and if you do the analysis results can be strange. I usually don't bother with anythign under 8 pages...

it's not really considered good practice to write views in this manner, you should order the results from the view in the select against the view.

That said the view will...

This isn't really about performance, it's about training - if you need to ask this type of question then you shouldn't be writing applications such as you describe. I'd suggest...

you always worry when you read posts like this, I had a serious problem with a major software release where developers had picked up something on the web ( which...

we're not mixing minutes and seconds here are we? I've been running systems which do over 350 transactions/sec for many years, I know that doesn't get near the tpc benchmark...