HyperV VM Disk Perfromance on SQL Server with SSD SAN
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
Having real performance issues in on a production SQL server enterprise (2014). SQL is on a VM that is connected to a SAN SSD array via 10gb/sec connection. When one of the 3rd party apps we use processes a large job (miliions of records), everything grinds to a alt and disk read latency can go up to 2000ms (normally under 15).
Our IT guys say they have provisioned a max of 6000 IOPS/sec on the storage system, and our SQL monitor is showing only 350 disk transfers/sec (on the last instance of this)
We have 8 tempdb files and the tempdb, ldfs and mdfs are on their own volumes
Any suggestions of how to troubleshoot this?
Given that everything is using the same storage device, is there benefit to splitting out the the mdf's and ldfs for indivdua apps to their own volumes?
TIA
Mark
sql-server virtualisation
asked 24 mins ago
mark1234mark1234
1464
add a comment |
Having real performance issues in on a production SQL server enterprise (2014). SQL is on a VM that is connected to a SAN SSD array via 10gb/sec connection. When one of the 3rd party apps we use processes a large job (miliions of records), everything grinds to a alt and disk read latency can go up to 2000ms (normally under 15).
Our IT guys say they have provisioned a max of 6000 IOPS/sec on the storage system, and our SQL monitor is showing only 350 disk transfers/sec (on the last instance of this)
We have 8 tempdb files and the tempdb, ldfs and mdfs are on their own volumes
Any suggestions of how to troubleshoot this?
Given that everything is using the same storage device, is there benefit to splitting out the the mdf's and ldfs for indivdua apps to their own volumes?
TIA
Mark
sql-server virtualisation
asked 24 mins ago
mark1234mark1234
1464
Add more memory.
– Erik Darling
7 mins ago
add a comment |
Having real performance issues in on a production SQL server enterprise (2014). SQL is on a VM that is connected to a SAN SSD array via 10gb/sec connection. When one of the 3rd party apps we use processes a large job (miliions of records), everything grinds to a alt and disk read latency can go up to 2000ms (normally under 15).
Our IT guys say they have provisioned a max of 6000 IOPS/sec on the storage system, and our SQL monitor is showing only 350 disk transfers/sec (on the last instance of this)
We have 8 tempdb files and the tempdb, ldfs and mdfs are on their own volumes
Any suggestions of how to troubleshoot this?
Given that everything is using the same storage device, is there benefit to splitting out the the mdf's and ldfs for indivdua apps to their own volumes?
TIA
Mark
sql-server virtualisation
asked 24 mins ago
mark1234mark1234
1464
Having real performance issues in on a production SQL server enterprise (2014). SQL is on a VM that is connected to a SAN SSD array via 10gb/sec connection. When one of the 3rd party apps we use processes a large job (miliions of records), everything grinds to a alt and disk read latency can go up to 2000ms (normally under 15).
Our IT guys say they have provisioned a max of 6000 IOPS/sec on the storage system, and our SQL monitor is showing only 350 disk transfers/sec (on the last instance of this)
We have 8 tempdb files and the tempdb, ldfs and mdfs are on their own volumes
Any suggestions of how to troubleshoot this?
Given that everything is using the same storage device, is there benefit to splitting out the the mdf's and ldfs for indivdua apps to their own volumes?
TIA
Mark
sql-server virtualisation
sql-server virtualisation
asked 24 mins ago
mark1234mark1234
1464
asked 24 mins ago
mark1234mark1234
1464
asked 24 mins ago
mark1234mark1234
1464
asked 24 mins ago
mark1234mark1234
1464
asked 24 mins ago
mark1234mark1234
1464
1464
Add more memory.
– Erik Darling
7 mins ago
add a comment |
Add more memory.
– Erik Darling
7 mins ago
Add more memory.
– Erik Darling
7 mins ago
Add more memory.
– Erik Darling
7 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
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%2fdba.stackexchange.com%2fquestions%2f234320%2fhyperv-vm-disk-perfromance-on-sql-server-with-ssd-san%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
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f234320%2fhyperv-vm-disk-perfromance-on-sql-server-with-ssd-san%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
Add more memory.
– Erik Darling
7 mins ago