Completely free and Open Source, developed by SQL Server DBAs...
...because we have all been there, blindly trying to figure out why things aren't as fast as they used to be.
SQLWATCH is collecting a number of key metrics from Dyamic Management Views, Performance Counters, WMI, XE Sessions, SQL Waits and Storage Statistics to draw a comprehensive activity report of a SQL Server instance over time.
Provides index advisory based on the actual index usage as well as missing indexes.
Collects database growth and disk utilisation to help plan for storage space.
With most enterprise monitoring solution being licensed per instance, you probably never monitor performance in PRE, QA or DEV enviroments. Now you can.
No complex monitoring infrastructure required.
No additional monitoring services or central servers to worry about, no additional VMs to be provisioned, no agents to install.
Designed with small disk footprint in mind. Different retention periods for different data loggers to maintain low disk utilisation.
SQLWATCH uses SQL Agent jobs for data collection which is then stored locally and not affected by network blips. This approach allows it to work in isolated networks yet it still allows for central reporting but with the benefit of distributed storage and monitoring.
It gives you the full control when data collection runs, you can amend schedules and disable jobs you do not wish to run or run them on demand.
No hidden "features"
No complex code, all written in nice and tidy T-SQL with a bit of PowerShell
No complex routines, no custom error handlers and confusing logs. Thanks to the use of SQL Agent all execution failures go to the Job output and are visible in the standard Job History window.
What you see is you what you get and you are more than welcome to contribute or suggest new features.
Performance counters, database and storage performance, query analysis and workload statistics
Database space analysis, storage overview, database and disk growth.
Index overview and index strategy advisor, individual index analysis, missing index report
Latest blog post
I am happy to announce SQLWATCH 2.0 beta 4 which includes the following changes: New XE Sessions [new] #68 – New Extended event session (SQLWATCH_waits) to capture wait stats over 1 second. By default this session is disabled. There is no requirement to run it. If you chose not to, SQLWATCH will use the default …read more
Latest release
This site, like most websites, uses cookies. By continuing to use this website, you agree to their use.