TEMPDB optimizations for SQL Server 2005 - Help your XML Datatype performance!

  • Article

https://blogs.msdn.com/weix/archive/2005/09/13/464907.aspx

Wei mentions a couple of optimizations that can be made for TEMPDB heavy applications.  Since XML datatype uses TEMPDB heavily for LOB storage, I recommend checking this out and instrumenting these if you are seeing some performance issues.