Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raylee729
Starting Member
2 Posts |
 Posted - 2013-02-04 : 13:16:30
|
| Hello,Has anyone had experiences using Benchmark Factory for Database version 6.8.1 to test against SQL Server 2012 Alwayson Availability groups?1) When I tried to run TPC-E benchmark test on SQL Alwayson groups with BMF, I kept getting very large log files. For instance, when I tried to create a database of around 500 GB (the capacity of the disk I had was around 1TB) to run a TPC-E benchmark test (I set the scale factor to 59 with the estimated size of 504.55 GB). However, during the database creation phase, the log file of the database grew twice as big as the data file of the database, and it used up all the space in the disk (with data file of size 320GB and log file of size 680GB), which caused the test to fail because BMF could not allocate space. Is it normal for log file to grow that big when I use SQL Server 2012 Alwayson Availability groups?2) Another question I have is about failover on SQL Alwayson groups. I have run some tests to test failover on SQL Alwayson groups. With SQL Server Native Client v11, all the tests I ran were cancelled by BMF when failover occurred. I have unchecked ‘Stop job after first error’, and checked ‘Enable Reconnect’ for all the tests. Are there any other things I need to do to let tests continue to run when failover occurs?Thank you for your help in advance.Best, |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-02-04 : 13:28:46
|
| Availability Groups require FULL recovery model, so you need to backup your logs periodically (And that period may be quite frquently depending on activity), or they will grow.-Chad |
 |
|
|
raylee729
Starting Member
2 Posts |
Posted - 2013-02-04 : 13:38:39
|
| Hi Chad,Thank you so much for your answer to my questions. Is there any other ways beside taking log backups? |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2013-03-09 : 17:37:24
|
| No,Why would you not want to take backups?-Chad |
|
|
|
|
|
|
|
|
Benchmark Factory for Database