I have problem which must be due to my idiotness. when i use the command...

1> sp_poolconfig "default data cache", "20M", "16K"
2> go
Msg 18144, Level 16, State 1:
Server 'DACS', Procedure 'sp_do_poolconfig', Line 580:
Source pool (1p) and destination pool (16K) are the same pool. The source and
destination pools must be different.
(return status = 1)

Now as i understand there is a 2k cache as default where the 16K pool should be supplied from ? Have I got this right ? Although when i use ...

1> sp_cacheconfig "default data cache"
2> go
Cache Name Status Type Config Value Run Value
------------------ -------- -------- -------------- ------------
default data cache Active Default 40.00 Mb 40.00 Mb

(1 row affected)
------------ ------------
Total 40.00 Mb 40.00 Mb
================================================== ========================
Cache: default data cache, Status: Active, Type: Default
Config Size: 40.00 Mb, Run Size: 40.00 Mb
Config Replacement: strict LRU, Run Replacement: strict LRU
Config Partition: 1, Run Partition: 1
IO Size Wash Size Config Size Run Size APF Percent
-------- ------------- ------------ ------------ -----------
16 Kb 8192 Kb 40.00 Mb 40.00 Mb 10
(return status = 0)


I do not see the 2k pool .

Could someone be kind enough to give me a few pointers as i am new to this type of dbase language.
Many Thanks
Steve

What is select @@maxpagesize
The smallest pool will be equal to that size

I get the following so does this mean i have no 2k pool as default ? And does this mean i have to state a source of 16K .? If so how do i do that ? - tks

1> select @@maxpagesize
2> go

-----------
16384

(1 row affected)

Yes, your default is 16k
So you can create a 128k pool for large I/O

(2k page server) * (8 extents) = 16k pool
(4k page server) * (8 extents) = 32k pool
(8k page server) * (8 extents) = 64k pool
(16k page server) * (8 extents) = 128k pool