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


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)