Hello all, I am looking to build a system for my shop. Currently we have no good way to track anything about our databases except through ad hoc queries, but with that we don't get much history. What I am looking for is either a good idea of where to start. I have found something called the DBA repository, but after taking a quick look at the database design, it isn't something I want to implement. I need something like the DBA Repository, but better. Is there anything like that out there (that isn't a software like SolarWinds)? Currently this is just a project that I have going on so I don't have a lot of internal support. Thanks for the help.
If you don't like Rodney Landrum's SQL Depository, then try [David Bird's SQL Overview]. I've used it for monitoring up to 120 servers without any major problems. But, as @David Wimbush says, without knowledge of what you want, it's difficult for us to recommend anything. :