Custom Stored proc to run DBCC SQLPERF(LOGSPACE)/DBCC SHOWFILESTATS

Completed Posted Oct 9, 2008 Paid on delivery
Completed Paid on delivery

I need a stored procedure which can do the following tasks

from a centralized server:

a. Run DBCC SQLPERF(LOGSPACE) and collect the transaction log space usage statistics for all

the databases on that specific server.

b. Run DBCC SHOWFILESTATS.

The procedure should iterate through a list of servers, and capture the information

on the databases on each server.

The list of servers should be a table where you cans set the server status.

For eg:

CREATE TABLE [dbo].[ServerList](

[ServerName] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[IsActive] [bit] NULL

) ON [PRIMARY]

The proc should be SQL server 2000/2005 compatible.

Also the results should be dumped to a table on the central server.

Please do not use OPENQUERY to do this.

One of the ways could be either global temp tables or using sp_msforeachdb.

Take a look at this article for more ideas:

[url removed, login to view]

Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #3296185

About the project

3 proposals Remote project Active Oct 14, 2008

Awarded to:

siberiangirl

See private message.

$34 USD in 4 days
(129 Reviews)
5.9

3 freelancers are bidding on average $34 for this job

serkanarslan

See private message.

$42.5 USD in 4 days
(62 Reviews)
5.8
frkbucv

See private message.

$25.5 USD in 4 days
(1 Review)
0.0