How Using the Windows 2000 Encrypted File System to Secure SQL Server Databases and Backups Affects SQL Server’s Performance

Now for the actual testing. The following operations were repeated five times on each database (encrypted and non-encrypted). The instance was re-started after each test cycle and the order in which the tests were done, i.e., EFS database (encrypted) then Non-EFS database (non-encrypted), and visa versa, also changed. The figures below are averages of the runs made.