• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 41
  • Last Modified:

EV SQL-2014 and vault stores maintenance plans-EV 12.1

I'm planning to create maintenance plan for enterprise vault 12.1 SQL vault store.
Does it negative impact for our environment if I re-indexing in SQL DBs in maintenance plan?
We are doing these tasks first time in Exchagne 2016 and ev archiving/ev journaling mailboxes and ev sql databases.
Please suggest.


Thanks-sami
0
sami urrahiman
Asked:
sami urrahiman
  • 3
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Yes, you need to perform Index Rebuild/Reorganize for better performance.
Please find the official link from EV on the list of tuning that should be done:
https://www.veritas.com/support/en_US/article.100006827
And the steps to perform Index Rebuild Maintenance plan in the below link
https://www.veritas.com/support/en_US/article.000040169

Above link states for SQL Server 2008 and you can follow similar steps for SQL Server 2014
https://support.symantec.com/en_US/article.HOWTO124446.html
0
 
sami urrahimanSr.Server Management consultant-MessagingAuthor Commented:
Hi Raja,

Can rebuilding indexes cause worse performance after rebuild is finished for EV SQL Databases?

Thanks-Sami
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Nope, ideally Index Rebuild will help in better performance by creating an optimal execution plan.
However there is a catch that the first time execution of queries referring to the rebuilt indexes will force the creation of a new execution plan which can take a little bit longer but it would be insignificant compared to the query running with heavily fragmented indexes.
0
 
sami urrahimanSr.Server Management consultant-MessagingAuthor Commented:
Excellent solution provided by Rajan.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Thanks..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now