|
Home > Archive > Microsoft Content Management Server > May 2006 > Node-Cache-Size over 35000
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Node-Cache-Size over 35000
|
|
|
| Hi,
we have MCMS2002 SP1a with SQL2000SP3 EN loadbalanced with AC2000 under
framework 1.0 running. We have about 24.000 Postings and 13.000 Channels
comming to an database size of about 4-6 GB.
If we execute the following two SQL-Scipts (s. PS) to get a value for the
node cache, two different values are supplied:
1) 40770
2) 60646
http://support.microsoft.com/default.aspx?kbid=318976 says that you should
not increase node cache size beyound 35000 without proper testing.
Any experiences with node-cache over 35000?
How many RAM is recommended for 40000 or 60000?
thanx in advance
jens
PS:
1)
SELECT ceiling(count(*) * 1.5) FROM node
WHERE (type = 16
AND name IS null
AND isshortcut = 1
AND followguid IS NOT null
AND (datediff(hour, effectivedate, getdate()) > 1
or
effectivedate IS null)
AND datediff(hour, expirydate, getdate()) < 1
AND datediff(hour, approvedwhen, getdate()) > 1
AND (datediff(hour, archivedwhen, getdate()) < 1
or
archivedwhen IS null)
)
OR
(type = 256
AND (datediff(hour, effectivedate, getdate()) > 1
or
effectivedate IS null)
AND datediff(hour, expirydate, getdate()) < 1
AND datediff(hour, approvedwhen, getdate()) > 1
AND (datediff(hour, archivedwhen, getdate()) < 1
or
archivedwhen IS null)
)
OR
(type = 65536
AND (datediff(hour, effectivedate, getdate()) > 1
or
effectivedate IS null)
AND datediff(hour, expirydate, getdate()) < 1
AND (datediff(hour, archivedwhen, getdate()) < 1
or
archivedwhen IS null)
)
AND id > 26
AND isbeinginserted = 0
AND (datediff(hour, deletedwhen, getdate()) < 1
or
deletedwhen IS null)
2)
SELECT count(*) FROM node
WHERE (datediff(hour, archivedwhen, getdate()) < 1
OR archivedwhen IS null)
AND (deletedwhen is NULL)
AND datediff(hour, expirydate, getdate()) < 1
AND (datediff(hour, effectivedate, getdate()) > 1
OR effectivedate IS null)
AND (datediff(hour, approvedwhen, getdate()) > 1
OR (type >= 65535 and approvedwhen is null))
| |
| Stefan [MSFT] 2006-05-18, 1:15 pm |
| Hi Jens,
script 1 is outdated as it does not use all relevant nodes.
Only the second script will give you reliable results.
35000 is only a rule of thumb number as the size of a node is not fixed.
Nodes vary with the amount of data in placeholders. So if you are holding
large amount of content in placeholders on a posting the nodes size will be
higher as if you are only holding a couple of bytes.
We have customers who ran into problems when going beyond 10000 as they had
copied large pages into the placeholders.
Other customers are running fine with more than 70000.
The memory model of your machine is also relevant: with /2GB mode you will
not be able to use the same cache size as in /3GB mode.
Please look at the maximum size of your process. With /2GB mode it should
stay below 700 MB. With /3GB mode it should stay below 1700 MB.
If it is below you are able to increase the node cache size if required.
But be aware that ASP.NET output caching is much more important for a good
performance than the node cache size!
Cheers,
Stefan
--
This posting is provided "AS IS" with no warranties, and confers no rights
New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------
"jens" <jens@discussions.microsoft.com> wrote in message
news:C5C4FE64-3E72-443D-9D3C-CA193FF7E7FB@microsoft.com...
> Hi,
>
> we have MCMS2002 SP1a with SQL2000SP3 EN loadbalanced with AC2000 under
> framework 1.0 running. We have about 24.000 Postings and 13.000 Channels
> comming to an database size of about 4-6 GB.
>
> If we execute the following two SQL-Scipts (s. PS) to get a value for the
> node cache, two different values are supplied:
>
> 1) 40770
>
> 2) 60646
>
>
> http://support.microsoft.com/default.aspx?kbid=318976 says that you should
> not increase node cache size beyound 35000 without proper testing.
>
> Any experiences with node-cache over 35000?
> How many RAM is recommended for 40000 or 60000?
>
> thanx in advance
> jens
>
>
> PS:
>
> 1)
> SELECT ceiling(count(*) * 1.5) FROM node
> WHERE (type = 16
> AND name IS null
> AND isshortcut = 1
> AND followguid IS NOT null
> AND (datediff(hour, effectivedate, getdate()) > 1
> or
> effectivedate IS null)
> AND datediff(hour, expirydate, getdate()) < 1
> AND datediff(hour, approvedwhen, getdate()) > 1
> AND (datediff(hour, archivedwhen, getdate()) < 1
> or
> archivedwhen IS null)
> )
> OR
> (type = 256
> AND (datediff(hour, effectivedate, getdate()) > 1
> or
> effectivedate IS null)
> AND datediff(hour, expirydate, getdate()) < 1
> AND datediff(hour, approvedwhen, getdate()) > 1
> AND (datediff(hour, archivedwhen, getdate()) < 1
> or
> archivedwhen IS null)
> )
> OR
> (type = 65536
> AND (datediff(hour, effectivedate, getdate()) > 1
> or
> effectivedate IS null)
> AND datediff(hour, expirydate, getdate()) < 1
> AND (datediff(hour, archivedwhen, getdate()) < 1
> or
> archivedwhen IS null)
> )
> AND id > 26
> AND isbeinginserted = 0
> AND (datediff(hour, deletedwhen, getdate()) < 1
> or
> deletedwhen IS null)
>
>
>
> 2)
> SELECT count(*) FROM node
> WHERE (datediff(hour, archivedwhen, getdate()) < 1
> OR archivedwhen IS null)
> AND (deletedwhen is NULL)
> AND datediff(hour, expirydate, getdate()) < 1
> AND (datediff(hour, effectivedate, getdate()) > 1
> OR effectivedate IS null)
> AND (datediff(hour, approvedwhen, getdate()) > 1
> OR (type >= 65535 and approvedwhen is null))
>
|
|
|
|
|