brother_of_karamazov
Legendary Poster
You SQL Server folks mind running the statement below and reporting the results?
--BEGIN
Select
cast(alt.filename as char(25)) as 'Filename',
cast (alt.name as char(10)) as 'Database Name',
alt.size * 8.0 / 1024.0 AS [Originalsize (MB)],
files.size * 8.0 / 1024.0 AS [Currentsize (MB)]
FROM master.dbo.sysaltfiles alt
INNER JOIN tempdb.dbo.sysfiles files
ON alt.fileid = files.fileid
WHERE alt.name in ('tempdev','templog')
--END
This will give you the original size of tempdb and its transaction log and also what size it has grown to.
The results (if you hit CTRL-T in query analyzer to get results in text) will look something like this:
Filename Database Name Originalsize (MB) Currentsize (MB)
------------------------- ------------- ---------------------- ----------------------
H:\tempdb.mdf tempdev 8192.0000000 21248.3125000
H:\templog.ldf templog 1024.0000000 1024.0000000
(2 row(s) affected)
Thanks,
Jeff
--BEGIN
Select
cast(alt.filename as char(25)) as 'Filename',
cast (alt.name as char(10)) as 'Database Name',
alt.size * 8.0 / 1024.0 AS [Originalsize (MB)],
files.size * 8.0 / 1024.0 AS [Currentsize (MB)]
FROM master.dbo.sysaltfiles alt
INNER JOIN tempdb.dbo.sysfiles files
ON alt.fileid = files.fileid
WHERE alt.name in ('tempdev','templog')
--END
This will give you the original size of tempdb and its transaction log and also what size it has grown to.
The results (if you hit CTRL-T in query analyzer to get results in text) will look something like this:
Filename Database Name Originalsize (MB) Currentsize (MB)
------------------------- ------------- ---------------------- ----------------------
H:\tempdb.mdf tempdev 8192.0000000 21248.3125000
H:\templog.ldf templog 1024.0000000 1024.0000000
(2 row(s) affected)
Thanks,
Jeff