DBCC fileHeader sectorsize and actualsize difference
-
Sunday, October 14, 2012 11:01 AM
I installed sql server 2008 on my system and create 1 user Db. when i executed
dbcc fileheader('master')
sectorsize and actualsize were 4096 and 512 bytes respectivley.
and for user database
sectorsize and actualsize were 512 and 512 bytes respectivley.
why sectorsize is completely different for this DB?
what tthe diference between sectorsize and actualsize?
regards,
Manish
Manish
All Replies
-
Monday, October 15, 2012 1:01 AM
Vikas Rana | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker -------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. --------------------------------------------------------------------------------
- Proposed As Answer by Vikas RanaMicrosoft Employee Wednesday, October 17, 2012 1:53 AM
-
Wednesday, October 17, 2012 9:06 AMHere another question arises why do the sector size different for System DB and user DB?
Manish
-
Thursday, October 18, 2012 6:05 AM
Because sector size was 4096 where system database got created(except TEMPDB).
Vikas Rana | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker -------------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. --------------------------------------------------------------------------------
-
Wednesday, October 24, 2012 1:59 PMBut it is not common.
Manish
.png)
