Home Forums SQL Server 2012 SQL 2012 - General TEMPDB High avg write wait time(145ms) on Data files. Suspect Sharepoint might be the culprit any advice appreciated. RE: TEMPDB High avg write wait time(145ms) on Data files. Suspect Sharepoint might be the culprit any advice appreciated.

  • 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