Blueprint: Disk space requirement on SQL server to perform a Blueprint version upgrade.
  • 24 Apr 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Blueprint: Disk space requirement on SQL server to perform a Blueprint version upgrade.

  • Dark
    Light
  • PDF

Article summary

Question:

How much disk space on the SQL server is required to perform a Blueprint version upgrade?

Environment:

Blueprint Enterprise 5.0 and greater


Information:

During the upgrade of each job partition, the jobs data is written out of the databases to CSV via BCP and then written back in after the schema has been updated. This is done one partition at a time, with the jobs being written to a file named “oldJobs.csv” in the data directory.
 
 The background logic is:
 
 For each psjobsX partition
 begin
     If oldJobs.csv exists, delete it.
     Write data from SQL partition into oldJobs.csv.
     Update partition schema and import jobs from oldJobs.csv into partition
     Delete oldJobs.csv
 end
 
 In regard to the disk space requirement:

•  To upgrade a partition, allow for free space equal to 2x the size of data in use for the partition.  Find the largest job partition, and make sure there’s 2x its size free.  (Note, no need sum of size of all partitions, just size of biggest one.)
 
 •  To upgrade the data warehouse, the logic completely rebuilds the warehouse.  Allow free space equal to 2x the existing size of warehouse for the rebuild.


Was this article helpful?


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.