• Truncating your log files, eeesh, you need to put some proper transaction log management in place, regular shrinking of files is not best practise.

    http://www.sqlservercentral.com/stairway/73776/

    Also get a copy of the accidental DBA guide and read through all of it, again link in my signature for that eBook - has a full section on transaction logs and other main issues faced.

    Don't use maintenance plans, they are very static in what do and dont provide any flexability, instead look at Ola's scripts (Link in my signature) they will do all your maintenance needs, backups, index rebuilds, statistic updates etc.

    As for getting the execution plan, again look in my signature on posting performance problems, it tells you how to get the plan.