Project Description

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.

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

 

To Do

see Issue Tracker

 

Screen Shots

 

0. All New Health Monitor

 

1. Performance Graph

 

Monitor Multiple Servers / Databases

Popup/Dock Performance Graph


2. Object Explorer

 

3. Object Version Control

 

4. Version Compare

 

5. Activities

 

 

6.Process Visualizer

7. Analysis - Database


8. Analysis - Execution

 

9.Analysis Logic Fault


 

9. Alerts

 

10. Alerts - Empty Table

Last edited Mar 4, 2013 at 8:35 AM by unruledboy, version 79