Viewing 8 posts - 1 through 8 (of 8 total)
MadAdmin (4/19/2016)
From Kimberly Tripp
Performance Test with Zero Initialization
Hardware: Dell Precision 670 Dual Proc (x64) with Dual Core, 4 GB Memory, RAID 1+0 array w/4-142 GB, 15000rpm disks
...
April 20, 2016 at 12:58 pm
r.dragoi-1095738 (4/19/2016)
Hi,There is a nice article here : http://www.sqlpassion.at/archive/2014/02/18/improving-sql-server-performance-by-using-instant-file-initialization/
Cheers,
Robert
Let me check it .
Thanks Robert
April 20, 2016 at 12:06 pm
MadAdmin (3/17/2016)
ZZartin (3/15/2016)
March 18, 2016 at 11:26 am
ZZartin (3/15/2016)
March 15, 2016 at 3:22 pm
ZZartin (3/15/2016)
March 15, 2016 at 3:18 pm
@jigar No i didn't make switched on "Keep index online while re-indexing" but i think online option will not work in SQl server standard 2008r2 edition...
March 15, 2016 at 3:03 pm
yes it rebuilds each of them even if they don't ......!
March 15, 2016 at 2:26 pm
yes , i am running the inbuilt SSMS rebuild index task in the maintenance plans .
March 15, 2016 at 2:08 pm
Viewing 8 posts - 1 through 8 (of 8 total)