SQL Server tempdb database continues to grow after starting the VMware VirtualCenter Server service

Products

• VMware vCenter Server

Issue/Introduction

Symptoms:

• The SQL Server tempdb database continues to grow after starting a VMware VirtualCenter Server service.
• tempdb grows uncontrollably or fills up.
• The SQL Server fails.

Environment

VMware vCenter Server 5.0.x
VMware vCenter Server 4.1.x
VMware vCenter Server 4.0.x
VMware VirtualCenter 2.5.x
VMware vCenter Server 5.1.x

Cause

This issue occurs when the Read_Committed_Snapshot option in the database server is enabled.

To determine if the feature is enabled, run this query in SQL Server:

SELECT is_read_committed_snapshot_on FROM

sys.databases WHERE name= 'VirtualCenter_DB_name '

Note: The results from the above query are either be 0 or 1, where a value of 0 means the feature is Off and a value of 1 means the feature is On.

Resolution

To resolve this issue, disable the Read_Committed_Snapshot option by running this query in SQL Server:

ALTER DATABASE VirtualCenter_DB_name SET READ_COMMITTED_SNAPSHOT OFF

Additional Information

To determine how much space each portion of the tempdb database is using, run this query in SQL Server:

SELECT
SUM ( user_object_reserved_page_count )* 8 / 1024 as usr_obj_mb ,
SUM ( internal_object_reserved_page_count )* 8 / 1024 as internal_obj_mb ,
SUM ( version_store_reserved_page_count )* 8 / 1024 as version_store_mb ,
SUM ( unallocated_extent_page_count )* 8 / 1024 as freespace_mb ,
SUM ( mixed_extent_page_count )* 8 / 1024 as mixedextent_mb
FROM sys.dm_db_file_space_usage

For more information about thetempdb database, see:

• The Microsoft TechNet article Troubleshooting Insufficient Disk Space in tempdb
• The Microsoft TechNet article Optimizing tempdb Performance
• The Microsoft Knowledge base article 307487

Note: The preceding links were correct as of January 27, 2010. If you find a link is broken, provide feedback and a VMware employee will update the link.

VMware VirtualCenter Server サービスを起動した後、SQL Server tempdb データベースが増大し続ける