Dear All Experts,
I'm Usually Tuning SQL Server 2012 by this step
- Shrink Database
- Reorganize index and Rebuild index
- I'm Keep separate the Transaction log file(.ldf) and Data file (.mdf)
But I would like to know is that i'm tuning on the right way on SQL Server Administration ,Could you please suggest to me the way or how to Tuning SQL server ,i'm looking forward to your answer.
P.S. Right now i'm got the problem with the Extension size of Transaction log file it grow everyday ,i've shrink it already but still more large size for my disk (i have 200 GB and i'm keep the .mdf and .ldf together in there ,now size of .ldf is 180GB) ,One More Question is how to resize the transaction log file to be small than 180 ,i'm wonder when i'm clear the transaction log file it will impact to my company data ,so could you all experts suggest me how to do? Is there the way resize to smaller than 180 GB but the data still not impact? or it's have no way to do that.
Thank you very much for your attention to read my problem ,i'm looking forward to your answer. That's very kind of you all.