July 6, 2007 at 11:34 am
Hi,
I am not sure if this is the right place for this but I guess this is general question so it might fit here.
I read an article here at SQLServer Central regarding sizing for databases. At the bottom of the article, there is a link to a SQL script but the link is dead. Does anyone have that script or know of where I can find it? File name of the script is: usp_databases.sql
thank you.
(http://www.sqlservercentral.com/columnists/bknight/sizingadatabase.asp)
July 6, 2007 at 1:21 pm
Fixed!
July 9, 2007 at 12:15 pm
Thank you
April 8, 2008 at 4:00 am
hI There,
Could you let me know where i can find the usp_database sript or what you did you monitor db growth. since you now have it fixed.
my email is vivcollin@hotmail.com
August 1, 2008 at 2:41 am
hello Admin,
the file/link Usp_databases is current broken.
sincerely lars
August 1, 2008 at 4:57 am
Yah it's missing again 🙁
August 1, 2008 at 8:30 am
If it isn't fixed soon, you can find it here. Hope it helps
http://www.sql.ru/subscribe/061.shtml
or
/* Procedure for 8.0 server */
create proc usp_databases
as
set nocount on
declare @name sysname
declare @SQL nvarchar(600)
/* Use temporary table to sum up database size w/o using group by */
create table #databases (
DATABASE_NAME sysname NOT NULL,
size int NOT NULL)
declare c1 cursor for
select name from master.dbo.sysdatabases
where has_dbaccess(name) = 1 -- Only look at databases to which we have access
open c1
fetch c1 into @name
while @@fetch_status >= 0
begin
select @SQL = 'insert into #databases
select N'''+ @name + ''', sum(size) from '
+ QuoteName(@name) + '.dbo.sysfiles'
/* Insert row for each database */
execute (@SQL)
fetch c1 into @name
end
deallocate c1
select
DATABASE_NAME,
DATABASE_SIZE = size*8,/* Convert from 8192 byte pages to K */
RUN_DT=GETDATE()
from #databases
order by 1
GO
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply