SQL Server transaction log storage on AWS Disk type The Next CEO of Stack OverflowSQL Server Transaction log Backup Frequencyhow to clear sql server database transaction log fileRecover deleted rows from SQL Server transaction log fileSQL Server Transaction Log RAIDScale a highly transactional SQL serverSql Server transaction log placement in AWS hostingSql Server Transaction Log Backup FailsSQL Server Transaction Log maximum file sizeSQL Server 2012 SP1 transaction log getting full?Amazon AWS EC2 transaction/event log?
Multi tool use
Find non-case sensitive string in a mixed list of elements?
Is micro rebar a better way to reinforce concrete than rebar?
Why isn't acceleration always zero whenever velocity is zero, such as the moment a ball bounces off a wall?
Is wanting to ask what to write an indication that you need to change your story?
Prepend last line of stdin to entire stdin
What flight has the highest ratio of timezone difference to flight time?
Grabbing quick drinks
Why didn't Khan get resurrected in the Genesis Explosion?
Is there always a complete, orthogonal set of unitary matrices?
Domestic-to-international connection at Orlando (MCO)
A Man With a Stainless Steel Endoskeleton (like The Terminator) Fighting Cloaked Aliens Only He Can See
Rotate a column
Can this equation be simplified further?
Can you be charged for obstruction for refusing to answer questions?
Proper way to express "He disappeared them"
Yu-Gi-Oh cards in Python 3
Won the lottery - how do I keep the money?
Running a General Election and the European Elections together
Is the D&D universe the same as the Forgotten Realms universe?
Is it professional to write unrelated content in an almost-empty email?
Why do airplanes bank sharply to the right after air-to-air refueling?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
Easy to read palindrome checker
Why, when going from special to general relativity, do we just replace partial derivatives with covariant derivatives?
SQL Server transaction log storage on AWS Disk type
The Next CEO of Stack OverflowSQL Server Transaction log Backup Frequencyhow to clear sql server database transaction log fileRecover deleted rows from SQL Server transaction log fileSQL Server Transaction Log RAIDScale a highly transactional SQL serverSql Server transaction log placement in AWS hostingSql Server Transaction Log Backup FailsSQL Server Transaction Log maximum file sizeSQL Server 2012 SP1 transaction log getting full?Amazon AWS EC2 transaction/event log?
We are moving our SQL Server to an Amazon EC2 instance.
For the various disk types under consideration gp2, io1, st1, It is unclear to me which type of drive to store the transaction logs on.
I presume that the logs are written sequentially, so perhaps counter intuitively the st1 drive with its higher throughput/price might be the correct choice compared to the more advanced ssd type drives.
However, if this is not the case, between io1 and gp2 it is not clear which is the correct choice because of the burst ability of gp2.
Is there some best practice for sql server transaction logs?
amazon-web-services sql-server
asked yesterday
rileymatrileymat
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
We are moving our SQL Server to an Amazon EC2 instance.
For the various disk types under consideration gp2, io1, st1, It is unclear to me which type of drive to store the transaction logs on.
I presume that the logs are written sequentially, so perhaps counter intuitively the st1 drive with its higher throughput/price might be the correct choice compared to the more advanced ssd type drives.
However, if this is not the case, between io1 and gp2 it is not clear which is the correct choice because of the burst ability of gp2.
Is there some best practice for sql server transaction logs?
amazon-web-services sql-server
asked yesterday
rileymatrileymat
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Writes to the transaction log file are indeed sequential, but per database. If you have multiple databases, odds are you're going to be writing to them all at the same time, randomly. That means if you put several databases on the same server, with their log files on the same EBS volume, then the writes on that volume will be random, not sequential.
– Brent Ozar
yesterday
Thanks, that is a great point to consider in choice, or at least design around.
– rileymat
yesterday
add a comment |
We are moving our SQL Server to an Amazon EC2 instance.
For the various disk types under consideration gp2, io1, st1, It is unclear to me which type of drive to store the transaction logs on.
I presume that the logs are written sequentially, so perhaps counter intuitively the st1 drive with its higher throughput/price might be the correct choice compared to the more advanced ssd type drives.
However, if this is not the case, between io1 and gp2 it is not clear which is the correct choice because of the burst ability of gp2.
Is there some best practice for sql server transaction logs?
amazon-web-services sql-server
asked yesterday
rileymatrileymat
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
We are moving our SQL Server to an Amazon EC2 instance.
For the various disk types under consideration gp2, io1, st1, It is unclear to me which type of drive to store the transaction logs on.
I presume that the logs are written sequentially, so perhaps counter intuitively the st1 drive with its higher throughput/price might be the correct choice compared to the more advanced ssd type drives.
However, if this is not the case, between io1 and gp2 it is not clear which is the correct choice because of the burst ability of gp2.
Is there some best practice for sql server transaction logs?
amazon-web-services sql-server
amazon-web-services sql-server
asked yesterday
rileymatrileymat
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
rileymatrileymat
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
rileymatrileymat
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
rileymatrileymat
1
asked yesterday
rileymatrileymat
1
1
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
rileymat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Writes to the transaction log file are indeed sequential, but per database. If you have multiple databases, odds are you're going to be writing to them all at the same time, randomly. That means if you put several databases on the same server, with their log files on the same EBS volume, then the writes on that volume will be random, not sequential.
– Brent Ozar
yesterday
Thanks, that is a great point to consider in choice, or at least design around.
– rileymat
yesterday
add a comment |
Writes to the transaction log file are indeed sequential, but per database. If you have multiple databases, odds are you're going to be writing to them all at the same time, randomly. That means if you put several databases on the same server, with their log files on the same EBS volume, then the writes on that volume will be random, not sequential.
– Brent Ozar
yesterday
Thanks, that is a great point to consider in choice, or at least design around.
– rileymat
yesterday
Writes to the transaction log file are indeed sequential, but per database. If you have multiple databases, odds are you're going to be writing to them all at the same time, randomly. That means if you put several databases on the same server, with their log files on the same EBS volume, then the writes on that volume will be random, not sequential.
– Brent Ozar
yesterday
Writes to the transaction log file are indeed sequential, but per database. If you have multiple databases, odds are you're going to be writing to them all at the same time, randomly. That means if you put several databases on the same server, with their log files on the same EBS volume, then the writes on that volume will be random, not sequential.
– Brent Ozar
yesterday
Thanks, that is a great point to consider in choice, or at least design around.
– rileymat
yesterday
Thanks, that is a great point to consider in choice, or at least design around.
– rileymat
yesterday
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
rileymat is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f960641%2fsql-server-transaction-log-storage-on-aws-disk-type%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
rileymat is a new contributor. Be nice, and check out our Code of Conduct.
rileymat is a new contributor. Be nice, and check out our Code of Conduct.
rileymat is a new contributor. Be nice, and check out our Code of Conduct.
rileymat is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f960641%2fsql-server-transaction-log-storage-on-aws-disk-type%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
q,OYCnoqOGbDdeOp8urzNry 05H1,QYqfpnr,7EJLcYXVA,J78mVrO7BeDOqTFjT3L,XQq2kewNDIn7GO,Wpt
Writes to the transaction log file are indeed sequential, but per database. If you have multiple databases, odds are you're going to be writing to them all at the same time, randomly. That means if you put several databases on the same server, with their log files on the same EBS volume, then the writes on that volume will be random, not sequential.
– Brent Ozar
yesterday
Thanks, that is a great point to consider in choice, or at least design around.
– rileymat
yesterday