A modular approach
SQL Watcher adapts to your company’s needs by proposing a variety of monitoring modules
Instance configuration
Compare all of the elements in the instance configuration with the initial values.
A modification in the configuration may have a profound impact on the performance of the server.
Security
Monitor logins for SYSADMIN and demand justification in the event of privilege escalation.
Avoid attacks by monitoring access rights to your databases.
Database performance
All of the queries carried out on the databases are analysed to detect the evolution of data usage.
Some indications of ways to optimize may be given : missing index, superfluous index, modification of implementation plan, statistics out of date.
Database configuration
Compare all of the elements in the database configuration with the initial values.
A modification in the configuration may significantly affect access to data, thereby influencing the efficiency of the application.
Instance performance
Many performance counters are monitored in Windows (memory disk processors) to detect an underlying configuration of servers .
To guarantee optimal performances, it is recommended to avoid rebooting an SQL server. For this reason, a justification is required after any SQL server instance restart.
Do you need a special module ?
Does your company have a particular need that you would like to discuss with us ? Do not hesitate to contact us.
What our clients say
about our service :
– Text –
