Monitoring and reporting for Veeam Data Platform
Post Reply
albertwt
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

SQL Server database maintenance for VeeamONE ?

Post by albertwt »

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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by Vitaliy S. »

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
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by albertwt »

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.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by Vitaliy S. » 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
Veeam Legend
Posts: 879
Liked: 46 times
Joined: Nov 05, 2009 12:24 pm
Location: Sydney, NSW
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by albertwt »

Ah I see,

So is it for the next VeeamONE Update 3 ? or the next Veeam 9 ?
--
/* Veeam software enthusiast user & supporter ! */
Vitaliy S.
VP, Product Management
Posts: 27055
Liked: 2710 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server database maintenance for VeeamONE ?

Post by Vitaliy S. »

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 7 guests