After mounting a 20GB SQL Virtual Database, the first select statements take a long time to return data

After mounting a 20GB SQL Virtual Database, the first select statements take a long time to return data, and worse when the tables are large.
After this the responses are less slow.
Is there anything I can do to improve response time?

Parents
  • (I think my initial reply got eaten)

    Make sure you're setting the flag for mapping when you take the backup. My understanding is that if it doesn't have it, when you first query the mounted backup, it creates the map. That sounds like what you're seeing.
    From my ancient script we use to take backups using xp_ss_backup:

    -- Enable or disable the 'Generate map for SQL virtual database optimization'. Allowed values {'on'|'off'}.
    @vdb = 'on'

Reply
  • (I think my initial reply got eaten)

    Make sure you're setting the flag for mapping when you take the backup. My understanding is that if it doesn't have it, when you first query the mounted backup, it creates the map. That sounds like what you're seeing.
    From my ancient script we use to take backups using xp_ss_backup:

    -- Enable or disable the 'Generate map for SQL virtual database optimization'. Allowed values {'on'|'off'}.
    @vdb = 'on'

Children
No Data