sql-servergeneositrs
How do you create an ITRS/Geneos alert for MSSQL DB
I'm new to ITRS Monitoring, and I am wondering if I could create a Geneos alert that can connect to a MSSQL DB and run a simple select to make sure connectivity is good. Is this possible with Geneos? Are there any plugins needed?
Solution
Yes - you can use sql toolkit plug-in. It supports Db2, Oracle, SQL Server, MySql and Sybase. It will look something like this:
- SQL Server Cursor performance issue
- Is it possible to determine what caused a duplicate key values
- SQL Server Error "Named Pipes Provider: Could not open a connection to SQL Server [53]"
- SQL Server : login success but "The database [dbName] is not accessible. (ObjectExplorer)"
- R odbc::odbcListDrivers() does not list dirver in /opt/homebrew/etc/odbcinst.ini
- How to perform division in SQL Server?
- How to get date difference from a column?
- How can I determine installed SQL Server instances and their versions?
- How to force SQL Server container to immediately update MDF file in Docker volume?
- Using where clause in Sql Server LEAD
- Combine overlapping date ranges
- Expand the date range between two dates
- Providing string variable into Dynamic SQL SELECT statement WITHOUT it being read as a column name?
- How to store geocoded address information into the database
- Truncate a DDL or DML command
- How can I find out what FOREIGN KEY constraint references a table in SQL Server?
- Why ISDATE() is returning 9996 as date?
- .NET 8 & SQL Server 2016 - Contains() throws error
- IsDate Function in SQL evaluates invalid dates as valid
- SQL Server - Value passes ISDATE() but fails to CAST as DATE or DATETIME
- Error when connecting to SQL Server in deno: 'cannot find module crypto'
- Multiple many-to-many and multiple one-to-one relationships in the same entities
- SQL Server DATEDIFF round up the YEAR difference. How to round it down?
- Path table to HTML treeview in SQL Server
- SUM and Decimal precision
- Parse TEXT datatype column to grab values based on TAGS
- How can I create a tar file in memory from several varbinary(max) columns stored in SQL Server using .NET native API?
- collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS"
- Maintaining property order with get-member
- migrate data from MS SQL to PostgreSQL?