dbatools is a free PowerShell module with over 200 SQL Server administration, best practice and migration commands included.

Please note that documentation and command names may be out of date while we work furiously towards 1.0


Find-DbaDatabaseGrowthEvent

Finds any database AutoGrow events in the Default Trace.

Screenshots

Examples

Returns any database AutoGrow events in the Default Trace for every database on the localhost instance.

Find-DBADatabaseGrowthEvent -SqlServer localhost

Returns any database AutoGrow events in the Default Traces for every database on ServerA\sql2016 & ServerA\SQL2014.

Find-DBADatabaseGrowthEvent -SqlServer ServerA\SQL2016, ServerA\SQL2014

Returns any database AutoGrow events in the Default Trace for every database on the ServerA\SQL2016 instance in a table format.

Find-DBADatabaseGrowthEvent -SqlServer ServerA\SQL2016 | Format-Table -AutoSize -Wrap

Author

This command was written by SQL Server MVP Aaron Nelson. You can find Aaron blogging at sqlvariant.com and on Twitter.

Get-Help

From PowerShell, execute Get-Help Find-DbaDatabaseGrowthEvent -Detailed for more information on this function.

Source Code

Want to see the source code? View Find-DbaDatabaseGrowthEvent.ps1 on GitHub
 

Related commands