June 14, 2002 at 11:14 am
I just read the article that Steve Jones had written, Automatically gathering server information part 3 and I ran 2 of the pieces of code he had in his article:
1. dbcc sqlperf (logspace)
2. dbcc showfilestats
and I got similar results that he got. however I then ran
select * from sysfiles
and i noticed that there are two different file-id's; 1 and 2. I then re-ran the two previous codes and only the first file-id was being shown and not both.
I was wonering if there is a reason for this.
thanks
rich
RICHARD KIRMSS
RICHARD KIRMSS
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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply