SQL Server database maintenance for VeeamONE ?

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

SQL Server database maintenance for VeeamONE ?

Veeam Logoby albertwt » Mon 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 ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: SQL Server database maintenance for VeeamONE ?

Veeam Logoby Vitaliy S. » Mon 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?
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server database maintenance for VeeamONE ?

Veeam Logoby albertwt » Mon 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 ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: SQL Server database maintenance for VeeamONE ?

Veeam Logoby Vitaliy S. » Tue 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/library/ms137718(v=sql.120).aspx

P.S. we will be adding this task in our next updates for your convenience.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server database maintenance for VeeamONE ?

Veeam Logoby albertwt » Mon 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 ! */
albertwt
Expert
 
Posts: 607
Liked: 19 times
Joined: Thu Nov 05, 2009 12:24 pm
Location: Sydney, NSW

Re: SQL Server database maintenance for VeeamONE ?

Veeam Logoby Vitaliy S. » Mon 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.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 6 guests