Viewing 4 posts - 1 through 4 (of 4 total)
Last Friday I have following the steps for shrinking the VLF-Logging and to change the increase-parameter for autogrow. Changing from 10% to 1GB (because the LOG-File is at the End...
May 11, 2009 at 3:31 am
Thanks for the Link.
I'll checked the numbers of VLF and it's 585.
I will shrink this on Friday (next offline-Time) and will reply the effect on next Monday.
regards
May 5, 2009 at 4:21 am
I now have looked for the CPU
On Production-Server: Intel Xeon(R) CPU 5130 2 GHz
On Test-Server: Intel Xeon(TM) 2,8 GHz
The properties of the Database are on both Systems identical.
The recovery is...
May 4, 2009 at 4:15 am
The values sp_config are on both systems identicly (see below).
[font="Courier New"]
MinMax Config_ValueRun_Value
allow updates 0100
clr enabled0100
cross db ownership...
April 30, 2009 at 6:18 am
Viewing 4 posts - 1 through 4 (of 4 total)