Asset 12 Asset 10 Asset 11 autodesk_icon_font_1_18_17_start_over-01

Keyboard ALT + g to toggle grid overlay

Stephen Porath

PL21627: Vault Preventative SQL Maintenance – Maintaining a healthy database

(Duration 51:56)

  • Save to my AU Saved

Key Learning

Key Learning

  • Understand what a maintenance plan is and why they are needed
  • Create a maintenance plan that can be utilized in any environment
  • Know at a high level the intricacies of the maintenance plan (understanding/options)
  • Adjust the maintenance plan as needed for each business unit/organization (customization)

Description

Description

If looking to improve the general health of your Vault SQL Server implementation, improve performance, or automate backups, this course is for you. It’s geared towards Vault administrators looking to improve maintenance in their SQL Server environments using SQL Server Maintenance Plans. As maintenance plans are not something that is installed or implemented with out of the box solutions from Autodesk or Microsoft, we will provide a suggested solution for use with SQL Server. We will cover the basics of implementing a SQL Server maintenance plan to keep Autodesk Vault SQL Server Databases running at their most optimum levels, hourly, daily, weekly, monthly and beyond. Users will have a base maintenance plan to get started and will walk away with the knowledge to modify that plan to suit their own unique environments. This session features Vault Professional, Vault Basic, and Vault Workgroup.

Target Audience

Target Audience

Vault administrators and CAD Managers looking to ensure database health in their relevant systems and gain knowledge related to SQL Server database maintenance.

Speakers

Speakers

Stephen Porath

Stephen Porath been with Autodesk Enterprise Priority support for 2 years specializing in the Vault product. He has over 10 years of experience with Microsoft SQL Server, dating back to SQL Server 2000. He’s been providing enterprise software support, training and implementation for over 15 years. He resides in Novi, MI, USA, a suburb of Detroit with his wife their beautiful daughter. He’s an avid gamer and enjoys spending time outdoors with his family.

Traci Peurasaari

I am a SQL/DBA specialist with Enterprise Priority Support. I have over 25 years of relational database experience in Microsoft SQL Server and Oracle. My experience spans both the administrative, development and support arenas. For the past 10 years I have done a significant amount of SQL support and training for customers. I have trained internal support staff in supporting customer databases. I am proficient in Database performance and tuning, backup and restore and replication. My experience spans multiple industries from manufacturing to advertising to finance. Throughout my career – regardless of my title the Database has been my passion and I have always maintained my activities in it whether it be through customer support, development or Business Analytics and metrics.

Related Classes

Related Classes

Tags

Published

  • 2016
  • PL21627
  • AU Las Vegas

Software

  • Vault Professional
  • Vault Basic
  • Vault Workgroup

Industries

  • General Manufacturing and Product Design
  • Process Manufacturing

Topics

  • PLM and Data Management