Performance Issue MSSQL 2005
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.
Kisselev Yevgeniy 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.