September 2, 2009 at 7:55 am
C'mon, you won't get tossed......far
September 2, 2009 at 7:59 am
Jack Corbett (9/2/2009)
Steve Jones - Editor (9/2/2009)
GilaMonster (9/2/2009)
Nah. Forgotten about it already.She says that Jack, but let's see if she invites you to train on Tues or Wed night ...
I'll politely refuse. Don't want to get tossed around by her, you, or Kalen Delaney. At least I know you are bigger than me.
Ooh, I'll go! Any chance to learn something new.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 2, 2009 at 8:11 am
Grant Fritchey (9/2/2009)
Ooh, I'll go! Any chance to learn something new.
First item learned? Think twice before volunteering in the future.
😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 2, 2009 at 8:38 am
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?
Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage engine decides that it needs an entire table it can issue requests to the OS for the entire thing at once. That can spike the queue length but it's not necessarily a problem.
Second, and more important, it's very hard to interpret on SANs. On direct attached storage the rule-of-thumb of 2 per spindle's pretty good. With a SAN and all the switches and cache and SAN controllers, etc there's so much between the server and the disks that it's very hard to say if a queue value is bad or not.
This podcast by one of MS's Premier Field Engineers is an excellent discussion of perfmon and the counters to watch.
http://runasradio.com/default.aspx?showNum=81
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:45 am
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
What is wrong with using Avg. Disk Queue Length?Two things.
Firstly, SQL can and does drive it very high if it does large read-ahead reads. If the storage engine decides that it needs an entire table it can issue requests to the OS for the entire thing at once. That can spike the queue length but it's not necessarily a problem.
Second, and more important, it's very hard to interpret on SANs. On direct attached storage the rule-of-thumb of 2 per spindle's pretty good. With a SAN and all the switches and cache and SAN controllers, etc there's so much between the server and the disks that it's very hard to say if a queue value is bad or not.
This podcast by one of MS's Premier Field Engineers is an excellent discussion of perfmon and the counters to watch.
Excellent. Thanks. But now the follow-up. If you could only pick one or two disk counters to watch, what would they be?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 2, 2009 at 8:47 am
Grant Fritchey (9/2/2009)
Ooh, I'll go! Any chance to learn something new.
Awesome. The more the merrier.
p.s. last year Steve and I were the ones who got pounded into the floor the most. Steve by a couple of the guys from that dojo, me by Kalen.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:51 am
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.Thanks. I was told the max number was 435. I only saw 410.
Mine maxed out at 255. Possibly cause most of the USA was still asleep
Still, that's one heck of a lot of people to fumble the reports for Data Collector in front of.
🙂 My internet connection dropped during your session. I reconnected just in time to see you muttering about the demo not working.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:56 am
Grant Fritchey (9/2/2009)
Excellent. Thanks. But now the follow-up. If you could only pick one or two disk counters to watch, what would they be?
The three I usually use are Avg sec/read, Avg sec/write and % idle time. If I had to pick 2, it would be the first two. It gives a good idea of exactly how the IO subsystem is performing, regardless of whether it's a SAN, direct storage, flash or whatever.
If you have some time free, listen to that podcast.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 2, 2009 at 8:56 am
GilaMonster (9/2/2009)
Grant Fritchey (9/2/2009)
GilaMonster (9/2/2009)
Hell Grant. 425 attendees! That's going to be one of the best-attended sessions so far.Thanks. I was told the max number was 435. I only saw 410.
Mine maxed out at 255. Possibly cause most of the USA was still asleep
Still, that's one heck of a lot of people to fumble the reports for Data Collector in front of.
🙂 My internet connection dropped during your session. I reconnected just in time to see you muttering about the demo not working.
Yeah, not enough rehearsals on this one. I didn't run into that problem during either of the two run-throughs. I usually do three or four (paranoia is a good thing).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 2, 2009 at 10:39 am
Grant Fritchey (9/2/2009)
(paranoia is a good thing).
You're just saying that because you want us to be brainwashed into being paranoid!
Ack!! Get outta my head!!!!
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
September 2, 2009 at 10:43 am
You know the saying...
It's not really paranoia if they are out to get you
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 2, 2009 at 11:44 am
jcrawf02 (9/2/2009)
Grant Fritchey (9/2/2009)
(paranoia is a good thing).You're just saying that because you want us to be brainwashed into being paranoid!
Ack!! Get outta my head!!!!
Trust me, my brain is beyond washing! There's no such thing as "clean mud".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 2, 2009 at 12:16 pm
Thanks to 24 Hours of PASS my brain feels like it's been bleached.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 2, 2009 at 12:36 pm
Can't wait for the audio to be made available for download.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
September 2, 2009 at 1:11 pm
CirquedeSQLeil (9/2/2009)
Can't wait for the audio to be made available for download.
Yeah, me too. I only got to see the first half of Adam's presentation. I need more.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 7,831 through 7,845 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply