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


http://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.

Comments (0)