Search the Community

Showing results for tags 'sql'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • From LogicMonitor
    • Product Announcements
    • LM Staff Contributions
    • Community Events
  • LogicMonitor Product Discussion
    • Feature Requests
    • LM Exchange
    • Ask the Community

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me

Found 6 results

  1. Hello, I have recently seen a few of these tickets com across the board and was wondering if anyone would be able to give me a quick breakdown as to what this actually is and what the benefits would be to add this into the instance. SQL Server Troubleshooter-MSSQLSERVER Missing JDBC connection string. Manually add one to mssql.mssqlserver.mssql_url or check login informations exitCode A Microsoft SQL server has configuration problems or a logon error. MSSQLSERVER Missing JDBC connection string. Manually add one to mssql.mssqlserver.mssql_url or check login informations Th
  2. We have a unique SQL setup that is using mirroring. How can we configure LM to not show the databases that are in (Mirror, Sychronized/Restoring...) mode as not 'down'.
  3. DESCRIPTION: This will alert you via LogicMonitor when a MS-SQL ‘job’ fails INSTRUCTIONS: Create a LogicMonitor “EventSource”. Named “SQL job failures” or similar. I suggest that you clone the default “SQL eventsource”. Set these settings: LogName = “Application” SourceName = “SQLSERVERAGENT” Level more urgent than “Information” Use Microsoft’s SQL Management Studio to set each job on each of your SQL servers so that when a job fails, it will write a message to the Windows Application event log (screenshot below) Right click on job and click “Pro
  4. Hello all! I just recently created a monitor to track the amount of time in seconds the secondary replicas are behind the primary and I figured I would share my solution. This will display the span of time in which past transactions could be lost in the event of a fail over. This assumes the secondaries are asynchronous. We are using SQL 2016, I do not know if this will work on earlier versions of SQL. I created a datasource and set the "Applies to" to the server in question. I set the collector to "SCRIPT" and I set the datasource to multi-instance and enabled active discovery. I used JD
  5. Datasource with powershell script to monitor the Sync status of a specific database in a SQL 2016 High Availability instance. I noticed databases can fall into NotSynchronizing status on secondary nodes often without much alerting around it. The datasource monitors per database. If someone has a better way that will take in the status of all databases on the instance I am open to suggestions LM Locator: 6YD2C9
  6. Is there a good datasource out there to monitor the size on disk of a specific file or folder? I would love the Microsoft Exchange datasource (or other) to be able to deliver and track the total size of the database. Thoughts? Will