Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
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
| |  Satish Ahirkar
SAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight  _.____.__ |
