1
kudos
spam Kudos Remove

SQL Server TEMPDB - A key factor in monitoring and keeping up the performance!

published 1026 days, 12 hours, 57 minutes ago posted by sasa 1030 days, 14 hours, 59 minutes ago
Saturday, August 01, 2009 4:30:06 PM GMT Tuesday, July 28, 2009 2:28:28 PM GMT

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of the system-processing load may be taken up with autogrowing tempdb to the size required to support the workload every time you restart the instance of SQL Server. So if the SQL Server instance TEMPD is sprea...

category: Management | clicked: 3 | | source: sqlserver-qa.net | show counter code
tags: Monitoring, Performance

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

To post your comment please login or signup