Welcome to EMC Consulting Blogs Sign in | Join | Help

SSIS Junkie

Announcing SQL Server Monitor Gadget for Windows Vista Sidebar

It gives me great pleasure to announce that as of today, Conchango are making available version 1 of our SQL Server Monitor Gadget for Windows Vista Sidebar.

The gadget does exactly what it says on the tin; it monitors a specified SQL Server database for various metrics and displays them on the Windows Vista Sidebar. It is provided for use by SQL Server DBAs that require a nice'n'easy way of monitoring important metrics on their SQL Server installations. In version 1 the gadget provides the following information:

  • Data file size - total file size of the database data files
  • Data file used - amount of used space on those data files
  • Data file used % - The percentage of the total data size that has been used
  • Log file size - total file size of the database log files
  • Log file used - amount of used space on those log files
  • Log file used % - The percentage of the total log size that has been used

That may seem like a small list but bear with us, we are planning to add more in the future. For now we wanted to get something out there to whet your appetite and solicit some opinion about what you'd like to see in the future. We know there are alot of improvements that can be made but we saw more value in getting this out there early and getting feedback rather than trying to build the "perfect" gadget. If you have any ideas, reply to this blog post with a comment or email me at jamieDOTthomson[AT]conchangoDOTcom. I'm not promising we'll satisfy all requests but we'll do what we can.

Let's show you a demo of it working. Hit play on the video below.

 

If you want to get hold of the gadget then you can download it from here:

The zip file also includes the video that is embedded here in case you are having trouble viewing it in this blog entry (we're aware that there may be problems in some blog readers).

To install the gadget you will need to be running Windows Vista. Simply unzip the downloaded zip file and double-click on SqlGadget.gadget.This will install the gadget onto your machine and you can then add it to your sidebar and configure it accordingly just as you see in the video.

The last thing I need to do is pass on a massive shout of THANK YOU to my colleague John Rayner who has done a fantastic job of taking my flakey specs and dodgy T-SQL and turning them into a working gadget. Thanks John 

Have fun! And don't forget to tell us what you think about the gadget by replying below.

-Jamie

UPDATE: We've released a minor update to the gadget. Read about it here: http://blogs.conchango.com/jamiethomson/archive/2007/08/17/SQL-Server-Monitor-Gadget-v1.0.001.aspx

Published Thursday, August 09, 2007 6:10 AM by jamie.thomson

Comments

 

University Update - Windows Vista - Announcing SQL Server Monitor Gadget for Windows Vista Sidebar said:

August 9, 2007 10:46 AM
 

Anonymous said:

O god NO!!! Save us from another Northan twang :) - good work the two of you...

August 9, 2007 12:00 PM
 

Jason Haley said:

August 9, 2007 2:41 PM
 

Lara Rubbelke said:

Jamie Thomson, John Rayner and their team developed a Vista sidebar gadget to monitor SQL Server. http://blogs.conchango.com/jamiethomson/archive/2007/08/09/Announcing-SQL-Server-Monitor-Gadget-for-Windows-Vista-Sidebar.aspx

August 9, 2007 3:16 PM
 

SSIS Junkie said:

I've spoken about Live Folders quite alot on here lately and some big news from that product team

August 9, 2007 7:00 PM
 

Mohit Nayyar said:

Excellent, Welcome to product development ;) You are working really hard for Conchango IP............great work.

August 9, 2007 9:53 PM
 

alorenzin said:

Great work! Question I have is, if I have laptop with VISTA on it, and I am away from the office but connected via VPN, how can I get the stats for my SQL Server?

August 10, 2007 2:40 PM
 

Werner de Jong said:

Thanx. Love these little gadets that makes life easier. :)

August 10, 2007 3:19 PM
 

jamie.thomson said:

Hi alorenzin,

Honest answer - I don't know. We'll put that on the list of things to consider investigating/fixing for a later version.

Thanks

Jamie

August 10, 2007 3:26 PM
 

DBA with a MacBook Pro said:

I don't suppose you'd consider porting it to the OS X dashboard, would you? :)

August 10, 2007 8:47 PM
 

jamie.thomson said:

Ha,

I'll put it on the list. No promises :)

-Jamie

August 10, 2007 8:54 PM
 

External Links & References (SSQA.net) said:

Jamie Thomson et al has developed very useful Vista gadget that can be used to monitor the SQL Server

August 15, 2007 2:46 PM
 

Reed Me said:

Besides being a good guy to work with, Jamie apparently moonlights as a Gadgeteer... (Well, maybe John

August 15, 2007 7:19 PM
 

Noticias externas said:

Besides being a good guy to work with, Jamie apparently moonlights as a Gadgeteer... (Well, maybe John

August 15, 2007 7:25 PM
 

TJ said:

Ok, and how is this useful? It just presents information I don't need to see every minute of the day.

August 15, 2007 7:33 PM
 

jamie.thomson said:

TJ,

Don't use it then!

If you have any constructive feedback about what you would prefer to see up there then, as I said above, I invite you to provide it.

-Jamie

August 15, 2007 8:06 PM
 

STEFANO DEMILIANI said:

A Vista Gadget to monitor your SQL Server instances

August 16, 2007 2:49 PM
 

SSIS Junkie said:

One week ago we released v1.0 of SQL Server Monitor Gadget for Windows Vista Sidebar. Today we are making

August 17, 2007 4:02 AM
 

Rob Farley said:

I like this - can the queries be modified, to show different information if I want? After all, it's just a series of queries with 'union all', right?

I had something similar with PowerGadgets on an XP background a while back. I was actually using it to monitor business metrics. http://msmvps.com/blogs/robfarley/archive/2006/12/15/application-monitoring-in-20-seconds-with-powergadgets.aspx

But of course, PowerGadgets costs, and this is free. :)

August 17, 2007 11:34 AM
 

Rob Farley said:

A while back I discussed using the Windows Vista Sidebar to display useful information about applications

August 17, 2007 11:46 AM
 

jamie.thomson said:

Rob,

We're looking at pproviding more KPIs in version 2 but if you want to go ahead and fiddle with the code then by all means, go ahead. :)

-Jamie

August 17, 2007 5:13 PM
 

There's Something about SQL! said:

Have you ever thought about monitoring your SQL Server installation from Windows Vista Sidebar? Well,

August 22, 2007 2:26 PM
 

Paul said:

How about a gadget that will display any PerfMon counter(s)?

October 18, 2007 5:35 PM
 

oyun said:

very thanks

April 28, 2008 11:30 PM
New Comments to this post are disabled

This Blog

Syndication

Powered by Community Server (Personal Edition), by Telligent Systems