Lag in database 3

[brendan.henderson]

Can anybody shed some light on why 1 database in particular takes so long to complete the backup? Over the last 6 months it's gone from 1 hour between database 3 & 4 to now being 6-7 hours. The backup is working perfectly, it's just that the Vault backup is not completing before the start of another server tape backup starts, whicj includes the vault server, so sometimes the Vault database is not being included in the tape backup.

[tannro]

Are you running a SQL maintenance plan?  Details are available in the Advanced Configuration Guide on the Autodesk Vault Wiki http://wikihelp.autodesk.com/Vault/enu/Help/Help/0206-Autodesk206/0264Advanced_Configuration

"SQL Maintenance Plans
Maintenance plans can be used to schedule tasks required to make sure that the database
performs well, such as keeping database and transaction log file sizes small and checking the
database for inconsistencies."

[brendan.henderson]

Thanks Ross.

I just heard from the VAR. The SQL Maintenance Plan was setup up. VAR says :-

'You cannot do much about the ADMS backup taking this long, all we can do is on server 2008, the scheduled task can be bumped up as a priority and I think it will run faster'

They are sending me info on how to do this.

Below is the documentation of the Vault install/upgrade :-

The following tasks were completed on the current Vault server keoghfs2
1. Updated OS to SP2 which was a minimum requirement of ADMS 2012
2. Un-installed SQL 2008 Express and ADMS 2011
3. Installed SQL 2008 R2 Standard with instance name AUTODESKVAULT. Instance
was installed in D:\Program Files\Microsoft SQL Server
4. Installed ADMS 2012 SP1 + Hotfix (DL18480860)
5. Restored Vault 2011 backup as of 11 May 2012
6. Installed default read only CC libraries
7. Set Up SQL Maintenance Plan
8. Modified Vault backup script to suit 2012

[Greatwhitenorth]

Hi Brendan,

FWIW, before changing the scheduled task priority from the default 7 to 4, our batch file was taking 10 hours.  After the change, it now takes 2 1/2 hours.

Bob

[karthur1]

How did you change the priority?

[Greatwhitenorth · Accepted solution]

I followed these instructions.

http://crackingthevault.typepad.com/crackingthevault/2011/05/improving-performance-of-vault-server-b...

[brendan.henderson]

Thanks Bob.

If I take out the time for database 3 then the backup for the other 8 databases would take 16 minutes! See below snippet from the report. I have made the priority change and will see the result (hopefully good) tomorrow morning.

1/08/2012 7:03:01 PM Backing Up Databases... 1/9
1/08/2012 7:06:38 PM Backing Up Databases... 2/9
1/08/2012 7:06:39 PM Backing Up Databases... 3/9
2/08/2012 2:05:26 AM Backing Up Databases... 4/9
2/08/2012 2:05:48 AM Backing Up Databases... 5/9
2/08/2012 2:05:49 AM Backing Up Databases... 6/9
2/08/2012 2:05:51 AM Backing Up Databases... 7/9
2/08/2012 2:05:55 AM Backing Up Databases... 8/9
2/08/2012 2:05:58 AM Backing Up Databases... 9/9
2/08/2012 2:16:45 AM The backup operation has been successfully finished.

[brendan.henderson]

Before the priority increase backup took 7.5 hours :-

1/08/2012 6:50:32 PM ==================================================================
1/08/2012 6:50:32 PM Logging initiated: Core server version 16.1.58.120
1/08/2012 6:50:32 PM ==================================================================
1/08/2012 6:50:32 PM
1/08/2012 6:50:32 PM -Obackup -B"D:\VaultBackup\A" -L"D:\VaultBackUp\VaultBackUpLog.txt" -VU[username] -VP[password] -S -DBSC
1/08/2012 6:50:35 PM ==================================================================
1/08/2012 6:50:35 PM BACKUP PROGRESS: The server console is currently in the process of backing up a database set. Please wait...
1/08/2012 6:50:35 PM ==================================================================
1/08/2012 7:00:06 PM Backing Up Databases... 0/9
1/08/2012 7:03:01 PM Backing Up Databases... 1/9
1/08/2012 7:06:38 PM Backing Up Databases... 2/9
1/08/2012 7:06:39 PM Backing Up Databases... 3/9
2/08/2012 2:05:26 AM Backing Up Databases... 4/9
2/08/2012 2:05:48 AM Backing Up Databases... 5/9
2/08/2012 2:05:49 AM Backing Up Databases... 6/9
2/08/2012 2:05:51 AM Backing Up Databases... 7/9
2/08/2012 2:05:55 AM Backing Up Databases... 8/9
2/08/2012 2:05:58 AM Backing Up Databases... 9/9
2/08/2012 2:16:45 AM The backup operation has been successfully finished.
2/08/2012 2:16:46 AM Connectivity.Request.Common.RequestLibrary - RequestRuntimeStop()
2/08/2012 2:16:46 AM Connectivity.Request.Vault.RequestLibrary - RequestRuntimeStop()
2/08/2012 2:16:46 AM Connectivity.Request.Foundation.RequestLibrary - RequestRuntimeStop()
2/08/2012 2:16:46 AM Connectivity.Request.Document.RequestLibrary - RequestRuntimeStop()

After the priority increase backup took 2 hours :-

2/08/2012 6:07:29 PM ==================================================================
2/08/2012 6:07:29 PM Logging initiated: Core server version 16.1.58.120
2/08/2012 6:07:29 PM ==================================================================
2/08/2012 6:07:29 PM
2/08/2012 6:07:29 PM -Obackup -B"D:\VaultBackup\A" -L"D:\VaultBackUp\VaultBackUpLog.txt" -VU[username] -VP[password] -S -DBSC
2/08/2012 6:07:32 PM ==================================================================
2/08/2012 6:07:32 PM BACKUP PROGRESS: The server console is currently in the process of backing up a database set. Please wait...
2/08/2012 6:07:32 PM ==================================================================
2/08/2012 6:16:54 PM Backing Up Databases... 0/9
2/08/2012 6:20:06 PM Backing Up Databases... 1/9
2/08/2012 6:23:46 PM Backing Up Databases... 2/9
2/08/2012 6:23:47 PM Backing Up Databases... 3/9
2/08/2012 8:05:42 PM Backing Up Databases... 4/9
2/08/2012 8:05:44 PM Backing Up Databases... 5/9
2/08/2012 8:05:45 PM Backing Up Databases... 6/9
2/08/2012 8:05:48 PM Backing Up Databases... 7/9
2/08/2012 8:05:51 PM Backing Up Databases... 8/9
2/08/2012 8:05:52 PM Backing Up Databases... 9/9
2/08/2012 8:12:17 PM The backup operation has been successfully finished.
2/08/2012 8:12:23 PM Connectivity.Request.Common.RequestLibrary - RequestRuntimeStop()
2/08/2012 8:12:23 PM Connectivity.Request.Vault.RequestLibrary - RequestRuntimeStop()
2/08/2012 8:12:23 PM Connectivity.Request.Foundation.RequestLibrary - RequestRuntimeStop()
2/08/2012 8:12:23 PM Connectivity.Request.Document.RequestLibrary - RequestRuntimeStop()

Many thanks to Bob and my VAR.