Re: SQL Server DBA Tools

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 08:49:15 +0100

Here are some useful links:
http://imceda.com
http://www.apexsql.com/frame_home.htm
http://red-gate.com/ 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
<gowens@nixonpeabody.com> wrote in message
news:1107237785.415880.177570@c13g2000cwb.googlegroups.com...
> I'm very new to the SQL Server DBA world. We have a number of servers
> with 100+ SQL Server databases. To date these databases have little or
> no consistent management, documentation etc.
>
> I've been tasked with documenting the db instances across all of the
> servers (to get a handle on where we stand: access, maintenance, job
> schedules, etc) and to come up with a means to consolidate/centralize
> DBA support for the db environment (probably going to leverage the
> multi-server administration capabilities).
>
> We are a Microsoft shop and I'm acquainted with Enterprise Manager and
> many of the sp_help* stored procedures.
>
> What I would like to have is a tool that can provide a cross-server
> look at all/selected db instances and return the data in tables. It
> would be great if this tool could mine general database information:
> maintenance schedules, database status, size, etc and provide this in a
> DataGrid-like format so that it would be "easy" to examine/compare.
>
> I realize that this is a tall order and, if necessary, I'm prepared to
> write an ASP.Net GUI to access the sp_help*, etc stored procedures.
> Anyway, any tips/opinions are welcome!
>
> Glenn
>

Relevant Pages

  • Re: why>?
    ... On your desktop-- you'll be running SQL Server behind the scenes. ... it isn't risky to allow end users to create databases. ... it is no more risky than giving you the ability to create spreadsheets. ... I'm not saying that Oracle and IBM are going away. ...
    (microsoft.public.excel)
  • Re: Please answer my queries for fresh Installation
    ... Moving SQL Server Databases ... Using WITH MOVE in a Restore to a New Location with Detach/Attach ... Disaster Recovery Articles for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL Server 2000 from NT4.0 to Windows 2003
    ... Detach your existing user databases, ... user databases (or RESTORE) to the new server. ... > Hey Steve, ... Windows 2003 will not allow SQL Server SP less than 3. ...
    (microsoft.public.sqlserver.server)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... MDB is friggin dead.. ... SQL Server has taken over the world. ... than read-only access to central company databases. ... I learned to write queries in Access after an hours' ...
    (microsoft.public.excel)