June 14, 2002 at 12:36 pm
dbcc sqlperf (logspace) -- Shows all log files for the server.
dbcc showfilestats -- shows all the data files for the current database.
sysfiles -- shows all log and data files for the current database, so 2. One is data file other is log.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 17, 2002 at 12:25 pm
ok i see what is going on...but I have another question, this may sound like a stupid question but i am pretty new to this.
I was wondering the showfilestats is not a type of table you can query from? I just want to get the extentsize and the extentused from this and report it. is there a way to do this? And if possible can you explain how extents and pages works. I've read that "the first eight pages of a table are allocated from mixed extents. Only after the table has reached eight pages does SQLServer allocate uniform extents of eight pages each." i'm not quite understanding this concept.
RICHARD KIRMSS
RICHARD KIRMSS
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply