These features are collected and stored at a 1 minute interval, with the exception of query snapshots.
Query snapshots are
collected and stored at 1 second intervals.
Wait Event Analysis
View query level wait events for any query. This is not to be confused with instance level wait events.
Most competitors can report instance level wait events, very few can report query level wait events.
View all execution plans for any query. Execution plans are tracked historically
to help diagnose execution plan related performance issues. Response time, CPU time, and IO statistics
are tracked per execution plan. Execution plans are read from the plan cache so they are an
accurate representation of the plan. Plans are available for download so they
can be opened in SSMS.
Execution Plan Compile Parameters
View parameters that were used in compiling an execution plan. This is helpful for
diagnosing parameter sniffing issues.
Query Response Time
View average and total query response times for any query.
Query CPU Time
View average and total cpu time for any query.
View lock trees on any locks detected and view what the root blocker
was doing at the time of the lock. Lock trees are stored historically
so the information is available for viewing even if the problem
occured in the past.
Query Deadlock Analysis
Capture deadlocks and group similar deadlocks together. View lock analysis
on sessions involved in deadlocks to find root cause. Deadlocks are stored
in xdl format and can be downloaded to open in SSMS. This feature additionally
fixes the invalid formatted XML bug that exists in SQL Server 2008.
Query Memory Analysis
See what queries are responsible for consuming the most memory. This feature is valuable when diagnosing
View logical reads, logical writes, and rows returned for any query.
Executing query snapshots
View a second by second snapshot of what a query was doing as it executed.
Executing query snapshots can be viewed live or historicaly.
Option for masking parameters in non parameterized SQL. This prevents any hardcoded values in a query from
ever leaving the safety of your datacenter/network.
Execution Plan Sanitization
Option for masking parameters in execution plans. Execution plans may contain non parameterized SQL.
They may also contain parameters used during the compilation of a query. This prevents
any hardcoded values in a query or parameters used during compliation from ever leaving the safety of your
Our monitoring agent uses https to communicate with SQLGrease cloud services. Traffic is only outbound.
No inbound firewall ports are required to your datacenter/network.
Minimum Access Required
View Server State access will provide access to all of SQLGrease's features except for OS performance
counter monitoring. SQL Server performance counters are still available though. OS performance
counter monitoring requires sysadmin permission on the instance.
Events and Notifications
Events and notifications are processed and stored at a 1 minute interval.
Create events for a large variety of situations. Some examples:
Long wait events
Specific wait types
Execution plan change
Performance counter data
And many more...
Filter events based on a wide variety of options. Just a few examples:
Query Plan Hash
Time of day
Day of week
And many more...
Create notifications based on event occurences. Customizable rules
prevents false positives.
Email based Notifications
Customizable subject line. Description of events causing notifications are included in body.
Performance Counters are collected and stored at a 1 minute interval.
OS Performance Counters
Processor, memory, and disk counters are collected. Not all counters are collected in order
to reduce monitoring overhead and space usage. Providing too many counters can cause confusion
when trying to determine an OS related problem.
OS performance counters can only be collected if sysadmin is granted to user.
SQL Performance Counters
A select set of SQL Performance counters are collected. Not all counters are collected in order to
reduce space usage. Providing too many counters can cause confusion. Wait events are the best
starting point for performance diagnosis.
Support for RDS and Azure SQL Database
SQLGrease supports RDS and Azure SQL Database.
If you are considering migrating your IASS or on premise version of SQL Server to Azure SQL Database,
SQLGrease can help you estimate what your DTU requirements would be.
The Agent Collector Service has a small footprint in your datacenter/network. It is a windows service that
collects and sanitizes data from your SQL Server instances. A single collector service can collect from multiple
SQL Server instances. The collector can run on a server that is configured with as little as 1 GB memory and 1 processor.
During our free trial period it can even be run from a user workstation with no impact to performance.
SQLGrease has new features added regularly. New features do not require reinstallations or any
intervention from customers. Our collection engine allows deployment of new collection points as
we improve our product.
We do not charge for new features.
Licenses are floating. This is great for non production environments where monitoring
is only required during certain development and testing tasks. This is also great
for SQL Server consultants that need a monitoring platform they can move between clients.
Our subscritpion based pricing allows temporary monitoring of SQL Server instances.
Pricing is based upon the amount of data stored in a dedicated SQLGrease data warehouse.
Even our lowest pricing tiers can store large amounts of data. You can modify the amount
of history retained to keep your pricing within certain boundaries. History is maintained at
multiple granularies (1 second, 1 minute, 15 minute, 30 minute, 60 minute, 1 day).
Each granularity can be adjusted individually.
Start with a low pricing tier and upgrade later if it is not large enough. Upgrades can be
made at anytime.