search

MantasTumenas / Zabbix-template-for-Microsoft-SQL-Server

Zabbix templates for Microsoft SQL Server. Features MS SQL performance counters. MS SQL instance Low Level Discovery. MS SQL database Low Level Discovery. MS SQL agent job Low Level Discovery. MS SQL database mirroring monitoring. MS SQL Always On monitoring. MS SQL Log Shipping monitoring. Supported versions Tested on Microsoft SQL Server 2012, 2014 and 2016. It may work with earlier versions, but some items (with missing performance counters) may be unsupported. For the extensive overview on the performance counters difference between MS SQL 2008 and MS SQL 2012 you can read here (https://blog.dbi-services.com/sql-server-2012-new-perfmon-counters/). Tested on Zabbix 3.4.0. It may work with earlier versions, but some items (for example service.info[service,]) may be unsupported. The template was started on Zabbix 2.4.0 but after each new Zabbix version, objects were modified or new things were added.
GNU General Public License v3.0
50 stars 27 forks source link

what is different between with and without SQL instance discovery #12

Closed wangjiangptt closed 5 years ago

wangjiangptt commented 5 years ago

what is different between with and without SQL instance discovery

MantasTumenas commented 5 years ago

With SQL instance discovery - scripts discover every instance, every database and applies templates (items, triggers). Without SQL instance discovery - you have to manually define instance and database names, which you want to monitor.

The choiCe depends on your current situation. If you are responsible and have full control over all the instances and databases (as in a database admin for the company), you should go with discovery script. If you are responsible only for a part of SQL server (1 database or instance) you can go without discovery. For example, you have to support external company, which asks, for your help only for 1 database and nothing more. Or you have to look over DEV server in your company, there developers are also a sysadmins and do anything they want (Shutdown SQL Agent, take dev database offline and so on). In last case I would monitor only instance and system databases.

To keep in mind - I am planning to ditch a template "Without SQL instance discovery" and instead improve a template "With SQL instance discovery". Improved template will have an option to select instances or databases, in case you need to monitor only part of SQL server

On Thu, Mar 28, 2019 at 10:09 AM wangjiangptt notifications@github.com wrote:

what is different between with and without SQL instance discovery

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/MantasTumenas/Zabbix-template-for-Microsoft-SQL-Server/issues/12, or mute the thread https://github.com/notifications/unsubscribe-auth/AthqTKGzUubwA_Gjz2sV0m3CVVK7FUPrks5vbHiggaJpZM4cPiZl .

MantasTumenas commented 5 years ago

Also. for a template with instance discovery to work, the powershell 3.0 or higher must be installed. It comes by default on WinOS 2012 or higher. Had a case, there I had to monitor SQL 2000 on older WinOS and could not install powershell 3.0. Had to to use highly modified template without instance discovery.