|
Home > Archive > Microsoft Content Management Server > May 2006 > shrink mcms database & performance
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 |
shrink mcms database & performance
|
|
|
| Is it ok to shrink the mcms database on a regular schedule? Will this action
affect any performance?
How to find out the page loading time for different internet speed?
My mcms database has 2250 nodes, most of my pages use outupt caching to
enchance the performance. Is it ok to set the Local Disk cache size to 3000MB
and the nodes in Memory cache to 3000? I am not sure what value I should set
to optimize the performance.
Thanks
| |
| Stefan [MSFT] 2006-05-24, 7:15 pm |
| Hi Mindy,
the number of nodes is not related to the disk cache size.
This only is related to the memory cache.
The amount of disk cache required depends on the size of the resource
gallery items in your database.
For database maintenance see the following article:
http://support.microsoft.com/?id=836646
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
----------------------
"Mindy" <Mindy@discussions.microsoft.com> wrote in message
news:C88F4D7D-9D42-4931-8219-6FA9623BA2F1@microsoft.com...
> Is it ok to shrink the mcms database on a regular schedule? Will this
> action
> affect any performance?
>
> How to find out the page loading time for different internet speed?
>
> My mcms database has 2250 nodes, most of my pages use outupt caching to
> enchance the performance. Is it ok to set the Local Disk cache size to
> 3000MB
> and the nodes in Memory cache to 3000? I am not sure what value I should
> set
> to optimize the performance.
>
> Thanks
| |
|
| Thanks. One more question: how to find out the total size of the resource
gallery? What table of the resource gallery store in mcms db?
For Example, If the resource gallery is 50MB (images and PDF), then what
value should i set for the disk cache size?
"Stefan [MSFT]" wrote:
> Hi Mindy,
>
> the number of nodes is not related to the disk cache size.
> This only is related to the memory cache.
> The amount of disk cache required depends on the size of the resource
> gallery items in your database.
>
> For database maintenance see the following article:
> http://support.microsoft.com/?id=836646
>
> 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
> ----------------------
>
>
> "Mindy" <Mindy@discussions.microsoft.com> wrote in message
> news:C88F4D7D-9D42-4931-8219-6FA9623BA2F1@microsoft.com...
>
>
>
| |
| Stefan [MSFT] 2006-05-29, 5:22 pm |
| Hi Mindy,
the blobtable contains the resources.
The disk cache size needs to be bigger than the size of all resources. So if
50 MB are in the resource galleries you should set it to more than 50 MB.
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
----------------------
"Mindy" <Mindy@discussions.microsoft.com> wrote in message
news:4BD75324-84DD-43BF-809C-72FC14F81EB7@microsoft.com...[vbcol=seagreen]
> Thanks. One more question: how to find out the total size of the resource
> gallery? What table of the resource gallery store in mcms db?
> For Example, If the resource gallery is 50MB (images and PDF), then what
> value should i set for the disk cache size?
>
> "Stefan [MSFT]" wrote:
>
| |
|
| Thanks for the quick response.
I run this sql: select sum(blobSize) from dbo.BlobTable; and it returns
108157418, and i am not sure if this number is in byte, or KB? Please advise.
Thanks
"Stefan [MSFT]" wrote:
> Hi Mindy,
>
> the blobtable contains the resources.
> The disk cache size needs to be bigger than the size of all resources. So if
> 50 MB are in the resource galleries you should set it to more than 50 MB.
>
> 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
> ----------------------
>
>
> "Mindy" <Mindy@discussions.microsoft.com> wrote in message
> news:4BD75324-84DD-43BF-809C-72FC14F81EB7@microsoft.com...
>
>
>
| |
| Stefan [MSFT] 2006-05-29, 5:22 pm |
| Hi Mindy,
I assume this number is in bytes. So this would be 108 MB.
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
----------------------
"Mindy" <Mindy@discussions.microsoft.com> wrote in message
news:3787D404-6B42-44DF-959D-F9EC5D60C2B9@microsoft.com...[vbcol=seagreen]
> Thanks for the quick response.
>
> I run this sql: select sum(blobSize) from dbo.BlobTable; and it returns
> 108157418, and i am not sure if this number is in byte, or KB? Please
> advise.
>
> Thanks
>
> "Stefan [MSFT]" wrote:
>
|
|
|
|
|