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.



Former Member
Former Member 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

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