SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 Benchmark Factory for Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic   

raylee729
Starting Member

2 Posts

Posted - 02/04/2013 :  13:16:30  Show Profile  Reply with Quote
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

USA
1974 Posts

Posted - 02/04/2013 :  13:28:46  Show Profile  Visit chadmat's Homepage  Reply with Quote
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
Go to Top of Page

raylee729
Starting Member

2 Posts

Posted - 02/04/2013 :  13:38:39  Show Profile  Reply with Quote
Hi Chad,

Thank you so much for your answer to my questions. Is there any other ways beside taking log backups?
Go to Top of Page

chadmat
The Chadinator

USA
1974 Posts

Posted - 03/09/2013 :  17:37:24  Show Profile  Visit chadmat's Homepage  Reply with Quote
No,

Why would you not want to take backups?

-Chad
Go to Top of Page
  Previous Topic Topic   
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000