Re: SQL Server DBA Tools

gowens_at_nixonpeabody.com
Date: 02/01/05 

Date: 1 Feb 2005 06:01:30 -0800

Dejan, thanks for the reply. I've previously looked at these tool
suites - they're very good but not what I'm really after at this point.
After having looked around the internet it really appears that there
are no cross-server, multi-database documenting/management tools. I
guess that I'm destined to write something...

Regards.

Dejan Sarka wrote:
> 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: Create indexed view
    ... Columnist, SQL Server Professional ... "Dejan Markic" wrote in message ... I'm just interested about the query with which I can ... select id,name from t1 union all ...
    (microsoft.public.sqlserver.programming)
  • Re: Login failure
    ... i got the solution atlast. ... from there connection is being established and sql server ... >hi dejan ...
    (microsoft.public.sqlserver.security)
  • Re: Login failure
    ... changing the registry of sql server 7 from 1 to 0 the ... >mode Windows Only). ... Try to connect with sa login. ... >Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Windows authentication failed on SQL2000 +NT4
    ... Thanks for your reply Dejan, ... followed the instructions from the SQL Server Book. ... > You have to grant access to SQL Server to Win users and groups. ...
    (microsoft.public.sqlserver.security)