Ad Widget

Collapse

Create an alert about MsSQL Log files

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • amazzucchelli
    Junior Member
    • Feb 2025
    • 3

    #1

    Create an alert about MsSQL Log files

    Hi, how can I create an alert that shows me when a Database Log FILE reachs a defined size? For example, I want to know when the .ldf file from ANYDATABASE reachs 10 Gbs?

    I could create a Trigger/Item and Macro that alerts me when ALL .ldf files from ALL databases together reachs 10 Gbs, but I need to make this but for a Single FILE, so when ONE database log reachs 10Gbs alerts me.

    Im using Zabbix 7.0.6 and the templante is "MSSQL by Zabbix agent 2

    Thank you!!
  • Brambo
    Senior Member
    • Jul 2023
    • 245

    #2
    If you want to know the file size only than vfs.file.size pointed to your file. See: https://www.zabbix.com/documentation...#vfs.file.size
    I don't know how the values is reported back but based on that build your trigger.

    Comment

    • amazzucchelli
      Junior Member
      • Feb 2025
      • 3

      #3
      Originally posted by Brambo
      If you want to know the file size only than vfs.file.size pointed to your file. See: https://www.zabbix.com/documentation...#vfs.file.size
      I don't know how the values is reported back but based on that build your trigger.
      Thanks,,, I created an item with the vfs.dir.coun and I could do what I needed!.
      I already set a trigger using that Item.

      Thanks Anyway!!

      Comment

      Working...