Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance Issue MSSQL 2005

Hello Expert,

I have a quality system running on MS SQL Server 2005 & Netwever 7.02. I am experiencing a very poor performance recently & it was working fine couple of week ago.

I had some investigation and can see that the drive that hold the transaction log is left with space only 10 MB. it is also set to increase by 10%.

Will my system performance will temporary improve if I shrink the Transaction log file? What is the step involved? How much time will it take to shrink log of size around 57 GB?

Please help me if there is some other way to address the issue. Please let me know for any information required.

Regards

Suri

replied

Hi Surymani Yadav,

It looks like that you database has "FULL" recovery model, you don't backup Transaction Log file.

You should schedule Transaction Log backup job and after several backup events you can shrink down the Transactin Log. It will improve performance.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question