Optimizing Microsoft SQL Server Reporting Services: Performance and Access Reports from the Execution Log
5. Locate the Reporting Services installation CD on an accessible CD drive.
6. Navigate to the following folder (or it’s equivalent, substituting your own CD drive for “F:” below):
F:extrasExecution Log Sample Reports
The contents of the Execution Log Sample Reports folder appear similar to that shown in Figure 3.
Figure 3: The Sample Execution Log Reports Appear
7. Select Edit —> Select All from the Windows Explorer main menu. The contents of the Execution Log Sample Reports folder become highlighted.
8. Select Edit —> Copy from the main menu.
9. Navigate to the new SSP-RS002 folder we created above.
10. Right-click within the folder.
11. Select Paste from the context menu that appears, as depicted in Figure 4.
Figure 4: Select Paste to Place the Sample File Copies
The copied files (there should be eleven) appear as shown in Figure 5.
Figure 5: The Sample Report Files Appear
Our next step will be to upload the samples into Report Manager, where we can review them and see what information they can deliver to the information consumers. The first step of this process will be to establish a Data Source Connection. We will use Report Manager, versus the Report Designer interface, for this purpose, but we should keep in mind that the upload / publication process can also be managed from within Report Designer.