SQL Server監控器，管理sql server性能：SQLMonitor

ygp8 9年前發布 | 14K 次閱讀 SQL Server 數據庫服務器 SQLMonitor

SQL Server 監控器, 管理sql server性能，監控 sql server 進程和作業，分析性能，分析系統，對象版本控制，查看執行中的SQL查詢，殺掉 process / job，對象瀏覽器，數據庫收縮/日志截斷/備份/分離/附加。

</div>

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

Tracking sql server status, notify query execution and server status
Version control, tracking table structure, index, trigger, view, function, stored procedure versions
Server summary
Analysis, expensive queries, thanks: http://sqlmonitor.codeplex.com/
Performance Charting
Object explorer, see object scripts, including tables, view dependencies.
Process Visualizer, thanks: http://www.codeproject.com/Articles/18378/Organization-Chart-Generator
Detect dead loop and memory leakage
Query, table data view
Database shrink/log truncate/backup/detach/attach
Syntax Color Highlighting, thanks: http://www.icsharpcode.net/
Text comparison, thanks: http://www.codeproject.com/KB/recipes/diffengine.aspx
Object/script search
Support processes and jobs
Keep tracking actual running sql query
Automatically load lan sql server instances
Auto refresh
Auto update notification
Grid grouping, thanks OutlookGrid: http://www.codeproject.com/Articles/14388/OutlookGrid-grouping-and-arranging-items-in-Outloo