/SQLMonitor

SQL Server monitor, manages sql server performance, monitor sql server processes and jobs, analyze performance, analyse system, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach.

Primary LanguageC#Apache License 2.0Apache-2.0

Database Stack

Want to know the comprehensive database technology stack, including MS SQL Server, Azure etc? Check out Database Stack:

https://github.com/unruledboy/DatabaseStack

SQL Monitor

SQL Server monitor, manages sql server performance, monitor sql server processes and jobs, analyze performance, analyse system, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach.

Latest version executable download: https://raw.githubusercontent.com/unruledboy/SQLMonitor/master/SQLMonitor.bin.zip

Image of SQL Monitor

It uses linq and requires .net 4.0 (client profile), only support SQL Server 2005/2008/2008R2/2012, not for 2000, sorry :(

The implementation is quick, pretty straight forward, but I try to maintain the logic and make the job done.

There is an article about this project at code project: http://www.codeproject.com/KB/database/sqlmon.aspx

And there is the second article also at code project: http://www.codeproject.com/KB/database/sqlmonitor.aspx

Why

Ok, I have to admit that I got bored so I just want to make something. It looks like I am reinventing a wheel(duplicating part of SQL Server Management Studio?), mmm, actually, I don't think so. I address something here that do not exist in SQL Server Management Studio at all, at least not in 2012RC0.

Target

Step 1: a real monitor, keep tracking sql server actitivities(sql execution, cpu consumption, disk space etc), alert on customized notifications.

Step 2: support oracle/mysql/firebird/postgresql etc.

Step 3: accessible on any client (including mobile phones).

Features

Screen Shots

All New Health Monitor

Image of SQL Monitor

Performance Graph

Image of SQL Monitor

Monitor Multiple Servers / Databases

Image of SQL Monitor

Popup/Dock Performance Graph

Image of SQL Monitor

Object Explorer

Image of SQL Monitor

Object Version Control

Image of SQL Monitor

Version Compare

Image of SQL Monitor

Activities

Image of SQL Monitor

Process Visualizer

Image of SQL Monitor

Analysis - Database

Image of SQL Monitor

Analysis - Execution

Image of SQL Monitor

Analysis Logic Fault

Image of SQL Monitor

Alerts

Image of SQL Monitor

Alerts - Empty Table

Image of SQL Monitor