Shaun Finnegan (7/15/2014)
I'd first try to update the stats on the database that has the performance issues to see if that helps. Looks like you have alot of free space on your drives, how often do you intend to do the rebuild?
Is your tempdb on a separate drive?
Out of curiosity, I see that you have two log files on your database, is there a specific reason for this?
I perform the rebuild /reorganize everyday
( based on logic : rebuild if index fragmentation above 50% else reorganize)
no they are in the same drive ...FYI log 1 in the E:\ and log 2 in the G:\
hmm I guess they are afraid there will be a lot of transactions from that database so it is better to spilt it up ...
BTW can we rollback the rebuild / reorganize ?