Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about how to obtain the database name in Exchange. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Combing the architecture in the customer environment, it is found that some exchange 2013 back-end servers have a high load, partly because of the high activity of users in the database and high mailbox utilization, and partly because the version of CU10 content index noderunner service will take up a lot of overhead. I want to do some optimization to migrate some BE back-end database users with higher load to other back-end BE with lower load, but how to migrate It is awkward to migrate to a database with a low load, and a script has been sorted out through various Google searches to help do this.

At that time, when exchange was built, there were about 500 users distributed for each database, but the usage of each mailbox user was different, and the administrator had no way to control it, because it was a user-level behavior, which caused the load imbalance of each BE backend server.

Through a powershell script, we can get the name, size and number of users of each database and output it directly to csv's friendly interface, which can help us to optimize data performance.

Share the script and hope it is useful for everyone. It is suitable for exchange 2013 environment. Please test other versions by yourself.

The output information is as follows:

Add-PSSnapin microsoft.exchange*

Add-pssnapin Microsoft.Exchange.Management.PowerShell.E2010

# $MailboxDatabases=Get-MailboxDatabase-Status | select Name,DatabaseSize

$dbs = Get-MailboxDatabase-Status | Where {$_ .Recovery-ne $true}

$dbs = $dbs | sort-object name

$output='C:\ databaseSize.csv'

$title= "databasename,Servername,databasesize,count"

$title > > $output

Foreach ($db in $dbs)

{

# Get the mailbox count for the database

$mailboxes = Get-Mailbox-database $db-IgnoreDefaultScope-Resultsize Unlimited-erroraction silentlycontinue

$mbcount = $mailboxes.count

$dbsize=$db | select Server,DatabaseSize

# $databaseSize=$dbsize.DatabaseSize.ToString () .Split ("GB") [0]

$databaseSize=$dbsize.DatabaseSize.ToBytes () / 1024 Universe 1024

$message= "$($db.name), $($dbsize.Server), $databaseSize,$ ($mailboxes.count)"

$message > > $output

}

The above is the editor for you to share how to get the database name in Exchange, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.