asked on Automated SQL Server database Rebuild Indexes and Update Statistics maintenance task ?
Hi All,
I'm about to implement Rebuild Indexes and Update Statistics maintenance job for all of my SQL Server 2012 Standard Database in my Physical box, is there any issue or caveats that I need to know before hand ?
I assumethat this maintenance task can be done while the database is online (no outage required).
Reference: https://www.veritas.com/support/en_US/article.000040169
Thanks,
I'm about to implement Rebuild Indexes and Update Statistics maintenance job for all of my SQL Server 2012 Standard Database in my Physical box, is there any issue or caveats that I need to know before hand ?
I assumethat this maintenance task can be done while the database is online (no outage required).
Reference: https://www.veritas.com/support/en_US/article.000040169
Thanks,
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft SQL Server 2005
Last Comment
Albert Widjaja
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
ok, do I just copy paste the Ola's script I can just run it as scheduled task / sql agent job ?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Take the time and sit through Ola's video, it's quite useful in my opinion and could answer quite a few questions you might have about how best to use his work. It's a recorded meeting and has a question/answer period.
ASKER
OK, so now I have downloaded the script attached MaintenanceSolution.sql which will be creating the necesary objects and also the stored procedures.
After that I can just schedule the Rebuild or reorganize all indexes with fragmentation on all user databases, performing sort operations in tempdb and using all available CPUs
Is that correct ?
Do I need to change the USER_DATABASES with the name of the Databases or not ?
MaintenanceSolution.sql
After that I can just schedule the Rebuild or reorganize all indexes with fragmentation on all user databases, performing sort operations in tempdb and using all available CPUs
EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@SortInTempdb = 'Y',
@MaxDOP = 0
Is that correct ?
Do I need to change the USER_DATABASES with the name of the Databases or not ?
MaintenanceSolution.sql
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks !
This is for other database as well not for Symantec EV.