September 17, 2013 at 4:30 pm
I am moved to an old project , but sure why but the previous guy was collecting the total extent for the DB everyday . I am assuming that he was trying to get the DB growth . The problem is , when i do the simple calculation of total Extent * 64 * 1024 to the get the actual size of the DB , I am not getting the size of the DB which I see on GUI . Can someone let me know what is that I am missing here ?
I am aware of getting this data using other commands , but I am trying to use the historical data ( using extent ) to get the overall growth story .
September 17, 2013 at 8:37 pm
himanshu.sinha (9/17/2013)
I am moved to an old project , but sure why but the previous guy was collecting the total extent for the DB everyday . I am assuming that he was trying to get the DB growth . The problem is , when i do the simple calculation of total Extent * 64 * 1024 to the get the actual size of the DB , I am not getting the size of the DB which I see on GUI . Can someone let me know what is that I am missing here ?I am aware of getting this data using other commands , but I am trying to use the historical data ( using extent ) to get the overall growth story .
Hi,
The GUI will show datafile + logfile I believe.
(right click database properties - "size")
You could run from the query window: dbcc sqlperf(logspace)
Find your database - add logfile... the previous person I'm guessing was gathering data not log size information.
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀
September 18, 2013 at 1:37 am
himanshu.sinha (9/17/2013)
Can someone let me know what is that I am missing here ?
Unallocated space. Log file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply