A Principled Technologies test report 17
Consolidating older database servers with the Intel processor-powered
Dell PowerEdge R730xd using SanDisk DAS Cache
Installing the Microsoft ODBC Driver 11 for SQL Server client servers
1. Download software from http://www.microsoft.com/en-us/download/confirmation.aspx?id=36434
2. Double-click the msodbcsql.exe file, and click Run.
3. At the Welcome screen, click Next.
4. Accept the license software agreement, and click Next.
5. At the Feature Selection screen, click Next.
6. Click Install, and click Finish.
Configuring Benchmark Factory client servers
1. Open the Benchmark Factory client.
2. Click EditSettings
3. Under General, select Benchmarks and then TPC-C.
4. Change the Benchmark scale to 1,000, and click Apply. Click Ok
5. Select the New Connection Icon.
6. Under Database Connection method for BMF select Microsoft SQL Server (ODBC)
7. Click Add DNS.
8. Select the System Data Source, and click Next.…
9. Select the ODBC Driver 11 for SQL Server, and click Finish.
10. Enter a name and select the server you want to connect to, and click Next.
11. Select SQL Server login ID authentication and enter credentials, and click Next.
12. Select Change the default database to, and select the target database.
13. Click Next, and click Finish.
14. Click Test Data Source to confirm configuration.
15. Click Ok.
16. Return to the New Connection Screen, and select the recently created Data Source Name.
17. Enter a User Name and Password.
18. Click Create Connection.
19. Click the New Job Wizard Icon.
20. Select the connection for the database under test.
21. Click Add workload.
22. Select TPC-C, and click Import test.
23. Right-click Create Objects for TPC-C and select remove to eliminate the create database option.
24. Select TCP-C Transaction Mix, and click the User Load tab.
25. Under Selected User Load, click Delete All.
26. Under User Load select 5,000, and click Add.
27. Click the Timing tab and enter 2 hours for sampling time and 10 minutes for pre-sampling time.
28. Click the Agent Icon select the client server and add 10 agents.
29. Click Run Job to start the test.
30. Perform steps 1 through 29 on all other clients.
(45 stránky)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce