Is this product good for testing peformance of queries versus a live database?

does this virtual database perform the same as a live database? I want to test performance improvements, so ideally it would peform the same.

  • Dear Helene Brown,

    The purpose of SQLvdb is to allow users to be able to quickly “restore” and access the data with a backup file without fully restoring the database.

    Using SQLvdb to test query performance versus a live database may not be an ideal use of the tool. SQLvdb leverages a its own Windows service to access and return the data that is queried from the backup file which can add a delay to the performance of queries. With that in mind, comparing a query that runs against a live database to one that is run against a SQLvdb db may not give you a good one-to-one comparison.