Loading

×Sorry to interrupt
CSS Error

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

Shrinking the size of the VMware vCenter Server SQL database (1036738)

Last Updated: 3/20/2024Categories: TroubleshootingTotal Views: 101996Language:
Chinese (Simplified)JapaneseEnglish

1 like this article

Subscribe to get an email
newsletter with new updates

1 people found this helpful Please provide article feedback:

Purpose

This article provides the query to shrink the size of the vCenter Server SQL database and transaction logs.

You can shrink the size of the SQL database and transaction logs when:

The vSphere Client takes a long time to open the vCenter Server connection.

vCenter Server service crashes unexpectedly.

vCenter Server tasks are very slow to respond.

The database server used for vCenter Server has run out of disk space.

You see that the SQL VIM_VCDB size is 300% more than the estimated database size.

Resolution

To shrink the size of the vCenter Server SQL database and transaction logs:

Connect to the vCenter Server database using the SQL Management Studio Express as an administrator.

Stop the VMware VirtualCenter Server service.

Take a backup of the vCenter Server database using this query:

BACKUP DATABASE DatabaseName TO DISK = 'C:\DatabaseName.BAK'
GO

Right-click the vCenter Server database, click Run Query, and run this query :

DBCC SHRINKDATABASE ( DatabaseName , 5);
GO

Start the VMware VirtualCenter Server service.

Note: When DBCC SHRINKDATABASE is specified with target_percent, the Database Engine calculates the target size to be the target_percent amount of space free in the file after shrinking.

If you are unable to shrink the size of the vCenter Server database (VIM_VCDB) using the SQL Management Studio GUI, you have to run T-SQL scripts.

Related Information

For more information on using DBCC SHRINKDATABASE, see the Microsoft Knowledge Base article190488

Note: The preceding link was correct as of July 21, 2014. If you find the link is broken, provide feedback and a VMware employee will update the link.

To check the status of the database shrink, run this query:

SELECT percent_complete, start_time, status, command, estimated_completion_time, cpu_time, total_elapsed_time, * FROM sys.dm_exec_requests

Investigating the health of a vCenter Server database
Reducing the size of the vCenter Server database when the rollup scripts take a long time to run
Purging old data from the database used by vCenter Server
Determining where growth is occurring in the vCenter Server database
VMware vCenter Server の SQL データベースのサイズを縮小する
收缩 VMware vCenter Server SQL 数据库的大小

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
Chinese (Simplified)JapaneseEnglish

Attachments

Additional Resources

KB
•
从 GRUB 提示符恢复 ESX 主机 (1007908)

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

KB
•
再構成時に変換が失敗した場合の vCenter Converter のトラブルシューティング (1006294)

KB
•
Download and Install VMware Fusion (2014097)

Results 1-4 of 4

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

VMware VirtualCenter

VMware vCenter Server

Related Versions:

VMware VirtualCenter 2.5.x

VMware vCenter Server 6.7.x

VMware vCenter Server 6.5.x

VMware vCenter Server 6.0.x

VMware vCenter Server 5.5.x

VMware vCenter Server 5.1.x

VMware vCenter Server 5.0.x

VMware vCenter Server 4.1.x

VMware vCenter Server 4.0.x

view all

Take Our Survey

Support Assistant