/* 데이터파일조사 */
declare @DataSpace table
(
 fileid  int,
 filegroup int,
 TotalExtent bigint,
 UsedExtent bigint,
 LogicalName varchar(200),
 FileFullName varchar(5000)
)

Insert into @DataSpace
EXEC('DBCC showfilestats')
select fileid, filegroup,
 cast(TotalExtent*8*8/1024.0 as decimal(10,2)) as [Total(MB)],
 cast(UsedExtent*8*8/1024.0 as decimal(10,2)) as [Used(MB)],
 cast((TotalExtent- UsedExtent)/(TotalExtent * 1.0)*100 as decimal(10,2)) as [Remain(%)],
 LogicalName, FileFullName
from @DataSpace
----------------------------------
/* 로그파일조사 */
declare @LogSpace table
(
 DBName     varchar(200),
 [Log Size(MB)]   decimal(20,4),
 [Log Space Used (%)] decimal(20,4),
 status     int
)
Insert into @LogSpace
EXEC('dbcc sqlperf(logspace) with no_infomsgs')
select *
from @LogSpace
where dbname =
 (
  select D.Name
  from master.dbo.sysprocesses as P
   join master.dbo.sysdatabases as D on P.dbid = D.dbid
  where P.spid = @@spid
 ) -- 현재접속한 DB만 리턴