Subscribe
-
-
Latest blog posts
What we’re up to on Twitter
What we're up to on Twitter
Recent Comments
- Samantha L. on Far away from your desk
- automatizari porti on SQL Bits 8
- Tweets that mention Maintenance windows and SSRS reports | The Future of Monitoring -- Topsy.com on Maintenance windows and SSRS reports
- Chris.Spencer on Using CloudWatch to monitor EC2 instances
- Fred van den Bosch on Using CloudWatch to monitor EC2 instances
Links
-
Monthly Archives: January 2010
SQL Profiler and Trace
As part of SQL Response V2 we’ll be collecting all sorts of data that allows the user to see what is happening on SQL instances monitored by the product. However, obviously, we have a delicate balancing act to perform – we want to maximise the information we obtain whilst minimising the impact on the monitored [...]
Clock Skew
Einstein famously discovered that all time is in fact relative. This is all very well when travelling at near-light speed or when considering theoretical inter-galactic spacemen, but for monitoring SQL Servers, knowing the correct time can be a big issue. We’re currently having some pretty brow-furrowing, head-scratching discussions about how to handle the synchronization of [...]
Garage Check-list Inspired Monitoring UI.
I just came across this concept UI for a monitoring widget designed by Ely Sarig. In the description he says: “The design is inspired by garage check-up sheets, displaying information on stained forms, much like a mechanic’s paperwork.” We think it’s brilliant! If only it displayed info for remote servers and SQL Server stats too…! [...]
Posted in Design A Dashboard Leave a comment
Help!
Today at Red Gate Towers we’ve been discussing various possible ways of helping users get started in SQL Response v2 when they launch the product for the first time following installation. As a user of SQL Response, you will of course have to add at least one server before we can begin monitoring it. So [...]
Web Server
SQL Response v2 will require a web server to deliver the content displayed in the browser-based user interface. SQL Response can install its own self-contained Mono XSP Web Server that will serve all the pages for the SQL Response web client. However, if you already use IIS for web servers in your organisation, you may [...]
Accidental DBAs and simple tools
Brad McGehee has written an interesting blog post on the SQL Server Maintenance Plan Wizard. His point is that all DBAs begin as novices, and that simple tools like the Maintenance Plan Wizard can help bridge the gap from novice to experienced DBA. Our challenge for SQL Response has been to make a tool that [...]
Posted in Uncategorized Leave a comment
CPU usage – per core or combined?
Speaking to our Infrastructure Manager the other day, he mentioned how they found looking at CPU per core helpful because recently there was a problem with 1 core being locked onto, causing CPU issues. Would you expect SQL Response to show your CPU usage per core, or are you happy with a combined total? Do [...]
SQL Server Express
Many organisations do, of course, have a wide range of SQL Server versions and editions across their environments – we’ve seen a very wide range across development, staging and, of course, production servers, even within the same organisation. However, we did have quite a lengthy discussion a couple of weeks back about the use of [...]
Database Overview