tricky! but along side your missing indexes are also worst queries, you should be able to marry up worst queries to missing indexes - you'll know the table(s) at least....

you'd likely have an issue trying to centralise, especially if you have one out of a 100 who want's to be different!

scripting is your friend for this. You could look...

or you create a script which runs through all your databases every night putting them to what you want.

a certain amount of blocking usually occurs on a server from time to time and it is a matter of management and such which dictates what is acceptable. You're looking...

you shouldn't. it's best to leave the registry alone.

sqlio and sqlstress and other such tools only apply theoretical tests onto the disk subsystem - they have little real relation to application use, and if you don't understand the...

I'm still looking into the exact reasoning behind all this and very interesting it is getting too

It seems that with 64bit you can allocate more memory than you...

ah case sensitivity as well - I covered this on a presentation I did but ti's not really something I can drop into a post and I'd need to do...

it's not that so much as the fact that many of the other internal memory pool sizes have been increased. I can't find the kb articles just now, but I'll...

ah yes - now open a can of worms! You may have a step waiting on a console type session/response, you could be waiting on a connection response, e.g. http://ftp...

I have queries which will extract highest cpu queries from the dmvs I'll perhaps see if I can dig them out.

There is an answer of course - the sql 2005...

the problem is that I've not used sql 64 bit standard, only enterprise. There are config settings to w2k3 which affect system cache, this is either 512mb or 1gb,...

we've had a number of discussions about setting memory for 64bit sql server - all I'll say is that you MUST set a maximum memory size for sql to use...

I agree - get a DBA. As you're asking these questions even if we suggested tools/methods ( most are available one way or another for what you ask ) you'd...

I usually find high cpu is down to poor queries and usually high i/o go hand in hand with high cpu. profile for high i/o queries and clock the...