• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 32 subscribers
  • Views 172 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

monitoring for the sql shrink flag

ryan.davis26

Calling all SQL experts.  Is anyone aware of a way to monitor for the SQL shrink flag?

  • 0

    SCOM does it. You could do it with SAM with a custom POSH monitor - check the new SQL POSH modules, they're incredible.

    SCOM's config -

    - <Configuration>

    <ConnectionString>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$</ConnectionString>

    <DatabaseName>$Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$</DatabaseName>

    <IntervalSeconds>43200</IntervalSeconds>

    <SyncTime />

    <ConfigValue>AutoShrink</ConfigValue>

    <ExpectedValue>OFF</ExpectedValue>

    <ExcludeOnExpress>false</ExcludeOnExpress>

    <SQLSKU>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/Edition$</SQLSKU>

    <TimeoutSeconds>300</TimeoutSeconds>

    </Configuration>

  • 0 in reply to orioncrack

    Interesting; so is POSH something that has to be installed or is just a moniker for Powershell ran against SQL?   Which then I guess would just be a PowerShell monitor in SAM?

    Makes you wonder if this is what all the "custom performance monitors" are in the AppInsight for SQL template...

  • 0 in reply to ryan.davis26

    It's just the powershell monitor that is included in SAM. You can script it.  Just have to have a user account that SAM can use to run the Powershell script locally or remotely against the host machine. 

  • 0 in reply to ryan.davis26

    The Performance monitors are just WMI calls.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.