Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
If the lige file can be shrunk then you do not need to increase disk space. However you should schedule more frequent log backups to avoid the Log file growing too large.
| | | ---------------Original Message---------------
From: Satish Ahirkar
Sent: Friday, June 24, 2011 2:44 AM
Subject: Log file in db02 & I/O performance showing in red colour
Dear All,
I am using ECC6 with Windows 2003(64bit), Sql Server 2005. Yesterday night I had scheduled the Local Client Copy in a Production, after some time when user was login, he could not login, the system was showing the Sql error. I did check the log file & the problem found in log file, the log file was full, so i opened the sql server management studio and shrink the log file.
When I checked the DB02, the file PDRLOG1 is showing Red colour, also the I/O performance is high. please check the below I/O performance & log file details.
I/O Performance
PDRDATA1 I: Data 89.660 94.268 19.947 86.956 2.676 2.947 0.194 29.501 13.734
PDRDATA2 J: Data 88.219 92.513 18.493 87.084 2.553 2.957 0.182 29.446 14.021
PDRDATA3 K: Data 92.572 97.033 17.702 87.028 2.538 2.983 0.177 29.167 14.277
PDRDATA4 L: Data 93.371 98.050 17.993 87.099 2.553 2.948 0.183 29.541 13.954
PDRDATA5 M: Data 96.131 100.536 18.759 85.286 2.399 2.868 0.163 29.728 14.690
PDRDATA6 N: Data 100.330 104.911 19.639 84.802 2.412 2.867 0.162 29.575 14.819
PDRDATA7 O: Data 109.329 114.653 20.282 87.284 2.522 2.954 0.176 29.546 14.279
PDRLOG1 O: Log 1.953 1.440 8.717 2,267.571 7.139 9.678 0.734 234.284 9.725
LOg File
PDRLOG1 30,003 97.00 0 O:\PDRLOG1\PDRLOG1.ldf 52,744 10MB 30000 Autogrow on, but growth would exceed maxfile size.
Thanks & Regards,
Satish |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  D. Caddick
SAP Basis Top Contributor
Contributed the most posts in a group for 3 consecutive months to earn a Gold Achievement Popular White Papers
In the Spotlight  _.____.__ |
