1. I have X4 Temdb Data files which matches to the actual cores (Not Hyper threaded).
2. Yes I have read that somewhere also yesterday during my hunt for some answers. I
did some trawling for suggested missing indexes on the sharepoint databases and there
were not many standout suggestions returned but regardless i will go through and create
some anyways and see if this gives an improvement. I think it makes sense in that if for
large search operations indexes are not present then I think sharepoint is forced to use
tempdb to help it to do a search. This is my best guess at the moement.
3. Ok thanks for the heads up, I will look at doing that to try and track down some of the
operations and see if any clues present themselves.
I appreciate your advice and feedback-ta