How to diagnose performance issues with an encrypted procedure without execute and alter permissions?Big O, how do you calculate/approximate it?How costly is .NET reflection?When is assembly faster than C?Efficiency of Java “Double Brace Initialization”?Improve INSERT-per-second performance of SQLite?Speed comparison with Project Euler: C vs Python vs Erlang vs HaskellWhy is my program slow when looping over exactly 8192 elements?Swift Beta performance: sorting arraysReplacing a 32-bit loop counter with 64-bit introduces crazy performance deviationsWhy is [] faster than list()?
Am I being scammed by a sugar daddy?
Can artificial satellite positions affect tides?
Idiom for 'person who gets violent when drunk"
Purpose of cylindrical attachments on Power Transmission towers
The best in flight meal option for those suffering from reflux
In The Incredibles 2, why does Screenslaver's name use a pun on something that doesn't exist in the 1950s pastiche?
Jam with honey & without pectin has a saucy consistency always
Why are backslashes included in this shell script?
Print "N NE E SE S SW W NW"
Am I allowed to determine tenets of my contract as a warlock?
Is this equation correct? And if so, is this famous?
How effective would a full set of plate armor be against wild animals found in temperate regions (bears, snakes, wolves)?
Why did Robert pick unworthy men for the White Cloaks?
Is pointing finger in meeting consider bad?
What is the theme of analysis?
Is it a good security practice to force employees hide their employer to avoid being targeted?
Why is it bad to use your whole foot in rock climbing
Is fission/fusion to iron the most efficient way to convert mass to energy?
Commencez à vous connecter -- I don't understand the phrasing of this
Is all-caps blackletter no longer taboo?
Can an open source licence be revoked if it violates employer's IP?
What does the "titan" monster tag mean?
Why not make one big cpu core?
What are the advantages of using TLRs to rangefinders?
How to diagnose performance issues with an encrypted procedure without execute and alter permissions?
Big O, how do you calculate/approximate it?How costly is .NET reflection?When is assembly faster than C?Efficiency of Java “Double Brace Initialization”?Improve INSERT-per-second performance of SQLite?Speed comparison with Project Euler: C vs Python vs Erlang vs HaskellWhy is my program slow when looping over exactly 8192 elements?Swift Beta performance: sorting arraysReplacing a 32-bit loop counter with 64-bit introduces crazy performance deviationsWhy is [] faster than list()?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
That's the question I got in the interview. And I couldn't say anything more than parameter sniffing. But this is not a method of finding a solution, but one of the possible problems. And I wonder how you can really diagnose such a situation?
sql performance tsql stored-procedures sql-server-2012
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
add a comment |
That's the question I got in the interview. And I couldn't say anything more than parameter sniffing. But this is not a method of finding a solution, but one of the possible problems. And I wonder how you can really diagnose such a situation?
sql performance tsql stored-procedures sql-server-2012
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
1
If you can't run the stored procedure, then your options are indeed limited. If I was asking this question in an interview, then I would probably expect the candidate to mention cached execution plans, or viewing statistics (e.g. dba.stackexchange.com/questions/16493/…). Another option would be setting up a trace (SQL Profiler), although having the rights to do this and NOT execute stored procedures seems a bit artificial?
– Richard Hansell
Mar 25 at 14:14
add a comment |
That's the question I got in the interview. And I couldn't say anything more than parameter sniffing. But this is not a method of finding a solution, but one of the possible problems. And I wonder how you can really diagnose such a situation?
sql performance tsql stored-procedures sql-server-2012
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
That's the question I got in the interview. And I couldn't say anything more than parameter sniffing. But this is not a method of finding a solution, but one of the possible problems. And I wonder how you can really diagnose such a situation?
sql performance tsql stored-procedures sql-server-2012
sql performance tsql stored-procedures sql-server-2012
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
asked Mar 25 at 0:58
M. RictusgrinM. Rictusgrin
32
32
1
If you can't run the stored procedure, then your options are indeed limited. If I was asking this question in an interview, then I would probably expect the candidate to mention cached execution plans, or viewing statistics (e.g. dba.stackexchange.com/questions/16493/…). Another option would be setting up a trace (SQL Profiler), although having the rights to do this and NOT execute stored procedures seems a bit artificial?
– Richard Hansell
Mar 25 at 14:14
add a comment |
1
If you can't run the stored procedure, then your options are indeed limited. If I was asking this question in an interview, then I would probably expect the candidate to mention cached execution plans, or viewing statistics (e.g. dba.stackexchange.com/questions/16493/…). Another option would be setting up a trace (SQL Profiler), although having the rights to do this and NOT execute stored procedures seems a bit artificial?
– Richard Hansell
Mar 25 at 14:14
1
1
If you can't run the stored procedure, then your options are indeed limited. If I was asking this question in an interview, then I would probably expect the candidate to mention cached execution plans, or viewing statistics (e.g. dba.stackexchange.com/questions/16493/…). Another option would be setting up a trace (SQL Profiler), although having the rights to do this and NOT execute stored procedures seems a bit artificial?
– Richard Hansell
Mar 25 at 14:14
If you can't run the stored procedure, then your options are indeed limited. If I was asking this question in an interview, then I would probably expect the candidate to mention cached execution plans, or viewing statistics (e.g. dba.stackexchange.com/questions/16493/…). Another option would be setting up a trace (SQL Profiler), although having the rights to do this and NOT execute stored procedures seems a bit artificial?
– Richard Hansell
Mar 25 at 14:14
add a comment |
1 Answer
1
active
oldest
votes
That is indeed one of those questions to see how you think and what your depth of knowledge is and how you react. Execution plans, and all these options mentioned by Richard really depend on how the environment is set up (ie, permissions). It would be really weird to have permissions for these and you couldn't exec a stored proc. This is one of those questions someone really wants to grind you. Our DBA is like this, but he's realistic. He'll ask someone to hand write a query that's a classic pick out the max or something similar. He'll use real table names, and he'll wait for the query, then type it in to see if it works. If issues arise, he'll hand it over and ask them to fix it. I feel this is a better approach than asking about what I like to call 'edge cases' that you aren't going to see often.
-Nick
answered Apr 4 at 17:27
Nick GNick G
113
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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
);
);
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%2fstackoverflow.com%2fquestions%2f55330066%2fhow-to-diagnose-performance-issues-with-an-encrypted-procedure-without-execute-a%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
That is indeed one of those questions to see how you think and what your depth of knowledge is and how you react. Execution plans, and all these options mentioned by Richard really depend on how the environment is set up (ie, permissions). It would be really weird to have permissions for these and you couldn't exec a stored proc. This is one of those questions someone really wants to grind you. Our DBA is like this, but he's realistic. He'll ask someone to hand write a query that's a classic pick out the max or something similar. He'll use real table names, and he'll wait for the query, then type it in to see if it works. If issues arise, he'll hand it over and ask them to fix it. I feel this is a better approach than asking about what I like to call 'edge cases' that you aren't going to see often.
-Nick
answered Apr 4 at 17:27
Nick GNick G
113
add a comment |
That is indeed one of those questions to see how you think and what your depth of knowledge is and how you react. Execution plans, and all these options mentioned by Richard really depend on how the environment is set up (ie, permissions). It would be really weird to have permissions for these and you couldn't exec a stored proc. This is one of those questions someone really wants to grind you. Our DBA is like this, but he's realistic. He'll ask someone to hand write a query that's a classic pick out the max or something similar. He'll use real table names, and he'll wait for the query, then type it in to see if it works. If issues arise, he'll hand it over and ask them to fix it. I feel this is a better approach than asking about what I like to call 'edge cases' that you aren't going to see often.
-Nick
answered Apr 4 at 17:27
Nick GNick G
113
add a comment |
That is indeed one of those questions to see how you think and what your depth of knowledge is and how you react. Execution plans, and all these options mentioned by Richard really depend on how the environment is set up (ie, permissions). It would be really weird to have permissions for these and you couldn't exec a stored proc. This is one of those questions someone really wants to grind you. Our DBA is like this, but he's realistic. He'll ask someone to hand write a query that's a classic pick out the max or something similar. He'll use real table names, and he'll wait for the query, then type it in to see if it works. If issues arise, he'll hand it over and ask them to fix it. I feel this is a better approach than asking about what I like to call 'edge cases' that you aren't going to see often.
-Nick
answered Apr 4 at 17:27
Nick GNick G
113
That is indeed one of those questions to see how you think and what your depth of knowledge is and how you react. Execution plans, and all these options mentioned by Richard really depend on how the environment is set up (ie, permissions). It would be really weird to have permissions for these and you couldn't exec a stored proc. This is one of those questions someone really wants to grind you. Our DBA is like this, but he's realistic. He'll ask someone to hand write a query that's a classic pick out the max or something similar. He'll use real table names, and he'll wait for the query, then type it in to see if it works. If issues arise, he'll hand it over and ask them to fix it. I feel this is a better approach than asking about what I like to call 'edge cases' that you aren't going to see often.
-Nick
answered Apr 4 at 17:27
Nick GNick G
113
answered Apr 4 at 17:27
Nick GNick G
113
answered Apr 4 at 17:27
Nick GNick G
113
answered Apr 4 at 17:27
Nick GNick G
113
113
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f55330066%2fhow-to-diagnose-performance-issues-with-an-encrypted-procedure-without-execute-a%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
1
If you can't run the stored procedure, then your options are indeed limited. If I was asking this question in an interview, then I would probably expect the candidate to mention cached execution plans, or viewing statistics (e.g. dba.stackexchange.com/questions/16493/…). Another option would be setting up a trace (SQL Profiler), although having the rights to do this and NOT execute stored procedures seems a bit artificial?
– Richard Hansell
Mar 25 at 14:14