Several questions about sp_BlitzIndex
When sp_BlitzIndex does index suggestions, the question in my head is as below:
Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries
Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?
Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?
Thank you very much for answers
sql-server sql-server-2017 sp-blitzindex
edited 47 mins ago
Brent Ozar
33.7k19100229
asked 1 hour ago
MonsterMMORPG
271214
add a comment |
When sp_BlitzIndex does index suggestions, the question in my head is as below:
Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries
Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?
Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?
Thank you very much for answers
sql-server sql-server-2017 sp-blitzindex
edited 47 mins ago
Brent Ozar
33.7k19100229
asked 1 hour ago
MonsterMMORPG
271214
add a comment |
When sp_BlitzIndex does index suggestions, the question in my head is as below:
Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries
Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?
Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?
Thank you very much for answers
sql-server sql-server-2017 sp-blitzindex
edited 47 mins ago
Brent Ozar
33.7k19100229
asked 1 hour ago
MonsterMMORPG
271214
When sp_BlitzIndex does index suggestions, the question in my head is as below:
Yes the suggested index would bring a lot of speed benefit when doing select statements. But there are also another costs for these indexes which are delete, insert, update queries
Do sp_BlitzIndex script take into consideration delete, insert, update costs as well? or only it does evaluate how much speed benefit would come with select statements?
Moreover, how can i list bad indexes via sp_BlitzIndex? and how are they determined to be bad?
Thank you very much for answers
sql-server sql-server-2017 sp-blitzindex
sql-server sql-server-2017 sp-blitzindex
edited 47 mins ago
Brent Ozar
33.7k19100229
asked 1 hour ago
MonsterMMORPG
271214
edited 47 mins ago
Brent Ozar
33.7k19100229
asked 1 hour ago
MonsterMMORPG
271214
edited 47 mins ago
Brent Ozar
33.7k19100229
edited 47 mins ago
Brent Ozar
33.7k19100229
edited 47 mins ago
Brent Ozar
33.7k19100229
33.7k19100229
asked 1 hour ago
MonsterMMORPG
271214
asked 1 hour ago
MonsterMMORPG
271214
asked 1 hour ago
MonsterMMORPG
271214
271214
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.
Do sp_blitz script take into consideration delete, insert, update costs as well?
sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.
- The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.
- The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.
Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?
sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.
answered 1 hour ago
Brent Ozar
33.7k19100229
add a comment |
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%2f226249%2fseveral-questions-about-sp-blitzindex%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.
Do sp_blitz script take into consideration delete, insert, update costs as well?
sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.
- The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.
- The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.
Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?
sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.
answered 1 hour ago
Brent Ozar
33.7k19100229
add a comment |
and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.
Do sp_blitz script take into consideration delete, insert, update costs as well?
sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.
- The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.
- The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.
Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?
sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.
answered 1 hour ago
Brent Ozar
33.7k19100229
add a comment |
and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.
Do sp_blitz script take into consideration delete, insert, update costs as well?
sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.
- The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.
- The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.
Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?
sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.
answered 1 hour ago
Brent Ozar
33.7k19100229
and welcome to Stack Exchange. Going forward, try to break questions out individually. Here's how to write a great question.
Do sp_blitz script take into consideration delete, insert, update costs as well?
sp_BlitzIndex has several sections based on SQL Server's diagnostic management views.
- The missing indexes are based on sys.dm_db_missing_index_details, which don't take into account delete/update/inserts.
- The existing indexes list is based on sys.dm_db_index_usage_stats and sys.dm_db_index_physical_stats, which do take into account deletes/updates/inserts.
Moreover, how can i list bad indexes via sp_blitz? and how are they determined to be bad?
sp_BlitzIndex doesn't call indexes bad. It treats indexes a lot like human behaviors - for example, hoarding isn't necessarily bad in small amounts, or agoraphobia, or kleptomania, or being a furry. All kinds of behaviors are okay in small doses. It's up to you, not the script, to determine if an index is bad.
answered 1 hour ago
Brent Ozar
33.7k19100229
answered 1 hour ago
Brent Ozar
33.7k19100229
answered 1 hour ago
Brent Ozar
33.7k19100229
answered 1 hour ago
Brent Ozar
33.7k19100229
33.7k19100229
add a comment |
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f226249%2fseveral-questions-about-sp-blitzindex%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
