Monthly Archives: October 2009

Our sixth monitoring dashboard entry

The sixth entry to our Design a Dashboard competition is a submission from Iain Knight. This excellent design consists of four elements: a system overview, a server information dashboard, a performance dashboard and a database information dashboard. The main system overview contains a graphical display of your key servers, organised into customisable groups, for example [...]
Posted in Design A Dashboard | Leave a comment

Come and see us at SQL PASS

James and Wibke from The Future of Monitoring Team will be at the SQL PASS Summit in Seattle from November 2nd to the 5th. They will have some of the latest designs for SQL Response v2 and are keen to hear more about what you need from a monitoring solution. Please head over to the [...]
Posted in Uncategorized | Tagged | 2 Comments

Reporting

Many users of SQL Response v1 have requested some sort of reporting functionality and we are keen to hear more about your requirements in this area. How often do you currently run reports? If reports were automatically generated at defined intervals, how frequently would you run them? Do you use reports for capacity planning, auditing/compliance, [...]
Posted in Uncategorized | Tagged | 4 Comments

Remote access

In my discussions with DBAs, I’ve encountered a number of ways in which people stay in touch with what is happening on their systems when they’re away from their desktop PC. Obviously there’s the Blackberry, which seems to be the de-facto standard approach (although I hear that the default web browsing experience on the Blackberry [...]
Posted in Uncategorized | Tagged | 2 Comments

Machines, servers, physical servers, SQL servers…

One of the issues we are encountering on a daily basis in the development process for SQL Response 2 is the question of how you think about your monitored servers. SQL Response 2, like version 1, will monitor both SQL Server issues (deadlocks, job failures, blocked processes, long running queries, database status changes and so [...]
Posted in Uncategorized | 3 Comments

Business as ‘unusual’

At a recent conference, an on-line retailer talked about a time when they had a problem with their website: the first they knew about it was when they discovered they’d taken no orders for 24 hours.  A few days later, an in-passing chat with Red Gate’s head of IT revealed that we’d recently had a [...]
Posted in Uncategorized | 2 Comments

Waits and Queues

Waits are the delays caused when a process or worker thread cannot immediately access the resources it requires. Waits can be caused by either excessive activity or inadequate resources. Queues store incoming requests for resources that cannot be immediately satisfied. Waits and queues can help to identify the resources which are under pressure. But, I’m [...]
Posted in Metrics | 4 Comments

Our fifth monitoring dashboard entry

We’ve received another excellent entry to our Design a Dashboard competition. John Clark has sent us designs for a system overview and a drilled-down view of a selected SQL Server instance. The overview screen sorts alerts by their status rather than severity, using a ‘traffic light system’ of red,amber,green to identify servers as ‘not acknowledged’, [...]
Posted in Design A Dashboard | 2 Comments

Where do you locate your monitoring service?

SQL Server monitoring tools generally require somewhere to install the service that does the monitoring. In SQL Response 1, we required you to install an Alert Repository – a combination of a Windows service to collect data from your monitored servers and a repository for storing the collected data. In SQL Response 2, it’s likely [...]
Posted in Uncategorized | 6 Comments