-
-
Notifications
You must be signed in to change notification settings - Fork 857
Closed
Labels
bugs lifetriage requiredNew issue that has not been reviewed by maintainersNew issue that has not been reviewed by maintainers
Description
Verified issue does not already exist?
I have searched and found no existing issue
What error did you receive?
Find-DbaDbGrowthEvent states in the .OUTPUTS section of the help that Duration is reported in seconds. This is incorrect. The source data is microseconds, which is then divided by 1000 to get milliseconds.
This was added in #10072. Hat tip to Edwin Sarmiento for bringing it up on SQLSlack
Steps to Reproduce
Get-Help Find-DbaDbGrowthEvent -FullOutput:
OUTPUTS
PSCustomObject
Returns one object per database auto-growth or auto-shrink event found in the SQL Server Default Trace. The specific events returned
depend on the -EventType and -FileType parameters.
Default display properties (via Select-DefaultView):
- ComputerName: The computer name where the SQL Server instance is running
- InstanceName: The SQL Server instance name
- SqlInstance: The full SQL Server instance name (computer\instance)
- EventClass: The trace event class (92 = Data File Auto Grow, 93 = Log File Auto Grow, 94 = Data File Auto Shrink, 95 = Log File Auto
Shrink)
- DatabaseName: The name of the database that experienced the growth/shrink event
- Filename: The path and name of the database file that was resized
- Duration: The duration of the event in seconds (milliseconds converted to seconds)
Please confirm that you are running the most recent version of dbatools
2.7.24
Other details or mentions
No response
What PowerShell host was used when producing this error
PowerShell Core (pwsh.exe)
PowerShell Host Version
Name Value
---- -----
PSVersion 7.5.4
PSEdition Core
GitCommitId 7.5.4
OS Darwin 25.2.0 Darwin Kernel Version 25.2.0: Tue Nov 18 21:09:55 PST 2025; root:xnu-12377.61.12~1/RELEASE_ARM64_T8103
Platform Unix
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0…}
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1
WSManStackVersion 3.0
SQL Server Edition and Build number
N/A
.NET Framework Version
N/A
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugs lifetriage requiredNew issue that has not been reviewed by maintainersNew issue that has not been reviewed by maintainers