declare @pagesize int
select @pagesize=(select @@maxpagesize)
SELECT Database Name = CONVERT(char(20), db_name(D.dbid)),
Data Size = STR(SUM(CASE WHEN U.segmap != 4 THEN U.size*@pagesize/1048576 END),10,1),
Used Data = STR(SUM(CASE WHEN U.segmap != 4 THEN size - curunreservedpgs(U.dbid, U.lstart, U.unreservedpgs)END)*@pagesize/1048576,10,1),
Data Full% = STR(100 * (1 - 1.0 * SUM(CASE WHEN U.segmap != 4 THEN curunreservedpgs(U.dbid, U.lstart, U.unreservedpgs) END)/SUM(CASE WHEN U.segmap != 4 THEN U.size END)),9,1) + %,
Log Size = STR(SUM(CASE WHEN U.segmap = 4 THEN U.size*@pagesize/1048576 END),10,1),
Free Log = STR(lct_admin(logsegment_freepages,D.dbid)*@pagesize/1048576,10,1),
Log Full% = STR(100 * (1 - 1.0 * lct_admin(logsegment_freepages,D.dbid) /
SUM(CASE WHEN U.segmap = 4 THEN U.size END)),8,1) + %
FROM master..sysdatabases D,
master..sysusages U
WHERE U.dbid = D.dbid
AND ((D.dbid > 3) AND (D.dbid < 31513) AND (D.status != 256))
...

Hi,

Is anybody is having an idea about How to get the max tempdb usage and max log file usage for user database till date.

--Ganesh.