Re: SQL Server quick analysis

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

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 15:38:18 -0500

mrdj wrote:
> Has anyone written anything that will take a quick look at all the
> databases, file locations, file sizes, etc. on a SQL Server? Don't
> want to recreate the wheel, but basically I would like to see these
> things without having to go through the tedious steps back and forth
> between sp_helpdb, DBCC SQLPERF(logspace), sp_spaceused, etc.
> Thanks.

You can use the sp_MSForEachDB procedure to make a call to all
procedures. For example:

Exec master..sp_MSForEachDB 'Use "?"; Exec sp_helpdb "?"; Exec
sp_spaceused'

You could also use SQL EM by selecting a database and then View | Task
Pad from the contect menu on the DB. 

-- 
David Gugick
Imceda Software
www.imceda.com

Relevant Pages

  • Re: Big queries
    ... We're thinking of upgrading the back ends to a SQL Server database, but we have no DBA to set this up and maintain it for us. ... I maintain the current Access databases myself and often compact/repair the back ends to keep the databases as small and efficient as possible. ... because from what I've read about SQL Server the file sizes are set at the time of creation--they are never less than or greater than their specified sizes. ...
    (microsoft.public.access.queries)
  • Re: SQL Server quick analysis
    ... "David Gugick" wrote: ... >> databases, file locations, file sizes, etc. on a SQL Server? ...
    (microsoft.public.sqlserver.server)
  • SQL Server quick analysis
    ... file locations, file sizes, etc. on a SQL Server? ... Don't want to recreate the ...
    (microsoft.public.sqlserver.server)
  • 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)