1
kudos
spam Kudos Remove

SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?
published 452 days, 4 hours, 34 minutes ago posted by sasa 461 days, 6 hours, 5 minutes ago
Friday, February 25, 2011 6:59:02 AM GMT Wednesday, February 16, 2011 5:28:05 AM GMT
SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?
TEMPDB - as it sounds it is a temporary database in SQL Server, that has undergone number of changes from 2005 version onwards. As you may be aware that tempdb is used for various purpsoes such as storing intermediate results, sorting and keepng row versions, unless a good I/O & CPU subsystem is supporting the cause. Now and then I see many questions in Forums stating the performance is hampered and root cause was tempdb. Just back to basics that TEMPDB is similar to a user database to store...(read more)
category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code
tags: benchmarking, Best Practices, contention, dmvs, extent, performance monitoring, SQL Server, storage, system, tempdb, TSQL

No comments yet, be the first one to post comment.

To post your comment please login or signup