Your tempdb size may be too small, probably it is expanding dynamically causing IO waits. You should experiment to bigger tempdb.
http://databaseandstorage.blogspot.com http://gotodba.weebly.com
Forum Rules