Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006


Dbcc mistakes

After installing the dbcc databases (master database), the Executive dbcc_checkstorage (master), when there are mistakes :
Checking master : Logical pagesize is 4096 bytes
Msg 9978, Level 17, State 1
The 32K buffer cache configured in the pool is too small. 1280K is the minimum size.
DBCC CHECKSTORAGE for database 'master' encountered an error. Some results may not be available. Correct the problems reported and reexecute the CHECKSTORAGE command.

Sp_plan_dbccdb operation of the results are as follows :
Dbname scan text traction traction cache process count

Master 640K 192K 96K 1

I will allocate the number of worker processes become established 4

I use the following two ordered to reform to change the value of the buffer pool are not successful, we always reported the above information.
Sp_cacheconfig master_cache "3072K"
Sp_poolconfig master_cache, "1280", "DCD"

Please heroes Devices, hurry! Em02 : :

Sp_poolconfig master_cache, "1280", "32K"

Recently tend to be busy, not to the forum.

Thank you, according to your xp1999 said, the problem has been resolved!



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com