:::: MENU ::::

META for SQL Server

Moved all info to www.sqldbasoftware.com  download, read and ask questions from there.

I’m writing a tool for us SQL Server DBA’s, it will be an application that keeps track of servers and instances, their databases and corresponding logins, database files, jobs and stuff.

Can do simple capacity management based on database growth, relative cpu usage and i/o, you can save passwords (encrypted), shows login creation statements, jobs and their create statements, also does some basic sanity checks such as file placements, logins with sysadmin role, slow i/o, missing backups and some other stuff.

Quite simple to use, you setup a database called the repository database, that’s where everything is stored, create connections to other instances you want to monitor and setup how often you want to get new information, how long you want to keep old info and then just let it run.

UPDATE: I have created a Windows service, in the GUI you can set if the GUI should collect information of if the service should. The GUI and the service both check the repository with regular intervals to see if you have changed any settings so no need to restart any of them after a configuration change.

The tool will be free to test for unlimited time, but upgrading to a new major version will require a license, all minor upgrades are free.

If you’re part of a commercial organization, I’d sure appreciate you buying a license. I’ll get back with more information soon how to download and use it. Working on an FAQ page also.

UPDATE:  Added a lof of icons, tooltips and other stuff, also created 2 simple installers, one for the GUI and one for the service, doing a lot of testing now.

Just some simple, though a bit old, screenshots:

Overall statistics page

Database page, here you can add a description of each database and connect a database to an application

Database files, shows number of reads, writes, growth settings and so on

Logins, shows login creation script and allows you to store the password if someone forgets it, the password is automatically stored encrypted in the repository database

Jobs, when they were run, successfull or failed and, if possible, with the job creation script

Checks, shows eg. databases with no recent backup, logins with sysadmin rights, slow i/o, databases on C:, databases in full mode with no log backup and some other basic good to know stuff

Reports page shows you database size over time, also read and write i/o times and also CPU% relative to the other databases in the instance, to find out which databases are using the most resources

 

It is already quite a useful tool and I have a ton of added functionality waiting to be implemented!

//R


So, what do you think ?