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.
Powered by IDERA