October 3, 2005 at 4:02 am
Hi!
Found this in a job description:
Tuning of the SQL Server specific database parameters, including:
...
• Database page sizes
• Cache sizes
...
I always believed that MS SQL Server has fixed page size and cash size is allocated dynamically, depending on the available memory and both of these features do not allow manual configuration. Am I wrong?
Thanks.
October 3, 2005 at 8:30 am
No, you are not wrong.
October 3, 2005 at 8:33 am
You are mostly right. Page sizes cannot be changed, and cache size cannot be changed directly (though indirectly by modifying the entire amount of memory available to SQL Server). The ad was probably written by some Oracle-person or similar that have no idea about how SQL Server works.
October 4, 2005 at 11:53 am
Chris, you neglected to mention 'Sybase' ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply