That's the choice I've been given. 1 month into work at a small business with 1 well used 2008 r2 SQL Server (average 9k transactions/sec. with sustained periods of 20K mainly due to BizTalk EDI. 3 db's around 100 GB, 12 smaller ones, Hyper V environment not efficiently configured (1 lun to rule them all)
Which would you choose? What other questions would you ask before deciding? (we use SQL server very generically).
Are those actual transactions or technical transactions?
What hardware are you on?
😎
when we are hovering around 8K transactions, I want to believe many of those are technical transactions, but have not had time to dig into the details of the transactions.