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


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