| Author |
Topic |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2010-01-18 : 10:11:21
|
Ugh...I'm doing my 70-432 tomorrow (http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-432&locale=en-us#tab2) and the level of details in these practice exams I have is worrying me!! I've been working professionally with sql server for close to 8 years now and I feel like a complete idiot doing these tests:quote:
(A - B) / Cwhere A, B, and C are defined as the following:A = SQLServer:SQL Statistics\Compilations/secB = SQLServer:SQL Statistics\SQL Re-compilations/secC = SQLServer:SQL Statistics\Batch Requests/secThe preceding formula is a measure of what?1) The amount of plan reuse being achieved2) How much performance is being affected3) The amount of work that Microsoft SQL Server performs during query execution4) The number of queries completing per second
 - Lumbagohttp://xkcd.com/327/ |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-18 : 10:15:15
|
If you feel like an idiot you are no idiot because an idiot isn't able to feel like an idiot 
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-18 : 10:33:38
|
Hope this helps then   |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-01-18 : 10:46:36
|
| it's 1.compilations - recompilations give you number of queries whose plan isn't in the cache. divide that by batch requests and you get number of plan reuse___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-18 : 10:51:35
|
Rule out 2) since performance is a subjective thing.Now1. A - B is "Compilations minus Recompilations" which should mean "New compilations".2. "Answer from 1" / C gives that "per sec" cancells out eachother, and you have "New compilations" / "Batch requests".Rule out 4) since there cannot be a "per sec" answerYou can rule of 3) too, since work is not a measurement for compilations and batch requests.My guess is that 1) is the proper answer; Plan reuse.Can you confirm? I haven't taken the new 2005/2008 certs myself.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-18 : 11:34:43
|
| If it helps at all, every practice exam I've seen has been harder (a lot) than the real exams.--Gail ShawSQL Server MVP |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-18 : 12:01:24
|
| Well Gail...you have provided the only answer that gave some comfort in these frustrating times hehe. I don't have the answer to the question I posted as an example but I'm assuming that spirit and peso has got it right, it makes sense. If I'd be able to figure that out on my own during the exam is a completely different question though.But it's nice to know that you can become an MVP without being certified...maybe I'll try out that route instead if I fail the exam - Lumbagohttp://xkcd.com/327/ |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-18 : 12:27:25
|
I just got the same question again and here is the explanatio behind the answer: quote:
The full formula is 1 - ((A - B) / C), which scales the value to a percentage. This formula determines the amount of plan reuse being achieved in a SQL Server instance. When a recompilation occurs, the existing query plan is thrown out and a new one is generated. This is why the recompilations are subtracted from the compilations. Every query that is issued against the server running SQL Server must be compiled and is then stored in the query cache. When a batch (either stored procedure or ad hoc) is sent to the server running SQL Server, the query optimizer first looks in the query cache for a plan that matches the batch being sent. If the optimizer finds a plan, it reuses it. Otherwise, it forces a compilation to occur. If SQL Server did not reuse any of the query plans, the number of compiles/sec would equal the number of batch requests/sec. So each batch that is sent to SQL Server that does not need a compilation or a recompilation indicates that an existing plan is being used. The result of this formula ideally should be as close to 100 percent as possible.
- Lumbagohttp://xkcd.com/327/ |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-18 : 14:05:26
|
quote:
Originally posted by Lumbago
But it's nice to know that you can become an MVP without being certified...maybe I'll try out that route instead if I fail the exam
MVP has nothing to do with certs, as I'm sure you know. It's community contribution and deep technical knowledge. btw, I have all of the SQL 2005 and 2008 certs, except for the BI ones, so I hope I wasn't your example of an MVP that isn't certified (I do know of a few)Some general exam advice:RelaxRead the question carefully. I've before now read the question quickly, answered and then noticed the one word that completely changed the whole scenario.Do a process of elimination on the answers. Often you can discount half of the answers because they are totally wrong.RelaxThey're not actually that hard if you know the fundamentals and think carefully.--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-01-18 : 14:49:52
|
| I'm not certified. I've never even attempted to pass an exam. I am an MVP though. I don't do well on tests typically, which is just a small part of the reason why I haven't attempted any of the cert exams. I have taken a few practice exams though and have failed all of them. I consider myself to be a very good and experienced DBA, so my failures at the practice exams are a reflection on how relevant the questions are to a real world scenario.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-18 : 16:06:32
|
| Whoever invented the Microsoft MVP program was a genious and of course I know/knew that certifications are not a requirement. The great thing about the MVP program is that it's sort of a "secret alliance" of the most admired professionals in the business that give the most back to the community. Sort of like the freemasons-gone-community-friendly The difference between a certified professional and an MVP is that an MVP is like a million times more likely to know what they're doing. I've met so many people with certifications that don't know sh**, but unfortunately it's a job requirement for the consultancy job I started in december so it leaves me no choice. Let's hope I pass...- Lumbagohttp://xkcd.com/327/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 02:21:11
|
| "I have taken a few practice exams though and have failed all of them. I consider myself to be a very good and experienced DBA, so my failures at the practice exams are a reflection on how relevant the questions are to a real world scenario"Priceless, and valuable, advice I'm sure there is a word for that grammatical construction in English ... |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-19 : 06:33:12
|
| I PASSED!! Thanx a lot for having faith in me Tara but acing it would have been quite a stretch. I passed with the smallest possible margin...seems like I tuned my reading efforts perfectly - Lumbagohttp://xkcd.com/327/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-01-19 : 06:35:36
|
Congrats Lumbago !
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-01-19 : 06:58:47
|
Congrats!
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-19 : 08:16:21
|
| "I PASSED!!"Fantastic! Well done. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-01-19 : 08:21:21
|
| Thanx guys... - Lumbagohttp://xkcd.com/327/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2010-01-19 : 08:44:36
|
quote:
Originally posted by tkizer
I'm not certified. I've never even attempted to pass an exam. I am an MVP though.
Yes you are....I guess I live in too many other worlds....did you know DB2 z/os STILL doesn't have a robust Procedural SQL extensions?Quite painfulIn any case, the answer is D). Who give a sh....Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2010-01-19 : 08:59:22
|
| good work Lumbago!And brett all we need is a grape fruit, juice fruit ___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.7 out! |
|
|
|
Next Page
|
Exam gets me worried!!