SQL ldf file still showing old size
staggerlee
Posts: 6
Hi all,
I recently had the joy of shrinking a 20gb .ldf file down to 2gb as it was to say the least massively over sized.
When i go to sqlmonitor analysis it shows it at 20gb still in the "Log Size" menu. Any ideas why its not getting the right size?
Thanks
s
I recently had the joy of shrinking a 20gb .ldf file down to 2gb as it was to say the least massively over sized.
When i go to sqlmonitor analysis it shows it at 20gb still in the "Log Size" menu. Any ideas why its not getting the right size?
Thanks
s
Comments
Thanks for your post.
The size may not have been updated as it depends on the data collection frequency i.e. if you have shrunk the log files then the size changes won't get reflected on overviews till the next data collection has taken place. Every data is collected at different frequency.
Regarding Analysis page, SQL Monitor plots a maximum of 500 data points and then draws straight lines between consecutive points. So in this case, it would have joined the data points which might look like slow decreasing size. You can read more about it if you click blue help icon on Analysis page.
Hope this helps.
Thanks,
Priya
Project Manager
Red Gate Software