Re: 64 Bit Server and Page Size


Rob:
As a point of reference, if he goes frm 2K to 16K pages and it
adversely affects performance, how difficult is it to back down from
16K to say 8K or 8K to 4K,etc.
Thanx,
Chris Hatfield
Falls Church, VA
US of A


Generally speaking it's pretty difficult to change server page size either
way. Since this cannot be done through DB dump & load (requires same
pagesize at both sides), you have to migrate your data with BCP or through
proxy tables. The ASE migration tool (sybmigrate) may also be used (it uses
ddlgen to reverse-engineer the schema and copies the data through proxy
tables).
Needless to say, this can be time-consuming for large databases

HTH,

Rob V.


.