Taille de tempdb – Scripts Center

Ce script permet de connaître la taille configurée d’origine ainsi que la taille actuelle des fichiers de tempdb (et donc de constater s’il y a eu accroissement)

/*-------------------------------------------------------------------
[SCRIPT] tempdb size   
[DESCRIPTION] get original size and actual size of tempdb files
[MAJ PAR] DATAFLY - Arian Papillon
-------------------------------------------------------------------*/
SELECT alt.filename
     , alt.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  dbid = DB_ID('tempdb');

/*-------------------------------------------------------------------

[SCRIPT] tempdb size

[DESCRIPTION] get original size and actual size of tempdb files

[MAJ PAR] DATAFLY - Arian Papillon

-------------------------------------------------------------------*/

SELECT alt.filename

, alt.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 dbid = DB_ID('tempdb');