Has anyone had sysaltfiles provide incorrect size value for tempdb.
All other means for finding data file size are showing accurate results expect sysaltfiles.
select db_name(dbid),name,size/128 from master.dbo.sysaltfiles
where db_name(dbid) like 'tempdb'
GO
select size/128,name from tempdb.dbo.sysfiles
GO
DBCC SHowfilestats
GO
Select counter_name,instance_name,cntr_value/1024 as size
from master..sysperfinfo
where [object_name] like '%SQLServer:Databases%'
and instance_name like '%tempdb%'
and counter_name like '%Data File(s) Size (KB)%'
On the disk my tempdb 68 GB but sysaltfiles tells me that its only 8 mb :crazy:
I am attaching the screenshot of the same. I am on sql 2000 + sp4 + with latest possible hotfix. Please let me know if i am missing something