Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.