GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → marcingminski → Sqlwatch

marcingminski / Sqlwatch

Licence: other
SQL Server Performance Monitor

Labels

databasesqlserverperformance-monitoringgrafana-dashboard

Projects that are alternatives of or similar to Sqlwatch

Symmetric Ds
SymmetricDS is a database and file synchronization solution that is platform-independent, web-enabled, and database agnostic. SymmetricDS was built to make data replication across two to tens of thousands of databases and file systems fast, easy and resilient. We specialize in near real time, bi-directional data replication across large node networks over the WAN or LAN.
Stars: ✭ 450 (+111.27%)
Mutual labels:  database, sqlserver
Typeorm
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Stars: ✭ 26,559 (+12369.01%)
Mutual labels:  database, sqlserver
Monitor Table Change With Sqltabledependency
Get SQL Server notification on record table change
Stars: ✭ 459 (+115.49%)
Mutual labels:  database, sqlserver
Php Crud Api
Single file PHP script that adds a REST API to a SQL database
Stars: ✭ 2,904 (+1263.38%)
Mutual labels:  database, sqlserver
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+8429.58%)
Mutual labels:  database, sqlserver
Dibi
Dibi - smart database abstraction layer
Stars: ✭ 373 (+75.12%)
Mutual labels:  database, sqlserver
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (+123.94%)
Mutual labels:  database, sqlserver
Dbachecks
✔ SQL Server Environmental Validation
Stars: ✭ 319 (+49.77%)
Mutual labels:  database, sqlserver
Ebean
Ebean ORM
Stars: ✭ 1,172 (+450.23%)
Mutual labels:  database, sqlserver
Syncchanges
Synchronize/Replicate database changes using SQL Server Change Tracking
Stars: ✭ 66 (-69.01%)
Mutual labels:  database, sqlserver
Liquibase
Main Liquibase Source
Stars: ✭ 2,910 (+1266.2%)
Mutual labels:  database, sqlserver
Datax
DataX is an open source universal ETL tool that support Cassandra, ClickHouse, DBF, Hive, InfluxDB, Kudu, MySQL, Oracle, Presto(Trino), PostgreSQL, SQL Server
Stars: ✭ 116 (-45.54%)
Mutual labels:  database, sqlserver
Jooq
jOOQ is the best way to write SQL in Java
Stars: ✭ 4,695 (+2104.23%)
Mutual labels:  database, sqlserver
Mssql Cli
A command-line client for SQL Server with auto-completion and syntax highlighting
Stars: ✭ 1,061 (+398.12%)
Mutual labels:  database, sqlserver
Csv2db
The CSV to database command line loader
Stars: ✭ 102 (-52.11%)
Mutual labels:  database, sqlserver
Kangaroo
SQL client and admin tool for popular databases
Stars: ✭ 127 (-40.38%)
Mutual labels:  database, sqlserver
Dbtool
数据库工具，根据表结构文档生成创建表sql，根据数据库表信息导出Model和表结构文档，根据文档生成数据库表，根据已有Model文件生成创建数据库表sql
Stars: ✭ 206 (-3.29%)
Mutual labels:  sqlserver
Anima
Minimal database operation library.
Stars: ✭ 210 (-1.41%)
Mutual labels:  database
Androidgodeye
An app performance monitor(APM) , like "Android Studio profiler", you can easily monitor the performance of your app real time in browser
Stars: ✭ 2,430 (+1040.85%)
Mutual labels:  performance-monitoring
Element
💦Load test your app using real web browsers
Stars: ✭ 204 (-4.23%)
Mutual labels:  performance-monitoring
View All Similar Projects ➔

GitHub release GitHub All Releases License

About

SQLWATCH is a SQL Server Performance and capacity data collector with Power BI dashboard for data analysis. The idea behind is to provide community driven, standardised "interface" for SQL Server monitoring that can be consumed by various interfaces and integrate with availabilty monitoring platforms such as Nagios, Zabbix, PRTG

Resources

Architecture

SQLWATCH uses SQL Agent Jobs to trigger data collection on a schedule which write results to a local database. For that reason each monitored SQL Server instance must have SQLWATCH deployed, however, the destination database can be an existing "dbatools" database, msdb or a dedicated SQLWATCH database. For performance reasons, it is advisable to deploy into a dedicated database as we're setting Read Committed Snapshot Isolation which will not be done if deployed to an existing database. The data can be consumed and analysed by the Power BI report.

Requirements

Tested on the following SQL Server versions:

  • 2008 R2 SP3
  • 2012
  • 2014
  • 2016
  • 2017
  • 2019

SQL Server Express is not supported as there is no Agent to invoke data collection. Theoretically, data collection would be possible via SQLCMD triggered from the Windows Task Scheduler but we have not got that tested or even coded.

Although Docker and Linux work, the Windows-only WMI basd disk utilisation collector will fail.

Installation

The easiest way to install SQLWATCH is to use dbatools:

Install-DbaSqlWatch -SqlInstance SQLSERVER1,SQLSERVER2,SQLSERVER3 -Database SQLWATCH

Alternatively, SQLWATCH can also be deployed manually from the included Dacpac either via command line using SqlPackage.exe:

SqlPackage.exe 
   /Action:Publish 
   /SourceFile:C:\Temp\SQLWATCH.dacpac 
   /TargetDatabaseName:SQLWATCH 
   /TargetServerName:YOURSQLSERVER 
   /p:RegisterDataTierApplication=True

Or by deploying Data-Tier application in SQL Server Management Studio

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].