Monitoring Using SQL Operations Studio

Marlon Ribunal demonstrates how to build a widget in SQL Operations Studio:

This is where SQL Operations Studio (SOS) comes in the picture. SOS is a lightweight, cross-platform client. It is also open-source. Aside from its IDE functionalities, SOS has a lot of more offerings for DBAs, Devs, and DevOps. One of these is that you can use it as a dashboard to monitor your databases. SSMS comes with standard reports as well as custom reports using Report Definition Language or RDL (which is essentially an SSRS-like report residing in SSMS). SQL Operations Studio raised the bar in this regard. You can create multiple widgets to display on your dashboard.

Click through for a demonstration and screen shots.

Related Posts

When Multiple Missing Indexes Exist

Brent Ozar shows what happens when there are multiple missing indexes for a query: SQL Server Management Studio only shows you the first missing index recommendation in a plan. Not the best one. Not all of them. Just whichever one happens to show up first. Using the public Stack Overflow database, I’ll run a simple query: But that […]

Read More

SQL Operations Studio, June Release

Alan Yu announces the June release of SQL Operations Studio: The June public preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top GitHub issues. Highlights for this build include the following. SQL Server Profiler for SQL Operations Studio Preview extension initial release Azure SQL […]

Read More

Categories

January 2018
MTWTFSS
« Dec Feb »
1234567
891011121314
15161718192021
22232425262728
293031