Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
Post Reply
albertwt
Expert
Posts: 640
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

SQL Server database maintenance for VeeamONE ?

Post by albertwt » Nov 16, 2015 11:56 am

Hi All,

Does anyone here know what's the best way to perform SQL Database maintenance for Veeam ONE monitor DB ?

is it really necessary ?

Thanks,
--
/* Veeam software enthusiast user & supporter ! */

Vitaliy S.
Product Manager
Posts: 22521
Liked: 1471 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by Vitaliy S. » Nov 16, 2015 12:30 pm

All regular maintenance tasks are already scheduled, so you should be good here. Apart from that, depending on the size of the infrastructure, sometimes we require to do indexing/rebuild indexes for particular tables. What size of the infrastructure do you currently have?

albertwt
Expert
Posts: 640
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by albertwt » Nov 16, 2015 9:39 pm

Hi Vitaliy,

Size is not that big:

1x VCenter
16x ESXi on HP Blades
170+ Vms running at the moment.

So by default is there any SQL Agent task to do this maintenance ? Or do I need to create it manually ?
--
/* Veeam software enthusiast user & supporter ! */

Vitaliy S.
Product Manager
Posts: 22521
Liked: 1471 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by Vitaliy S. » Nov 17, 2015 10:26 am 1 person likes this post

Ok, in this case you may want to schedule index rebuild on weekly basis. Here is an existing article for more info on how to do it > https://technet.microsoft.com/en-us/lib ... .120).aspx

P.S. we will be adding this task in our next updates for your convenience.

albertwt
Expert
Posts: 640
Liked: 20 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by albertwt » Nov 23, 2015 1:01 am

Ah I see,

So is it for the next VeeamONE Update 3 ? or the next Veeam 9 ?
--
/* Veeam software enthusiast user & supporter ! */

Vitaliy S.
Product Manager
Posts: 22521
Liked: 1471 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by Vitaliy S. » Nov 23, 2015 9:58 am

v9 is in the code lock state and is coming soon. This task is optional and most likely will be in the next updates.

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests