Please wait, connecting to server...
Connected!
Welcome to the conference.
Welcome to the chat Q and A
|
remember to change display names back |
Jorge Segarra's username is changed to Jorge Segarra (@sqlchicken).
Adrian Hills's username is changed to Adrian Hills (@AdaTheDev).
hkhkj hk's username is changed to Nick Cheever.
Arron Green's username is changed to @azzgreen.
|
back ow |
Charles Hunt's username is changed to Charles Hunt (@charlezhunt).
|
I had to come to work. Is the presentation on a break? |
Paul Sligar's username is changed to Paul Sligar (@dpsligar).
Russ Johnson's username is changed to russjohnson.
Jeremy Huppatz's username is changed to Jeremy Huppatz (@ozziemedes).
|
@Russ, yes back at top of the hour |
|
Any one from Philadelphia area? |
Mladen Prajdi%E6's username is changed to Mladen Prajdic (@MladenPrajdic).
russjohnson's username is changed to @russjohnson.
john Pertell's username is changed to @jayape.
|
< from Toronto, Canada |
|
@AdaTheDev Thanks |
Jay Bonk's username is changed to Jay Bonk (@jaybonk).
|
gr8 |
|
go leaf go |
|
welcome back all |
Artem Ervits's username is changed to Artem Ervits @dbist.
parmesh Bheemreddy's username is changed to Parmesh.
|
Amit, any chance you from Tampa, FL? |
Kevin White's username is changed to @kevindwhite.
|
as ive never used twitter, whch url should i be going to after i get an account? https://twitter.com/#QuestQA ? |
|
@Amit, Go Leafs Go. LOL |
Karin thomas's username is changed to Karin.
|
Nope, I wish....Sunny florida |
John Gasper's username is changed to John Gasper (jtgasper3).
Jack Corbett's username is changed to Jack Corbett (@unclebiguns).
|
from toronto |
|
Any East coast guys? |
|
@vince join then search for #QuestQA. that will take you to the search results. |
|
@vince http://search.twitter.com/search?q=%23questqa for twitter #questqa search |
|
Hello, Are we going to record this session? |
|
Great made it back for a break? |
Roger Hullstrung's username is changed to Roger.
|
<--Jacksonville,Florida |
|
NYC here |
|
Anyone getting audio or video on the presentation? |
|
I am |
 Charles Hunt (@charlezhunt) |
Boston |
|
i ma |
|
Nope I got nothing |
|
i Am |
Robert Heim's username is changed to Rob (@DevFactotum).
Dena McCabe's username is changed to Dena.
|
I've got nothing now either |
Eli Weinstock%2DHerman's username is changed to Eli Weinstock-Herman (@tarwn).
|
@Rudy It blanked for a bit but is back for me now. I have to refresh occassionally to keep in sync though |
|
Hit refresh and got audio and cidwo back. |
Alan Barber's username is changed to Alan Barber (@AlanBarber).
|
ah ok, I went to junior high with a kid named Amit Patel so was just wondering lol |
|
@kevindwhite thanks! |
|
< clicked on Session Room and it came back |
Dave Ballantyne's username is changed to Dave Ballantyne (@davebally).
|
I didn't know I could correlate profile trace with performance counters, sick! |
|
when is the next presentation ? |
Gareth Swanepoel's username is changed to Gareth (@GarethSwan).
|
4 mins |
|
yeah @artem, very cool feature. I learned that trick via Jack Corbett's presentation |
|
Jorge, were you running client-side chat that you brought it down? |
Roger's username is changed to Roger @SQLZcar.
|
I'm sure this has already been asked, but will the slide decks be available for download? |
|
most likely yes |
|
The slides will be available later at http://questkb.com/live - thanks![ProcessingInstruction] |
|
@Mike: Slides: http://questkb.com/live/ |
|
Thanks, Jonathan. |
Colin Smith's username is changed to Colin Smith (@Smithco32).
Nitin Salgar's username is changed to @nitinsalgar.
's username is changed to Stephanie McCulloch.
|
I must send Quest some new music, this elevator music is driving me nuts |
|
Nice one |
|
I find it amusing the when I right-click my username on the side, there's a menu that's hidden by the Firefox default right-click menu. |
Michael Antonawich's username is changed to @mikeyant.
|
I see poor network performance. Do other exp. the same or is it just with me ? |
|
@mikeyant didn't know you were on Twitter. |
Peter Schott's username is changed to Peter Schott ( @paschott ).
|
I'd like to get the poster. What's the process? |
 konrad zedler |
Is everyone seeing a black screen? |
 Sheila Wagner |
horrible network performance for this conference |
Vic Prabhu's username is changed to @SQLJackal.
|
If you're having audio/video issues, try refreshing your browser. |
|
@konread - hit refresh |
|
@linda http://www.quest.com/backstage/ for free posters/resources from Quest |
Jamie Brennan's username is changed to James (@James_Brennan).
|
Please visit the Quest SQL Server promotions pagehttp://www.quest.com/backstage/promotion.aspxfor posters.[ProcessingInstruction] |
|
If you still don't get good A/V performance, go to http://questkb.com/live and fill out the survey at the top. |
|
What happen to the music? |
| konrad zedler |
Performance for the session seemed to get better for me when the chat went down |
 Christina Leo |
are we still in a break? i've got no audio/video |
Mark Simkin's username is changed to Mark Simkin (@msimkin).
|
they mentioned they had 600 people online. i wonder how many they expected. |
|
If you don't have audio/video, click Refresh in your browser. |
| konrad zedler |
hit f5 |
|
We had over 2,500 registrations, so I'm expecting around 1,200-1,300 participants over the day. |
|
i've got the poster that Thomas LaRock did...very nice |
 Jack Harris |
no video, no sound |
|
Ringo Rules. |
|
yep the new poster is not out there yet, but Quest posters are great! |
|
Does anyone know if the gartner report that Brent referenced earlier is availble ? , been googling but no luck |
|
Will this presentation be back, or done for today, |
|
If you lost audio/video, hit refresh on your web browser.[ProcessingInstruction] |
|
Is this going to be available for download? |
|
Baccoonnn! |
 Nick Cheever |
For those of experiencing low bandwidth, there are some tweaks on these pages that could help out your local situation http://www.vconferenceonline.com/shows/spring10/quest/conference/quickhelp.asp http://www.vconferenceonline.com/shows/spring10/quest/conference/faq.asp |
|
The sessions will be on demand here from March 4 – April 3rd. |
|
Man, I'm gonna have pizza, but not bacon. Now I want bacon pizza. |
|
what is the command to add to the ini file in sql 2000 to enable physical disk statistic monitoring? |
|
The Gartner report is here - http://www.quest.com/gartner-magic-quadrant/ |
|
The slides will be available later at http://questkb.com/live - thanks![ProcessingInstruction] |
|
nice so see a macbook pro in a sql server training session  |
| Jack Harris |
I can receieve 25Mbps and still have bad performance |
|
Please send me a kindle |
|
So I'm betting the one he just opened is not going back out to someone |
|
what is the survey or are we automatically entered |
|
I want a free gift |
|
i seeit now, |
|
It is running well on my machine. Skips occasionally. |
|
please send me a kindle tooo |
|
Thanks Brent |
|
the prizes are for US only, correct? |
 Colin Smith (@Smithco32) |
he just broke my Kindle |
|
LOL! |
|
The prizes are US only. Sadly, I just broke my OWN Kindle, hahaha. |
|
I'll take the broken one |
|
Mr. Ozar, how are you? |
|
thanks Jeremy for recommeding the tool for perf mon analysis |
|
@Kevin and Brent, you should do this more often..Goood work on the presentation |
|
The presenters each got one too. I'll give that broken one to Kev, hee hee. |
Christina Leo's username is changed to @christinaleo.
|
US only! Booooooo |
 Laura Krantz |
how do you win a kindle? |
|
US only! Booooo |
|
I will only read SQL books on the Kindle. gimme! |
|
Thats unfair  |
|
booo  |
|
@Muhammad I'm great, but right now isn't the best time for small talk. |
|
UK is nearly US - only one letter in it! |
|
@BrentO: ROFLMFA! i can't believe you just dropped that |
|
SQLHeartBeat is great for quick performance monitoring of SQL Server |
|
+Canada please |
| Jack Harris |
video sound back |
|
right, that's unfair ^^ |
|
@Jonathan hahaha, I know, right? Whoops... |
|
I'll buy Brent's book if I get the Kindle |
|
Italy, please! |
Kelly Martinez's username is changed to Kelly (@greeleygeek).
|
Christine: You're welcoime  |
|
Sorry about the US-only thing - that's our legal team. We've run into trouble shipping prizes to foreign countries. |
|
@Brent I want one. Make 'em come to Slovenia too |
|
@Gus, Buon Girono |
|
what's the config switch to enable physical disk stat on sql 2000? |
|
i m bridgeport, CT. can I get one? |
|
I can pay the shipment to Sweden |
|
I am ready to pay the shipping |
|
Hi Brent |
 Feodor Georgiev |
hello all! |
|
Wireless Reading Devices Raffle rules can be found here http://www.quest.com/landing/?ID=4877 |
|
@miladen if you win the kindle, you can ask Quest to ship it to me |
Richard Garrett's username is changed to Cranium.
|
to UK |
|
Buon giorno! Here is 4pm... |
|
And it's gpoing through to 23:30... |
|
Good job, it really worth the time. Thanks for the Good job. |
Cranium's username is changed to Richard Garrett.
|
@Gus, qua sono le 10 |
|
@Lekan thanks, glad you like i! |
|
@Gus Simoni, Here is 12:12AM ^^ |
|
Brent you are anything, but a young upstart in SQL, hahaha |
|
@Sandy diskperf -y |
|
@Rudy where u from? |
| Colin Smith (@Smithco32) |
sad to say I got the greys anatomy reference |
|
Toad > SSMS |
|
@Gus Toronto, Canada |
|
@SQLJackal no, I'm an old upstart.... |
Stephan Weber's username is changed to Stephan Weber (@aashkelon).
|
Can people see the video? mine has gone blank. |
|
poor transmission |
|
Still see video |
| Colin Smith (@Smithco32) |
I still have video |
|
In NZ, this event is 1.45A-11.00A |
|
More select * |
|
blackout |
|
I have it too |
|
video is fine |
|
Thank you Brent! |
|
Brent dropped the camera too. |
|
try refreshing |
|
@patrick - happend to me too - try refreshing |
|
Thanks. |
| Colin Smith (@Smithco32) |
try refreshing brownser |
|
Other than it's a Quest product any reason to use Toad over SSMS? |
|
I just thought they got rid of the awful music! |
|
lots of great reasons, yes |
|
Geoffery, a ton. I'll be recording videos for my site soon. |
|
@Geoffery yeah, it's got a ton of features - http://www.toadsoft.com - too many to cover here. |
|
I don't work for Quest, I just like the product. |
| Jack Harris |
I had to reclick Session Room |
Brent Ozar's username is changed to Ari Weil (@aweil).
|
Toad is great for both SQL and Oracle management |
|
I cannot see or hear anything right now!! |
|
Toad is nice. Haven't used it in a long time though. |
|
@Rudy my wife was there last week... sweet! |
|
Thanks. Refresh worked. |
|
Just like Kevin, my existence at the moment is sustained by caffeine  |
| Feodor Georgiev |
@Ari : I would love to work for Quest |
|
@brent what is this strange alien looking tool you're using? |
|
SSMS, that's enough. |
|
@Brent, will the queries you guys are using be available? |
|
@Feodor, if you want to continue that conversation you can email me at ariel.weil@quest.com |
|
Refresh worked! |
|
The queries will be available at http://questkb.com/live |
|
Thanks Brent |
|
or get the info from spotlight on sql server. |
|
I have no video on Firefox or IE6 but IE8 is ok why? |
|
I wish I could multitask as fast as everyone else! I do not use twitter very often and I cannot keep up! |
|
@Jolene, I'm with you!! |
|
Summaries. |
|
Grouping. |
|
I love that Toad has a Search SQLServerPedia box |
|
Oops. |
|
@Jonathan ha! Yeah, we're adding that into all of our products. |
|
Stay tuned to www.made2mentor.com in the next couple of weeks if you want to see what TOAD does. |
| Feodor Georgiev |
@Ari - am I talking to Brent Ozar or Ariel Weil? (I got this message "Brent Ozar's username is changed to Ari Weil (@aweil).") |
|
Summaries, Grouping, SQL Formatting, Better troubleshooting of code, etc in TOAD. |
|
Sweet |
|
nice |
|
Never heard of Toad |
| Sheila Wagner |
where con i get TOAD? |
|
this is the 3rd session.. WHERE can we get the presentations from? |
|
You can get Toad at http://www.toadsoft.com |
|
There's a freeware version on Quest's site. |
| Sheila Wagner |
ty |
|
@BrentO I need to get some notes on how to convince my boss to let me buy Toad |
|
@Marvin - http://questkb.com/live - Kev will upload his in the next couple of days. |
|
Code Snippets rule too. |
|
*grin* @MladenPradic's SSMS Tools package provides some nice additional features for SSMS that will do similar things... but of course, Toad has a good reputation too. |
's username is changed to Stephanie McCulloch.
|
@Brent, how does Toad compare to Aqua Data Studio? |
|
Brent can we download these videos later from Quest |
|
will these queries by available in the documentation? |
|
@Jonathan, that's something we can help you with. Email me at ariel.weil@quest.com and I'll get you some help once I fly back home. |
|
We did a webcast on Toad and the SSMS Tools Pack here: http://www.quest.com/events/listdetails.aspx?contentid=9754&technology=34&prod=&prodfamily=&loc= |
|
I think it was Toad that I used back in SQL 7 days when SSEM couldn't script out triggers. |
|
ty |
|
The sessions will be on demand here from March 4 – April 3rd. |
|
RedGate SQLPrompt does snippets as well. I've never used Toad, but it does look very good. |
|
@glenalanberry works for News Gator |
|
What's Glen's last name? can you send me a link for his dmv queries? |
|
@Christine we'll post all links on http://questkb.com/live as we track 'em down. |
 Nick Weber |
Toad is what I used as a conduit to get our Oracle/SAP team to look at SQL[ProcessingInstruction] |
|
yay i'm getting some Brent and Kevin love |
|
Brent, I asked at pass but cannot remember. Is there anyway to get a batman sticker? |
|
All of our peoplesoft developers use Toad |
|
@Jolene sorry, they're out of production... |
|
when is the next "spend the day with the experts" event in NYC |
|
Bret, will you repeat what you said about getting DMVs posters? Thanks |
|
@Jolene The batman stickers have been replaced with SQLRockstart stickers. @SQLRockstar on twitter. |
|
Sorry, we don't currently have plans to do a spend a day in 2010. |
|
For links, posters, downloads, etc - they're here: http://questkb.com/live |
|
too bad |
|
ty |
|
Instead of doing Day with the Experts events, we're going out to SQLSaturdays. We can help more people that way. |
|
Please visit the Quest SQL Server promotions pagehttp://www.quest.com/backstage/promotion.aspx for posters |
Chris Kasten's username is changed to Chris K (@Chris_Kasten).
|
BrentO: you should come down to the Houston SQLSaturday |
|
@Jonathan I wish I could, but I've got a schedule conflict. |
|
For those in the UK, there's SQLBits VI on 16th April in London (freebie, 1 day event) |
|
@Brent, SQL Saturdays are limited to people who live near where it's being presented. But a SQLSaturday on the web would be great |
|
@Rudy like the 24 Hours of PASS? |
| Colin Smith (@Smithco32) |
getting my ssms toolkit now. Looking forward to checking it out |
|
@BrentO, I have not even set the date for it yet. I am co-chairing the event. |
|
at some point can you talk about VDI + VSS for application consistent vs. CRASH consistent replicas of SQL DBs. Maybe an explaination of updates occuring in SQL application cache and periodically being written down to disk (trans log + DB + checkpoint file for recoverable crash copy - howto recover) |
|
is SQLSaturday going to be available on the net? |
|
@Brent, yes |
|
Would embedded CLR code create external waits? |
|
I'm registered for SQLSaturday in NY |
|
Instead of a Kindle, I want a SQLSaturday at my house |
|
Most of my wait types are CLR_AUTO_EVENT. What are those? |
|
@Marty - that's outside of the scope for today, but if you'd like to email me at brento@brentozar.com I can see if we can do a webcast on that. |
|
@Thomas no, unfortunately. |
 Kevin Lasky |
kimberly? do you have room for all of us and plenty of food? |
|
@Kimberly Where do you live? If it's in the right place I'll come and present. |
John Masseria's username is changed to John Masseria (@HeatfanJohn).
|
@Kimberly, I'll bring my server and a case of beer |
|
Not seeing a graphic. |
|
Laughing at all the chatting - hard to keep a straight face on the video. |
|
no Sond or video |
|
@kevin lol I'm in rochester NY, it's not close to anything, but I'll take beer donations lol |
|
BrentO - Lol |
|
@Parmesh try refreshing your browser. |
|
does DC area have SQlSaturdays? |
|
@Parmesh: refresh your browser |
|
@kimberly Rochester is plenty big to host a SQLSaturday. |
|
Thanks I got it |
|
how do you convince a vendor to fix their software when it comes to missing indexes etc? |
|
I'm in Canada and we never have any SQL anything happening here |
|
Thanks Brent. BTW" great Job on the training webcast. |
|
Brent , #is there any way i can get online to SQLSaturdays ? |
|
@Artem unfortunately, this isn't a seminar on negotiations. |
|
@ ArtemYou fix it for them and send them code LOL |
|
@Suleman no, sorry, PASS doesn't webcast those. |
|
@Thomas The issue with SQLSaturday on the NET is that they are hosted at various locations and you aren't guaranteerd interent access |
| Kevin Lasky |
SELL THEM THE FIX |
|
Yield before Zod! |
|
Woohoo! Up to 852 attendees. |
|
Doing a SQLSaturday like the today's format would be cool |
|
brent, do you plan those in london anytime in the future ? |
|
@Rudy: 1+ |
| Laura Krantz |
I agree with @Rudy |
|
@Suleman I don't plan SQLSaturdays - check out http://www.sqlsaturday.com or http://sqlbits.com. SQLBits is in London this year. |
|
The problem with doing SQLSaturdays like this online is that this is EXPENSIVE to do. |
|
@Jack: Tnx for the info! |
|
@ Kevin then they consider you a frenemy but my way you can become a "consultant" by accident |
|
I agree SQL Saturdays online would be cool! I am in San Antonio. |
|
Thanks! |
|
@Brent, how about you make "Saturday for SQL" instead |
|
Need to start paying attention instead of chatting. |
|
I find blunt objects with high levels of inertia to be helpful. :) Failing that, a variation on the "are we there yet?" meme - "Are you going to change it?" No. "Are you going to change it?" No. "Are you going to change it?" - Rinse and repeat until the answer becomes "yes" |
|
Talk to Pass , im sure that the SQLSaturday franchise can cross the border if there is enough interest |
|
hoping they'll do a sqlsaturday in Denver soon. |
| Kevin Lasky |
sell the code... sell the time... same end |
|
If you're looking for free online training check out PASS' Virtual Chapters http://www.sqlpass.org/Community/VirtualChapters.aspx and free events like http://sqllunch.com |
|
If you're interested in attending a SQLSaturday and there's not one in your area, please think about volunteering with PASS to put one on. It's all volunteer-driven. You can do it - we can help. |
|
For those curious, SQLSaturday does go beyond US borders. Recently New Zealand hosted a SQLSaturday, contact @venzann to see how that went |
|
@Jolene come down to the one in Houston |
 @SQLJackal |
Miller time is the best wait, lot of I/O there, haha |
|
There are online livemeetings about SQL topics nearly every day, you just have to find the local usergroup giving them, twitter is a great way to find this info |
|
Hey Kevin, where is the Jack Daniels or at least the Lynchburg Lemonade? |
|
@ Kev sounds like a Man U fan |
|
@Tim ha! I'll ask him that. |
|
You can also check out many of the regular chapters who make meetings available via live meeting. Orlando PASS meets 2nd Tuesday every month and we put it on line. Check our http://orlando.sqlpass.org |
|
Lots of local user groups also record the livemeetings and post them on the sites. |
|
"Saturday for SQL" would be cool in this format and you could view it at home in your PJs with baccon/beer |
|
to muxh information... *overload* |
|
@Antoni Arsenal! |
|
I'll try but my health problem mean I spend the weekends resting. |
|
I am Gunner 4 Life!!! |
|
@Jolene: Understood |
|
@kelly In Denver they do the Tech Trifecta which includes a SQLSaturday. I think it was just last weekend. |
|
Now Bacon flavoured beer is the way to go!! |
|
@Antoni haven't seen the new stadium...can't wait to get out there |
|
@Kelly it's the ROcky Mountain Tech Tri-Fecta |
|
a SQLSaturday in rochester would be pretty cool. We have companies like Kodak, Xerox, Fujifilm, Wegmans, Johnson and Johnson and many other big names. Might be a good location to set something up... might be a good opportunity to advertise quest products |
|
@jack yep. That was last weekend and I didn't hear about it till too late. Was VERY bummed. Next year though |
|
Is there a way to read data directly from .mdf file without a SQL engine? |
|
Can we get sys.dm_os_wait_stats type of info on a per-database basis? |
|
@Blesson no. |
|
Vid frozen. |
|
@Bob no, because queries can cross databases. |
|
Me neither but a friend brought me a scart and a bag from the new stadium |
| @christinaleo |
@BrentO - I'll help put a SQLSaturday together in Nashville! |
|
Unfrozen. |
|
@McLaren, but I'll show you a tool that can  |
|
@Bob you can get some IO wait data that I'll talk about this afternoon. |
|
@christinaleo I think they've got one coming - email kekline@quest.com. He lives in Nashville. |
|
@Blesson Idera has a tool that can query .bak files without SQL DB Engine or SSMS |
| @christinaleo |
@BrentO - thanks, will tweet him |
|
Cool, Thx |
|
Have to tell you - this vconf is fantastic |
 |
|
@Artem @blesson yes, we too (Quest) have tools that will query .bak files, but he asked about .mdfs. |
|
|
|
|
|
< agrees with Debbi |
|
I agree! This conference is not over my head! I will be able to use the info! |
|
Is that sarcasm? |
|
If you like this virtual conference, take our survey at http://questkb.com/live at the top. Thanks for your support! |
|
|
Tim Edwards's username is changed to Tim Edwards (@timbo_b_edwards).
|
. |
hkhkj hk's username is changed to Nick CHeever.
|
|
|
not a bit - very good for both newbies and senior dbas |
|
semaphore is a traffic light |
|
|
|
Yeah i have to agree with Deb this is great guys |
|
Shouldn't we wait until later in the day to take the survey! |
|
Those interested in SQLSaturday should check out www.sqlsaturday.com and contact blythe.morrow@sqlpass.org |
|
and interesting for non-DBAs |
| Nick CHeever |
Everytime you compliment the conference, brent gets an extra cookie during lunch. |
|
@Nick HAHAHA |
|
Semaphore is not nothing to do with large flags then |
|
If you're on LinkedIn, find Andy Warren and add him, he is a bigSQL Saturday guy. |
|
@Nick I'm hoping they'll replace that Kindle I borked. |
|
If free lunch was served it would be perfect |
|
@Antoni it is! Well, it is HERE, but not THERE. |
|
@ Brent , whats the tool from quest software that allows you to query the .bak file ? and does it have to be a backup created by the quest backup software ? |
|
I think I got a scout badge for learning semaphores... |
|
@Dave, no unless the flags an massive |
|
Linkedin is great, I have been using for about a month! |
|
@Antoni we could eat on camera to make it feel like it's there |
|
@Suleman you can do it with Toad or with LiteSpeed, and it doesn't need to be a LiteSpeed backup. |
|
What've seen so far is fantastic - |
|
Any chance ASYNC_NETWORK_IO and CXPACKET could be talked about? |
|
@Emerson, absolutely |
|
@ Brent , excellent ! thnx i will try that tonight |
|
Yes,good stuffs already. I'm onto somethings happening in my client apps already. |
|
yeah, don't bring up that movie... they all die in the end. |
|
often there isn't time to dig into these good details so it's both a refresher for me with new tips I can't wait to use. |
|
Sure am glad we can save this log. Too fast to keep up! |
|
Aid my investigation |
|
What is Jimmy's blog (link)? |
|
The thing I love about vconf is that I can implement as they talk. Added Severity Level alerts this morning. Thanks Kevin! |
|
@Nick: I suspect @Brent might be more motivated by additional slices of bacon |
|
Any chance you can show us how to identify which exec plans have the most CXPACKET wait times? |
|
@Jonathan http://lmgtfy.com/?q=jimmy+may |
|
@Bob I'd love to, but that's pretty far outside of the scope we can address in this time slot. Great question though. |
|
CXPACKET waits usually corresdponds to MAXDOP settings |
|
are the numbers in sys .dm_os_wait_stats cummulative? Since SQL Server was last started? |
|
< gives Brent some Canadian back bacon |
|
@BrentO I didn't catch his last name. Thanks! |
|
@Jonathan doh! Sorry about that. |
|
How about MSQL_XP waut type? |
|
Can't wait to set my MAXDOP to 1. Got an itchy trigger finger |
|
When you say hight Async_network_io - that means as compared to your baseline, right |
| Feodor Georgiev |
@brent If you do SQL Saturday in Stockholm, I will personally get you a kilogram of bacon. |
|
Is Ari on cam as well? we dont see him |
|
@BrentO: No worries we are all poking at each other. That is what makes this fun. |
|
how does pageiolatch differ from pagelatch? |
|
MSQL_XP is belied by the name, processing is waiting for action in an XP |
|
@Fedorov: Me too!!! |
|
Ari's not on camera yet but he'll be in about 15 minutes. |
|
Ari is on camera, but like most DBAs he is invisible until needed |
|
@Feodor I was just in Stockholm a few months ago! I might be back in June, but it's tough to schedule those. |
|
Page IO Latch is loosely I/O whereas Page Latch is buffer synchronization |
|
@Joseph HAHAHA |
|
Sorry, I missed the location of the DMV's you had you snippet box on the screen? |
|
@ Brent please tell me you guys are going to provide the powerpoint I can't take notes LOL |
|
Peanut Gallery? No more bacon for you, @BrentO!!!  |
| Feodor Georgiev |
@Brent: you are up for 2 kg of bacon! |
|
@Brent: you don´t wanna miss the royal wedding right? |
|
Thanks to MS for making DMV... it's great stuff |
|
For the scripts and PowerPoints, visit http://questkb.com/live - Kev's aren't up there yet, but they will be in a couple of days. |
|
@Thomas I'm the Best Man. |
| @christinaleo |
@Antoni - Additionally, the presentations will be available on demand from March 4th - April 3rd |
|
If you guys are broadcasting from Nashville I can make it there in a few hours from Memphis |
|
can also clear dmvs for a given database... |
|
@Brent: *hehe* could have sworn u were the prince to be |
|
wow. nice. DBCC to the rescue. Paul would be proud. |
|
(for cached plans) |
|
I thought all healthcare and trading companies ran Oracle? |
|
@Mike, not here |
|
@Brent, does that DBCC with clear , clears all the resources cleared by rebooting the server ?? |
|
sp_whoisactive from adam mechanic is aslo a very cool sp that i am using for monitoring.... |
| Thomas Lane |
@ Bob Mc watch this before changing Maxdop http://webcasts.sqlworkshops.com/webcasts.asp not that you should not but not all cxpacket waits are bad |
|
@Venkata I talk about that this afternoon, too! |
|
@Suleman no. |
|
Our hospital runs Oracle only for Peoplesoft, otherwise everythig is on SQL |
|
Brent, you know how to drive developers crazy - tell me the their developed SP's must run under 2 secs and then provide it to them when they run over using DMVs! hehe |
|
relax, Rudy...I was just joking. |
|
@brent, sorry i dint get the use of the DBCC yet, do u mind telling that again. |
|
See, Ramesh Meyyappan's webcast. It can gives you more deep considerations on CXPACKET wait Here, www.sqlworkshops.com |
 Bob McLaren Thomas Lane |
Will do |
|
@Mike, I know. |
|
@Brent Oh Thats Gr8 |
|
@Ozar I downloaded Toad for SQL Server and my McAfee report there's "Generic Downloader.x!dde" virus alert on file: \program files\Quest SQL Optimizer for SQ LServer\SynM.dll |
|
@Gnu hmm, haven't heard that one. You might check with support - there's a very active mailing list and support for it. |
|
are you using SQL from MAC? |
|
@GNU there is your problem McAfee |
Jonathan Gardner's username is changed to Jonathan Gardner (jgardner04).
|
Does anyone know is MS has introduced additional DMV in SQL 2008R2? |
|
Thinking about getting Married while at SQL Connections, any witness volunteers? |
|
@Rudy no new ones, but a couple have more fields. |
|
am I the only person bothered by Brent running a Mac? |
|
Yes |
|
@Mike no, it bothers my coworkers too. Ari has a Mac too, but not with him. |
|
i think its great that he has a mac |
| Gareth (@GarethSwan) |
@Mike. I'm not bothered, just proud. |
|
I feel betrayed |
| Feodor Georgiev |
@Mike NO! |
| Jeremy Huppatz (@ozziemedes) |
@Mike: Last I heard, half of the devs at Microsoft are running Macs |
|
can you explain this DMV a bit more: sys.dm_exec_{Proc}_stats |
|
brent needs one more sticker and cover that Apple logo |
|
@Chris HAHAHA, no. |
| Gareth (@GarethSwan) |
@Mike. Think of it as just a tool. He's not running SQL on the mac. Just client-side apps (office, etc). |
|
Brent, Where can I get the Perfmon counter chart ( recommended values)? Thanks |
| Eli Weinstock-Herman (@tarwn) |
ok, admit it, someone else just tried to rt-click and copy off the vide screen... |
|
I'm not running a mac but am very impressed with them. Might go to one for my next.. |
| Jeremy Huppatz (@ozziemedes) |
(PS: It's actually a crappy dell with an Apple sticker on it. ) |
|
@Brent do you have sql server tools that you use on your mac or do you remote desktop to windows machines? |
|
Thanks Kevin |
|
*APPLAUSE* |
| Thomas Lane |
is there any tools available that do profiling that show the encrypted text decrypted |
|
clap clap |
|
Thanks |
|
shwag!!! |
|
Thanks Kevin |
|
Clap Clap Clap!!!! |
|
clap, clap |
|
thanks guys!! |
| Thomas Lane |
clap |
|
Thanks Kevin |
|
thank you Kevin |
|
I wonder how I can apply all of this to one of our vendors SQL installation in which they use cursors for EVERYTHING. |
|
thanks Kevin. |
|
tks Kevin |
|
clap, clap |
| @SQLJackal |
i think Microsoft Dev's are using MAC, not beacuse they like it, but they do use it for testing purposes! |
|
Thanks Kevin. |
|
Thanks Kevin |
| Gareth (@GarethSwan) |
Clap clap. |
|
Thanks Guys |
|
Thanks Kevin from Korea |
|
@ozziemedes I actually know someone who has done that. |
|
Well done Kevin and Brent! |
|
Quite useful. Thanks Kevin. |
|
Wish I'd been able to make it in earlier-- enjoyed what I heard. |
|
|
|
Thanks guys |
|
Good Job Kevin |
|
Well done guys - thank you for all that great information |
|
Wouldn't that be a bacon cheeseburger? |
|
Great job Kevin |
|
Golf clap |
|
dbcc sqlperf('sys.dm_os_wait_stats',???) what is the 2nd parameter? |
|
How can I get Kevin or Brent to come to Michigan to present at my SUG? |
| Eli Weinstock-Herman (@tarwn) |
Good sessions, thanks |
|
Nice Session Kevin |
|
get some rest Kevin |
|
There are some very good 3rd party tools that do wait stats analysis. Quest, Precise and Confio are 3 vendors that offer such products. |
| Feodor Georgiev |
Great job! Too bad I am really tired and cant keep up with the presentation.. but will make sure to watch the replays |
|
Time to go to my office to grab cables... |
|
@blesson - clear |
|
|
|
@blesson its CLEAR |
|
clear |
| Jeremy Huppatz (@ozziemedes) |
Nice work Kevin *applauds* Now gimme mah Kindle! |
|
Thanks gentlemen. |
| @SQLJackal |
thanks brent /kevin |
|
Cheers all. Nearly end of working day here in UK so dropping offline soon |
|
DBCC SQLPERF("sys.dm_os_wait_stats",CLEAR) |
|
cool |
|
thanks guys |
|
|
|
The sessions will be on demand here from March 4 – April 3rd. |
|
thanks |
|
The slides will be available later at http://questkb.com/live - thanks![ProcessingInstruction] |
|
Please take a moment to answer the questions in our survey athttps://vovici.com/wsb.dll/s/37ccg435e5 |
|
Very cool thus far. Looking forward to the rest! |
|
Please visit the Quest SQL Server promotions pagehttp://www.quest.com/backstage/promotion.aspx for posters |
|
is anyone else having video streaming issues? |
| Jeremy Huppatz (@ozziemedes) |
@AdaTheDev Harden up - it's 2:24AM here in Australian Central time |
|
does anyone know how to configure threshold files in PAL? |
|
I did a refresh for the video issues. |
|
@salahi just refresh. They are on break at the moment though |
|
Whats new with dmv's in R2 |
|
@ozziemedes - but I have a pub to visit! |
|
Only had that one problem where the whole session dropped at the start of Kevin's last on. Otherwise fine. |
| Jeremy Huppatz (@ozziemedes) |
Just for the record... am I the only Aussie dialled in for this? |
|
Are there any DBAs who can talk for few minutes |
|
Yes, refresh worked for that one. |
|
@Jeremy there are prizes? |
|
Are there different survey links for each session or is there just one survey for all sessions? |
|
thanks! |
|
Are there any DBAs who can talk for few minutes |
|
1:00am in South Korea. |
| Jeremy Huppatz (@ozziemedes) |
@AdaTheDev Hmm.... as long as there's also curry on offer, and you can set up the laptop over a 3G connection to see the rest of the presentations! |
| Charles Hunt (@charlezhunt) |
does anyone know the % overhead of running a server side trace? |
|
@Parmesh - now's probably the best time to ask questions if you have them. We're between sessions. |
|
@Kim you are dedicated |
|
Should I go to bed? ^^ |
| Charles Hunt (@charlezhunt) |
trying to compare to idera's query monitor which is 2-4% |
|
Hi, you might want to look at this overview of DMVs, containing many useful queries, from MSDN Magazine http://msdn.microsoft.com/en-us/magazine/cc135978.aspx |
|
@ozziemedes - Mexican tonight! Definitetly going to catch the ondemand vids though |
|
you can rate kevin for each session at http://SpeakerRate.com/kekline/ |
|
Wow! ^^ |
|
The overall survey for today's event is at https://vovici.com/wsb.dll/s/37ccg435e5 |
|
@CharlesHunt Linchi Shea has a great blog post on it (http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx). It is very small unless you are tracing Everything. |
|
US only...OTL...^^ |
|
@charlezhunt very small i've had server side trace running on every prod server for years. never had an issue with cpu% |
|
@ Steph I think that everyone here rates the guys pretty high even old timers have logged on for the beginner videos |
|
If you're looking for real-time query execution data and don't feel like going through the pain of writing the queries yourself, check out my Who is Active proc: http://bit.ly/630IUW |
| Jeremy Huppatz (@ozziemedes) |
@AdaTheDev All good - have a good night mate! Enjoy yer Mexigrub |
|
argh!!! lost internet connection just as Kevin was about to go in CXpacket stuff |
Adam Machanic's username is changed to Adam Machanic (@AdamMachanic).
|
Hello, Adam. It's nice to see you here ^^ |
|
Likewise Jungsun |
|
Thanks ^^ |
|
SQLServerPedia page for WaitTypes http://sqlserviapedia.com/wiki/Wait_Types Good resouce. |
|
@ozziemedes - cheers and you (well, morning!). Will be hanging on here til the last moment |
Bry%2DAnn Salahi's username is changed to Bry-Ann Salahi.
| Feodor Georgiev |
did you have a question? |
|
We're live again! If you don't see video, hit refresh. |
| Jeremy Huppatz (@ozziemedes) |
*ponders on the potential benefits and risks of eating grain-fed sirloin steak at this hour of night* [Pro: It's grain-fed sirloin steak!] [Con: High likelyhood of inducing trip to snoozeville] [Conclusion: Marinate steak in Coffee first!] |
| Eli Weinstock-Herman (@tarwn) |
Stephanie: Kevin's talks aren't listed under the Event at SpeakerRate or his name? |
| John Masseria (@HeatfanJohn) |
Is the audio out of sync with the video for anyone else? It's at least several seconds for me ... |
|
@Adam Machanic I have been using the sp_whoisactive in my environment and its of gr8 help to me..... Thank You for the Wonderful SP. |
|
ah, ok. sorry about that! |
|
We'll add talks for Kevin in the next couple of hours. |
|
I'll be talking about Adam's excellent SP_WhoIsActive this afternoon too. Great job on that! |
|
Venkata: that's great! I'm really glad it's working well for you. |
|
Brent, check's in the mail |
| Eli Weinstock-Herman (@tarwn) |
@Stephanie @Brent: Thanks |
|
@Adam hooah! |
|
@Brent is Foglight an overlap with Spotlight Enterprise? |
|
We use vFoglight for our VMware servers |
|
@Rudy we'll talk about that today, that's a great question. |
| John Masseria (@HeatfanJohn) |
How does foglight compare to Precise? |
|
@John you'll see in just a few minutes. |
|
See this stuff as well, It can help you understand CXPACKET deeply. http://www.sqlworkshops.com/, especially Webcast2 |
|
@Adam Mechanic I run it as a job every 2 min and store the data in a table. i can tell u atleast 3 incidents where it helped me to troubleshoot issues in a very easy manner. |
|
yay im back
|
|
ooh its Ari time |
|
This is like a bad kung fu movie... the words don't match the video, anyone have an idea for a fix or is it on the server end? |
| Jeremy Huppatz (@ozziemedes) |
*woot* *Cheers* Jorge is back!  |
| Bob McLaren |
I've got the same issue |
|
It's on the server end, unfortunately. |
|
Lag-Fu: The Lag continues |
|
@Jorge. guess the clucking will start up again |
|
Bawwwwk bawk bawk |
|
hey @adammachanic is here! |
|
brent, you should do some of the kung-fu moves while presenting!! |
|
Venkata: Would love to hear about them. Please send me an e-mail amachanic [at] gmail [dot] com |
|
@jungsun thanx |
|
Ari and I were joking about the kung-fu stuff. Watch me do that. |
|
@sqlchicken and so are you! |
|
i'd pay to see these two bust out some kung-fu moves |
|
Brent, try to get Ari to do the Hurricane Kick I asked for earlier |
|
Sure @Adam |
|
@BrentO don't laugh. I know you want to. |
|
@Jorge You watch, I will. I'm gonna get Ari when he leaves the Spotlight slide. |
|
Bonus points if you get Kevin to do Mortal Kombat bicycle kicks across the screen |
| Jeremy Huppatz (@ozziemedes) |
Gods... "What's right for my server...?" ... without detailed workload/performance analysis... Is the *CORRECT* answer ever going to be anything other than "It depends..."???? |
|
@Brent is there a way to collect performance data using native tools in real time so that I could correlate perfmon counters with profiler? |
|
did anyone else lose video just now? |
|
@Artem yes, Kevin demoed that earlier, but not exactly in real time. |
| Jack Harris |
video sound both lost |
| John Masseria (@HeatfanJohn) |
Whoops video just went dark ... |
|
Yup |
|
Lost sound, but it came back. |
|
yup, lost but back |
|
No video=no sound lag |
|
If you lost video/audio, wait 15 seconds. If you still don't have it, refresh your browser. |
| Jack Harris |
back ok |
|
@artem if you have SQL 2008 check out the Data Collection piece. Great stuff |
|
no video |
|
@Brent, I know he did, my question was whether it can be ongoing rather than now |
|
Yes, lost both sound and video, just getback |
|
just making sure I didn't need to go check my net bandwidth. |
| John Masseria (@HeatfanJohn) |
Refreshed IE and both came back ... |
|
Has the video conference resumed?? |
|
I am getting Shawcrossed here a lot too |
|
we're vendor-tied, if they don't support 2008, we not running it |
| Bob McLaren |
Dude! AV back in sync now. No kung fu moves? |
| John Masseria (@HeatfanJohn) |
Audio and video is now in sync! |
|
Too much marketing about Foglight |
|
Brent, Is there any articles that discusses tuning latch waits? |
|
@nitin this session is all about our tools. |
|
@nitin they need to pay the bills |
|
@Jay no, but check out our book - http://sqlservertroubleshooting.com - it's in there. |
|
Dude, this is 8 hours of free knowledge, don't complain about 15 minutes of product pushing! |
Stephen Dyckes's username is changed to Stephen Dyckes (@SDyckes).
| Bob McLaren |
|
|
@artem one thing you can do is convince your boss to buy once standard license for SQL 2008 for admin purposes. Benefits are great and will help you ALOT (i.e. Policy-Based Mgt, Central Mgt Server, etc.) |
|
@nitin what do you expect? they're in the software business, not the free training business |
| Gareth (@GarethSwan) |
@nitin Who do you think is paying for the WHOLE thing ? Don't complain about a small amount of GOOD marketing when you get a day of free awesome training. |
|
Besides, spotlight is the bee's knees. I love this software. |
|
I have to agree with @adammachanic |
|
how did Jorge get on the front page of sqlservertroubleshooting site? |
Jason Strate's username is changed to Jason Strate (@StrateSQL).
| Gareth (@GarethSwan) |
Exactly, Spotlight / Foglight is teh awesomeness !!!! |
|
I pitched FogLight to a winery in Breckenridge on vacation, because of the free training I knew about their products |
|
@Artem post pictures of yourself with my book and I'll put you on there. |
| Vince Amyotte |
ya, spotlight is very handy. im glad we have it at my workplace. |
| Colin Smith (@Smithco32) |
Just had a Spotlight Demo and will be installing soon. Just waiting for my server. Can not wait to get it running. I really need the help. |
|
Hi all, Q to the speaker: if I am changing underlying hardware how can I maintain history for both Spotlight and Performance Analyser and compare old hardware vs new |
|
we use spotlight. what's difference for foglight? |
| Colin Smith (@Smithco32) |
Unlucky with Android? I love my Android..... |
|
@Brent: IPhone app coming soon? |
|
Brent, it's okay I don't like attention |
|
I would say more unlucky with BB. |
|
@Leonid that's a great question, and we'll talk about that in the afternoon session. |
| Jeremy Huppatz (@ozziemedes) |
Migrate to web = "Replace client with"? Or "Also make collected data accessible via"? |
|
@Thomas even better - it's all web-based. Works on my iPhone already! |
|
Any time I run top 10 active processes on server report, Spotlight comes up on top with lots of CPU/IO/Mem usage. What's the Spotlight impact on SQL server in percentage? |
|
nice |
|
Foglight on iPhone. That must be cool |
| Eli Weinstock-Herman (@tarwn) |
nm, already answered |
|
@Sreekanth we're the only product that doesn't hide our own CPU/IO/Mem usage. You might ask why other products don't show their own queries. |
|
@Jeremy replace the client. |
|
@Jorge data collection, does it work with lower versions of SQL? |
|
@brent appreciate the transperancy |
| Jeremy Huppatz (@ozziemedes) |
Cool - ta @BrentO |
|
@nitin |
|
@Brent, your book is on my to buy list |
|
I wish I could afford Foglight |
|
@artem unfortunately no |
|
We are moving from ASE to SQL. The number of tools available is kind of overwhelming! |
|
Is there a Foglight for Oracle? |
|
@John yes, for almost all database & Windows app products. |
|
Jorge, that's my problem, that's why I rely on powershell |
|
@johngasper yes |
| Charles Hunt (@charlezhunt) |
Thanks Pat and Jack! |
|
Thanks... |
| Jeremy Huppatz (@ozziemedes) |
@Jolene: Sybase is pretty poorly supported when it comes to tools... Been there, bought and burnt that T-Shirt |
|
PAL and SQL Nexxus are a big reasons that are drawing me to this book |
|
@artem have you taken a look at the Codeplex project called SQLPSX? Powershell + SQL ftw |
|
<Agrees with Jeremy!! |
|
Jeremy, I agree! |
|
Appreciate that. Still want to know if there is any measured % impact. |
|
yes i have it downloaded, I didn't configure it yet |
|
@Sreekanth absolutely. We default to 3% max, but you can turn it even lower. |
| Jeremy Huppatz (@ozziemedes) |
That said - not entirely without options - Some of the Embarcadero tools have always supported Oracle, MSSQL, Sybase ASE, DB2, etc... but crazy expensive |
|
Thanks. |
|
any SQL Books that have good coverage of powershell for DBAs besides Ross MIstry's book? |
|
Problem is my boss loves Powerbuilder. Finding a good testing tool has also been a nightmare. Too much manual scripting required for a dba/programmer/tester, |
| Jeremy Huppatz (@ozziemedes) |
Jolene: You'll love the DB Edition tools in VSTS DB Edition then |
Venkata Karthik Yella's username is changed to Karthik Yella.
|
@artem MVP Deep Dives book has a good PowerShell chapter in it. Check @cmille19 and @sqlvariant 's blogs |
|
Need to buy the book, then need to make time to read book. Maybe I will understand what is in said book (haha in my dreams) |
|
I wonder how Quest attracts so much talent @mrdenny @brento @kekline etc |
| Colin Smith (@Smithco32) |
Enterprise but not only 08 |
|
werd! |
 Carm Vecchio |
Shameless... |
|
I will check it out Jeremy! Thanks! |
| Jeremy Huppatz (@ozziemedes) |
@BrentO - nice feature... DBA Tools 2.0 then? |
|
Absolutely shameless. |
|
@Jolene I second Jeremy, the VSTS DB Edition is actually a very nice environment. RedGate has an overall better set of tools but having everything in VSTS is really nice. |
|
What will it take for me to put you in this used Buick? |
|
The keys |
|
@kevindwhite since this is a Quest vconference, I'll mention that Toad has *more* stuff than VSTS DB Edition, yet costs less. |
|
@Brent: A SQLSAturday in Stockholm? *lol* |
|
ty kevin! |
|
@Thomas - doh! |
| Jeremy Huppatz (@ozziemedes) |
@Kevin: Bit of a sekrit (but also well know): MS licensed a lot of the gunk under the covers in VSTS DB Edition from RedGate and skinned it with their own UI |
|
How does Quest tool compare to Idera (DM)? |
|
@dbist - Sean McCown has some great free videos on PowerShell for the DBA here: http://midnightdba.itbookworm.com/Admin.aspx |
|
anything for Informix?....haha. Kidding! |
|
@Brent Oh yeah, Toad is pretty good too. |
| Jeremy Huppatz (@ozziemedes) |
@BrentO: Does Toad offer TFS integration? |
|
@Goran great question - we've got docs about that, but you'll see it here in a second. |
|
@Tim thanks I follow midnightdba |
| Colin Smith (@Smithco32) |
Lost is great...Love the names |
|
I was not able to find todays session http://speakerrate.com/kekline |
|
The server THE-FLAME is my SQL Server data dump of StackOverflow that you can query publicly: http://www.brentozar.com/archive/2010/02/querying-the-stackoverflow-data-dump/ |
|
@nitin it's not online yet, sorry. |
|
I smell DOS attack |
| Feodor Georgiev |
@Brent: what is the security context of the tool? How does it collect information from the SQL Server? |
|
@Artem that's why I mentioned it. We'll be able to show your queries live. |
|
@Feodor it does need to be SA since it does some system-level queries that need it. |
|
@Brent - cheers for that btw, had a play around with the SO data dump |
|
I need to get my Twitter bingo cards from PASS out and start following everyone to increase my contacts! |
|
I'm at work, my queries will be seen not only by you guys |
|
@Feodor it does queries remotely, and Foglight Performance Analysis does memory sampling (without logging into SQL Server). |
|
@Adrian cool! I have a lot of fun with that data dump. |
|
@Artem HAHAHA, nice. |
|
@Brent - I download the data dump, but gave up trying to extract it onto my (creaky) laptop. Hence saved me the pain |
|
@Brent If only Toad ran on OS X I would be set! |
|
Spotlight Enterprise has slick look |
| Jeremy Huppatz (@ozziemedes) |
@Ari/@Brent: Has Quest considered reworking any of their products as add-ins for the MS native tools using VS extensibility? Seems a logical approach that would decrease some of your barriers to entry..... |
|
We use Spotlight Enterprise and boy it's even better then what is being present |
|
Spotlight is a very cool, very robust app. Download a demo copy of it and try it out. |
|
@Jeremy unfortunately, MS does not condone that in the current version of SQL Server Management Studio, which aren't built with VS extensibility. |
|
Is anyone else having issues with the audio portion cutting in and out? |
|
@kevin you and me both, heh, but there's a pretty small market for SQL Server DBAs and developers who use Macs - relative to Windows. |
|
What is the appoximate cost for enterprise version of this Quest tool (Spotlight)? |
| Jeremy Huppatz (@ozziemedes) |
But they actively promote it for Visual Studio - a Toad shell inside VSTS would be brilliant! |
|
@Goran I'm not in sales, so I honestly don't know. |
|
Spotlight isn't terribly expensive |
|
They had an Oracle version at one point. Don't know if it's still around. |
| Colin Smith (@Smithco32) |
after my demo on spotlight, I really did not like that I get one alert and that is it. I forget things quickly and have a lot going on. easy to get distracted. I think that i can use powershell to have it continue to remind me until I respond. The issue may not be fixed but at least I told the system that I know about the error |
|
@Jeremy the market sales for VSTS doesn't justify us doing that, unfortunately. |
|
Ah Spotlight - very cool. We used a really, really early version and it worked, but had issues w/ the Smallint PKs. That's been fixed from what I understand, but we don't have it at this shop. |
| Jeremy Huppatz (@ozziemedes) |
Fair enough |
|
@Colin - you can set up recurring alarms. |
| Feodor Georgiev |
@Brent: out of curiosity - what is the price of the tool? |
|
@Peter yeah, that's definitely addressed. |
|
There have been times where the deadlock information or session information has not shown up in Spotlight. Is this normal? |
|
you can use Citrix on a Mac to access SQL |
|
to clarify - In the historical section |
|
and even iPad |
|
The onjly time deadlock information has not shown up in the live view is when it's shorter than the alert length or if it's parralelism |
|
@Jeff no, best to check with support on that. |
|
Sorry |
| Jeremy Huppatz (@ozziemedes) |
As someone who spans DBA/Dev/BI/Architect roles, tool proliferation is a PITA for me. But Add-ins are FTW. |
|
I was thinkign blocking, not deadlock |
| Colin Smith (@Smithco32) |
@brento the Recurring alarms are until the alram goes away correct? I might not want that. I just want it to annoy me until I respone. then I know that I know about it and will get to it when I see fit. |
|
I know - we were just on too early of a version at the time. v1, I think. It was really useful and a great tool to show to manager-types to boot. We wanted to leave it running with a small refresh rate, but couldn't then. |
|
What is the performance impact on monitored servers? |
|
Spotlight will spam the everloving crap out of you until you sleep the alarm. |
|
Is Spotlight lighter than Profiler + Perfmon |
|
@Jeremy I hear ya, but I don't know how else to tell you this. The current version of SSMS doesn't condone add-ins, and DBAs aren't adopting VSTS. End of story there. |
|
@Goran we default to 3%, but you can turn that down lower if you want. |
|
@nitin by FAR lighter. |
|
Walk by with some people, see the nice display all green and happy, they ooh and ahh over it, etc. |
|
@Colin exactly. |
|
@Colin you can snooze alarms in Spotlight v6. |
|
Mine's never green and happy. |
|
|
| Feodor Georgiev |
@Brent: out of curiosity - what is the price of the tool? |
|
Always red and angry |
|
@Feodor I'm not in sales, so I can't say for sure. Sorry about that. |
stefan bauer's username is changed to Stefan Bauer @stefbauer.
|
@Brian, u can try snoozing the alarms which are not important and prioritize |
|
it helped me a lot |
|
Yeah, that's what we do. |
| Colin Smith (@Smithco32) |
@Brent I did not know about Snooze. I will check it out when I finally get my test server. Wish the windows guys would get a move on. |
|
We are auditng all of our instances and alarms |
|
Long process though. |
|
@Brian Agreed, but not impossible though |
| Colin Smith (@Smithco32) |
@brento the command line syntax that Ari just mentioned is how I would make the alarming work the way I need it to |
|
Up to 947 attendees! More folks waking up. I hope we bring 1,000! |
|
@Colin absolutely, we have tons of programmability if you want to go that route. |
| Colin Smith (@Smithco32) |
@Brento I am shocked that more people did not get up early for this as I did. |
|
I got up an hour early for this, I do not do that very often! |
|
@Colin I'm not. People are lazy. I'm amazed *I* got up this early, hahaha. I had to be up at 3am to get ready. |
|
Gonna have to come back and watch the recording of this session - missed most of it due to meetings. I think I have another one right now. |
|
lost audio |
|
I don´t think 17;35 is early |
|
no video |
| Colin Smith (@Smithco32) |
I got up to work 2 hours early for this. |
|
no video too. |
|
Refresh your browser |
|
I cancelled my meetings and quit my job to watch this show |
|
got it back |
|
@Artem HAHAHA |
|
oh, vedio is back now. |
|
If you lost audio/video, hit refresh on your web browser.[ProcessingInstruction] |
| Vince Amyotte |
i just stayed at home to watch |
|
For us central time people it was 6:45. |
| Colin Smith (@Smithco32) |
@Brento why are you guys doing this in Tucson, I am in Phoenix and was shocked to hear you would be in Tucson for this. |
| Colin Smith (@Smithco32) |
Wow look at all that eye candy |
|
@Colin the video studio we use is located in Tucson. |
|
I am Central time and it was worth waking early for this thus far |
|
For pacific time it was 4:45 am but, well worth it! |
|
@colin the studio they're using is the vConference facililty which is located in Tuscon |
|
no sound? |
|
Cheers guys, signing off for the day |
|
did the tool provides reports for SLA |
|
gotta love swwug! |
|
Totally agree |
|
and I will admit, the Spotlight application has been very beneficial to us thus far |
Karin thomas's username is changed to Karin.
|
@Colin - because Tucson rocks! |
|
I agree Laura! |
|
Lost video/audio. am i the only one? |
|
you're going to cause twitter DOS today due to this activity |
|
@Brent you're using the SSWUG facility? |
|
TIMBO! |
| Colin Smith (@Smithco32) |
@Brento well the video is great so good choice!! |
|
@Adam yep! |
| Vince Amyotte |
@Shawn audio/video still working for me |
|
Keep refreshing you will get it back! |
|
shawn - try refresh mines working well |
|
@Colin - because Tucson rocks! Sorry about that @artem |
|
Everybody at work calls it my submarine simulation. |
|
thanks. got 'em back, but my refresh didn't work first time |
|
Brian, is Foglight going to replace Spotlight? |
|
what about security over the web? |
|
Hey Jorge! |
|
@Johnny it's up to you - you can host it internally if you want, or put access through a firewall. |
| Feodor Georgiev |
@Brent: how long before your presentation starts? |
|
@Christine that's an interesting question. Long term, probably yes. |
|
@Feodor about 1 hour 20 minutes. |
|
Does Foglight use SSRS or can it be incorporated into SSRS? |
|
@kevin no, Foglight is cross-platform. Works with Oracle, MySQL, etc. |
|
Brent - so Foglight basically has the same features as spotlight and I can use either of them? |
| Feodor Georgiev |
@Brent : i will take a nap and wake up for it |
|
@christine right now, there's some features only available in one of the two. |
|
Scranton. LOL. |
|
@Brent : so Foglight has less perf impact on the system than Spotlight? |
|
@christine yeah, we sample memory in Foglight rather than querying SQL Server directly. Nobody else does anything like it. We can measure even when no one can connect to SQL Server. |
|
Hello Brent, I am using FogLight and I am surprised to see 7 of 10 most expensive queries by IO coming from Quest app. Is this normal? What can be done? Thanks. |
|
@Brent, how does Foglight compared with SCOM? |
|
How much space would we need for 5 years of data? |
|
We use SCOM to monitor sql server |
8946's username is changed to Alex Prusakov.
|
@christine SCOM doesn't collect performance metrics like wait stats like we do. You can't use SCOM to analyze your SQL statements. |
|
@christine - how do you like SCOM? |
|
OK, i'm back, what'd i miss? |
| Jeremy Huppatz (@ozziemedes) |
@paschott I'm pretty sure that would be a "That depends" question |
|
Is foglight supports SQL server 2000 as well? |
|
@Peter great question! You can configure it to store as much or as little granularity as you want. The default is 2gb per instance if I remember right. |
|
Brent, I see that you are scheduled for this topic: 1PM – Performance Tuning for Beginners: Reading SQL Server’s Signs with Brent Ozar.... one of your downloads is SP_WHO replacement – DMV query to show current activity with wait statistics. I don't use sp_who. I use sp_who2 because it gives me more information (last batch, cpu time, disk i/o)....Can I get that "extended" information out of the DMVs? |
|
Can you use Foglight for Oracle and SQL servers? At the same time? |
|
@Brent, I think SCOM does collects perf counters if you install the sql server management pack |
|
@Keith yes. Let's hold our questions until that session actually starts. |
|
@Brent you can import your favorite performance counters into SCOM and start monitoring |
|
@christine yes, but not SQL statements. We're going to show you individual SQL statements. |
|
This goes WAY beyond perf counters. |
|
just wanted to get you thinking about it |
|
@Rudy yes. |
|
there's a baseline option in SCOM |
|
@Laura - we just started using SCOM. I haven't got to the reporting part of the scom. But the alerts generated by scom are useful. |
|
I am not helping Quest sales team, I will keep my mouth shut |
|
@Artem does it show individual SQL statements? |
|
What is SCOM? |
|
I don't know Brent, didn't get to that yet |
|
SCOM is Microsoft System Center Operations Manager, formerly known as MOM. |
|
Does anyone know if Foglight works with Oracle RAC? |
|
@Artem I *do* know, that's why I'm asking you. It doesn't. |
|
@christine - thanks no budget yet, but we are comparing tools and creating our wish list for when we do have funding |
|
I'll find a way to do it in SCOM |
|
@Artem good luck with that. |
| Colin Smith (@Smithco32) |
@Artem you could probably do it in Powershell right? |
|
King of the Lab |
|
ty |
|
Yes, Foglight supports Oracle RAC |
|
@Laura - if you implement scom on a enterprise level, it's going to lower the per server costs |
|
So you can nail the culprit if you have perf analysis tool |
|
many different ways to do this |
|
Hello Brent! Did you see my question? |
| Thomas Lane |
does it show encrypted text unencrypted |
|
@Christian got your whisper but I can't respond - too much onscreen as a presenter. |
|
Foglight works on RAC..OEM Grid is great too |
|
@Alex no, messages are flying too fast here, too many people trying to whisper. |
|
Folks - if you have a question for me, just ask it out loud without whispering - I can't respond to all the direct messages. |
|
@Klaus, thanks |
|
I am using FogLight and I am surprised to see 7 of 10 most expensive queries by IO coming from Quest app. Is this normal? What can be done? Thanks |
|
@Brent Ozar - it wasn't a question; it was a reminder Remember we want to let people know that today |
|
@Alex that can happen if Quest apps are the only things running on the server, but that should be the only time. If not, call support or log onto support.quest.com. |
|
@Christian - that's a surprise, didn't know that - can you email me verbage you want me to use, or just to say it in chat? |
|
Get the powder for Ari - he's sweating |
|
This app rocks. Our DBA team uses it and it is so easy to find the culprit of locks blocks. I have streamlined so many suspect stored procedures as a result of the data gathered from this app. |
|
Is that smoke coming up from Brents keyboard? |
|
Ari is sweating being that close to @brento's hawtness |
|
@Brent Ozar - just remind Ari; he knows about it |
|
I am not that naive - that is not the case. |
|
@Christian OK, will do! |
|
is that smoke coming out from Ari's ears |
|
@Alex okay, no worries, didn't mean to insult you. Definitely want to call support on that - this isn't something we can cover in a chat. |
 that you are not going to be on that call |
|
@Brent, if we have Spotlight, why would we get Foglight |
|
@Alex Prusakov - Hi, I am responsible for product management, so once you have activated your support bundle send me the case number, and I'll track it through. christian.hasker@quest.com |
|
Outstanding! |
|
C u all after my Canadian back bacon! |
| Jeremy Huppatz (@ozziemedes) |
Thanks Guys - May The Bacon Be With You... |
|
Thanks guys-- I look forward to the rest of the day. |
|
Thanks. I'll talk to my supervisor |
|
One hour... |
|
@Jeremy, and be with you |
|
Nice job guys - proud of you |
|
does Quest sell bacon |
|
Lunchtime! I'm starving, racing off to lunch. See you in an hour. |
|
@Brent can you please give the email address again? |
|
Great presentations so far! Thanks guys. |
| Jack Harris |
ari's email please |
|
I got to get going, 2:00am |
| Jeremy Huppatz (@ozziemedes) |
... Quick! Now that the Quest guys are AFK, let's talk about their competitor's products! |
|
Enjoy next sessions, Bye... |
| Jack Harris |
do they have any? |
|
Outstanding. It was worth getting up at 4 freakin 30 am. |
|
ariel.weil@quest.com |
| @SQLJackal |
enjoy your lunch Brent..... |
|
Idera, Red Gate to name a few |
| Jack Harris |
thanks |
|
I agree David - same here |
James Murphy%2DDean's username is changed to James Murphy-Dean.
|
Quest has a lot of these presentations, that's where the real value to me is, without a budget, there can't be any talk of purchasing software to manage other software |
James Murphy-Dean's username is changed to James Murphy-Dean @JMurphyd.
Jack Harris's username is changed to The Man.
|
ok, be back in an hour, don't be hatin |
|
@artem I understand. The database is the last thing anyone wants to spend money on but the first thing everyone wants something from |
| Jeremy Huppatz (@ozziemedes) |
Plus HP, Tivoli, CA, etc... but the big Enterprise service/performance measurement tools tend to be very expensive to tailor/implement. Quest/Idera/RedGate are great in the tighter database product niche. |
| Jeremy Huppatz (@ozziemedes) |
But I was only kidding about talking about competitors. [Even though HP pays my bills] |
|
you and I know this |
|
Are there any folk logged on that are studying for MSTC exams? |
|
SQL Heartbeat is free and great by the way |
|
@Kim you are finally deciding to go to bed? |
|
Redgate has a Spotlight-style application |
|
SQL Response |
 Jeff Blanchard |
I am studying for the exams |
|
I love SQL Response |
|
we haven't tried it out yet. |
|
I would shell out my own money on it |
|
Jeff, which one ? |
|
We have six licenses for it. |
| Jeff Blanchard |
70-431, 70-443 and 70-444 |
|
although it didn't use DMVs to monitor at the time I tested it, I was promised a new version using DMVs |
|
Has anyone compared SQL Response to Idera's SQL Diagnostic Mgr? What do you think? |
|
431 or 432 ? |
|
Biggest disappointment we've ever had was the SQL backup module for Netbackup |
|
We wasted a LOT of money on that crap |
|
How so? |
|
First thing I did when I came to current employer was to scrap the netbackup sql module. it's crap |
|
Just didn't work. |
|
The interface sucks. |
| Jeff Blanchard |
431 |
|
It reported backups as successful when there were failuires |
|
Has anyone compared Embarcadero's Perf Centre to Spot-/Foglight...? |
| Jeff Blanchard |
I work mainly on 2005 right now |
|
Embarcadero |
|
Do they still sell DBArtisan? |
|
sure do, dbArtisan WorkBench.. |
|
I love dbartisan. |
|
We purchased Emb's PC, but waiting on servers to Stage... |
|
Last tiem I tried to talk the business into buying it for me it was $2500 for one license. |
|
They said "NO." With capital letters. |
|
Hi Brian Keener - what use cases do you want to use DBArtisan for? |
|
Especially now, the price point causes a lot of contention in my shop. The whine..."Isn't there something open source you could use?" |
| Nick Weber |
I used Idera's SQLSafe for awhile, it worked but also was not thrilled with it. I did not like the proprietary back files lost a lot of agility with moving backs between servers if they were not licensed for SQLSafe dev/stg etc.. |
|
And 5 years ago, they thought open source was some kind of poison. |
| Jeff Blanchard |
70-431. I should be taking the test in a month or so |
Stephan Weber's username is changed to Stephan Weber (@aashkelon).
| Jeremy Huppatz (@ozziemedes) |
@Christian Hasker: Quick Q - are you guys likely to be doing any sessions like this one on the Toad Data Modeler tool? |
|
Red-Gate's SQL backup is pretty good. |
| Jeff Blanchard |
Nope - just bought books and teaching myself |
|
Hello all - I am responsible for Product Management and Marketing of our SQL Server products at Quest. There's a lot of talk of price points for software here, and I totally understand. If you try a Quest product and want to try to implement it at your company but your management is price-sensitive, we really want to work with you. As Brent says, that's how we got in touch with him, and swapped him from SQL Safe to LiteSpeed. My email is christian.hasker@quest.com and I can always help on that front. |
|
Hey all, if anyone out there is supposed to be on the PASS Chapter Leader meeting call, its going on now |
|
Jorge when do you find time to attend all these |
| Jeff Blanchard |
Thanks |
|
@Jeremy Huppatz - we don't currently have anything like this planned for Toad Data Modeler, but I can contact the product manager for you and set up a private session. Buck Woody at MS might do a couple of sessions on it later this year. |
|
Jorge what happens on that call? I've never even heard of it before |
|
@artem, ever seen Harry Potter? I have one of those time travel spinny thingies lol |
|
for the client that I support we use Quest Litespeed for SQL server, so far I am happy with the product |
| Jeremy Huppatz (@ozziemedes) |
Cool - thanks - DB Modelling tools are a personal pain point since Visio for Enterprise Architects has gone without update for so long. ERwin/PowerDesigner are also options, but expensive |
|
ok correction, this call is for Virtual Chapter Leaders |
|
that sounds virtually boring |
|
follow the leader, leader, leader |
|
. |
|
@adam its a meeting to coordinate the virtual chapters |
|
We use Power Designer. |
|
I have not had the time to research other products like it, but i trying to find the time to compare litespeed to Idera, but I do need to balance work with life some times  |
|
We're on lunch break now, aren't we? |
|
I am with Jeremy Huppatz. We use Visio for Enterprise Architects. Getting it to install requires the installation of Visual Studio 2005, then the Visio for Enterprise Architects, then I can install VSTS 2008 -- Soon to be Visual Studio 2010 |
|
yup |
| Gareth (@GarethSwan) |
HEY !! I don't see any Lady Gaga videos ??? |
| Jeremy Huppatz (@ozziemedes) |
Yes - but VEnA's last shipped version was Office 2003-generation. Hasn't been a 2007-generation release. |
| Jeremy Huppatz (@ozziemedes) |
If Toad's modelling tool provides support for scripting and entity templates I could be very interested in finding out more. |
| Jeremy Huppatz (@ozziemedes) |
Especially if the price point is right |
|
hi Stephanie, do you know Kerri from the Boston office? |
|
i know of Kerri yes |
|
Can you pass on my regards. I used to work for B&N in New York. Thanks |
|
@Jeremy Huppatz - please email Joe Faherty at Quest (Product Manager) and let him know that Christian said to get you an extended trial version for you of Toad Data Modeler - his email is joe.faherty@quest.com |
| Jeremy Huppatz (@ozziemedes) |
Cool - thanks Christian |
|
Getting off of Visio for Ent Arch would be awesome! |
|
Jeremy and others on the question of good tools that provides similar features as the big boys within the big price ... 1) Aqua Data Studio 8.0 - AquaFold Company is very good and does the majority of what dbartisan does for one-tenth the price. Sorry, dbartisan - you have a great product however price factor is key in these days and time. |
|
and it has a fairly good ER Modeler included for the price! |
stefan bauer's username is changed to Stefan Bauer (@stefbauer).
|
howto sign up for promo and prize drawings? |
|
Christian, is there any chance that we could get an extended trial of Toad Data Modeler too? |
|
It would be nice to step into 2010 with current tools |
Jolene Pitloun's username is changed to Jolene Pitloun (jotxtwi2).
|
yes, howto sign up for promo and prize drawings? |
|
sure will do! |
|
Yep - I will email Joe and let him know that there will be a lot of requests coming through for extended trials of Toad Data Modeler |
|
When you email him please let him know that you attended the SQL Server vTraining |
|
Wireless Reading Devices Raffle rules can be found here http://www.quest.com/landing/?ID=4877[ProcessingInstruction] |
|
thanks |
|
Ok - joe has been warned |
|
Hi Clay, how are you? |
|
Hello, @whois101 here. I wasn't able to join earlier, and a few seconds after I connected, I saw and heard something very briefly, but then the screen went black. My system test works. Are you guys on a break? |
|
I missed some sessions. Are there veido records downloadable for these sessions? Thanks! |
Roger Hullstrung's username is changed to Roger (@SQLCzar).
| The Man |
lunch break for 30 minutes |
| hkhkj hk |
All session will be available in ondemand for 30 days starting tomorrow |
|
@Hsa Kouts - yes, all the sessions will be available on-demand here for one month |
|
Thank you. |
|
Excellent! Thank you so much for the info! |
|
then we'll archive to sqlserverpedia for the general content and http://sqlserver.quest.com for the product content |
Rob Kalkman's username is changed to RobK (@whois101).
|
Hsao, once the sessions start again if you lose audio or picture, Keep refreshing, they will come back. |
|
Thank you all for sharing the information and quick response! |
Mary Ann Salas's username is changed to MerelyMortalDBA.
|
hi james. no you don't need to be in the chat for the prize |
|
winners will be chosen based on if they attend today. |
|
..and only if you live in the US |
| hkhkj hk |
Pre session slides are Being displayed now in the session room, refresh your screen if you are sitting at the "break for lunch" text |
|
hate to ask this again - but, I had to disconnect and was going to get on twitter - what was the twitter name? |
| hkhkj hk |
#questqa |
| RobK (@whois101) |
Cool, I have a picture now (refreshing multiple times helps indeed) |
| hkhkj hk |
thank you hkhkj hk |
| hkhkj hk |
Yeah, we took down the streme so out producer could eat some food |
| hkhkj hk |
our* |
|
We are raffling three Kindles today. As long as you attended today, you are entered into the drawing. |
|
Just came back after taking a break. I see the pre-session slides but no audio. Should I be hearing audio yet? |
| hkhkj hk |
No audio on these slides |
| hkhkj hk |
just slides |
|
You can ask questions on Twitter using the hash tag #QuestQA |
Artem Ervits's username is changed to Artem Ervits @dbist.
|
Do we have these today's sessions recorded for later view?? |
|
The sessions will be on demand here from March 4 – April 3rd. |
|
The slides will be available later at http://questkb.com/live - thanks![ProcessingInstruction] |
Laura Grob's username is changed to Laura Grob @smilingsqldba.
|
Coming back! Just ate, setting up now for my sessions starting in 15 minutes. |
|
Thanks Stephanie! |
stefan bauer's username is changed to Stefan Bauer (@stefbauer).
|
@Brent Cool nice that we get something in this world that is useful and best of all free :0 |
|
We broke 1,000 attendees! What a great turnout for today. |
|
@Antoni agreed! I love being able to do these. |
|
I'm new to twitter. can I send a test message to see if I'm twittering correctly? |
|
See Brent.... offering bacon gets a big audience! |
| Gareth (@GarethSwan) |
@Kimberly, sure go ahead ... |
|
Please take a moment to answer the questions in our survey athttps://vovici.com/wsb.dll/s/37ccg435e5 |
|
did that work? lol |
| Gareth (@GarethSwan) |
That Bill Gates photo come directly out of Brent's personal album !!! |
| Gareth (@GarethSwan) |
hehehe |
|
Thanks for streaming the sound and video! They are not blocked by our firewall. |
| Colin Smith (@Smithco32) |
I wonder if by Random they meant Creepy on the photo |
|
I don't hear elevator music, should I be concerned? |
|
The funny part is that I have a meeting at 3pm CST when the real world use cases are involved. |
|
@Artem - don't worry about not hearing music right now |
|
they'll be starting again in a few mins |
|
Hi Tom - good to see you here; hope all is well |
| Jorge Segarra (@sqlchicken) |
@artem refresh page |
|
If I missed the morning session, can I access the recorded version - is it recorded? If so, how can I access it? |
| Jorge Segarra (@sqlchicken) |
@dan yes, they're being recorded and will be available for a month |
| Jorge Segarra (@sqlchicken) |
@dan after that they'll be on http://sqlserverpedia.com as a video resource |
|
Thanks @sqlchicken - refreshed and now listening to some muzak |
|
Excellent! How do I access? |
| Jorge Segarra (@sqlchicken) |
Rob Kalkman's username is changed to Rob Kalkman (@whois101).
|
Thanks! |
| Jorge Segarra (@sqlchicken) |
youre welcome! |
|
i am currently using quest litespeed and it has included in the past a free extractor module to convert the backup from litespeed to native, I have not checked if the latest version has this |
Kelly Martinez's username is changed to Kelly (@greeleygeek).
|
or if the extractor is available free from quest still |
| @SQLJackal Jorge Segarra (@sqlchicken) |
thanks for the link |
| Jorge Segarra (@sqlchicken) @SQLJackal |
You're welcome Vic! |
| The Man |
The monitor in the background is not readable, might be better up front on the desk between the two speakers. The demo desktop is also not clearly readable, might be better with less intensity or darker colors (I can see it better when the items are selected (highlighted). |
| Antoni Franklin |
Anyone else getting video? |
| @christinaleo |
@BrentO needs the funny swami hat. . . |
|
they are back - if you can't see the video refresh your window |
|
I agree, hard to take notes when the monitor keeps moving away! |
|
| Jorge Segarra (@sqlchicken) |
if you want slidedecks check http://questkb.com/live |
| @SQLJackal |
i just had lunch, can't work out now |
| @SQLJackal |
hey i lost audio..... grr |
|
lost the video... |
| Antoni Franklin |
I am getting Ryan Shawcrossed here |
|
f5 worked |
Brent Ozar's username is changed to Ari Weil (@aweil).
|
. |
| Laura Krantz |
I also lost video |
|
No Video |
|
hi Christian |
| The Man |
put the poll link here please |
| Rob Kalkman (@whois101) |
"refreshing" (just like with the "recalculating" on the GPS) |
| Jorge Segarra (@sqlchicken) |
|
are we back yet? I got no video and no audio |
|
It's baaack..... |
|
@calvin try to refresh, we're back |
| The Man |
thanks |
|
So I'm assuming we're going to hear more about the Mgmt Data Warehouse? |
|
click on "Session Room" |
|
need more....? Write your own sp_who3 -- using the helptext of sp_who2 |
|
they need to send Kevin home, he looks sleepy |
|
I'm good now Thanks! |
| Jorge Segarra (@sqlchicken) |
I highly recommend using @adammachanic's spwho script |
| Jorge Segarra (@sqlchicken) |
sorry, his whoisactive script |
| Antoni Franklin |
@Artem it must be the lunch he had... |
| Jorge Segarra (@sqlchicken) |
| @SQLJackal |
i agree with Jorge, Adam's whoisactive script is awesome!!! |
|
where is the poll I am either missing it or blind |
| Jeremy Huppatz (@ozziemedes) |
Tonya: The Toad Data Modeler is of very specific interest to me. |
|
Have been using @adammachanic's tool |
| Jorge Segarra (@sqlchicken) |
Brent's poll (get your mind out of the gutter) http://brentozar.com/go/poll1 |
| Jeremy Huppatz (@ozziemedes) |
Whoa... copy-paste fail |
|
where can i get that batman sticker? |
|
@thomas they are out of print |
|
Forget who asked, but yes, the extractor is still available in LiteSpeed, and is still a free utility |
| Jeremy Huppatz (@ozziemedes) |
What Jorge posted. |
|
@SQLRockStar shamels self promotion |
|
I want the SQL sticker |
|
should've been shameless |
|
where can I get that macbook |
| Jorge Segarra (@sqlchicken) |
@artem, pry it out of Brent's cold, dead hands |
|
Brent's used MAC shop |
James Murphy%2DDean's username is changed to James Murphy-Dean.
Nitin Salgar's username is changed to @nitinsalgar.
|
how to remove the line no' |
| @SQLJackal |
suresh, don't highlight the script, just right click and copy to clipboard |
|
looking at Kevin is making me sleepy |
| @christinaleo |
@James Murphy - You can get the SQL Sticker from Paul Neilsen http://www.sqlserverbible.com/index.htm - look just under the SQLServerBible Newsletter |
|
broker_receive_waitfor |
|
WAITFOR |
|
BROKER_RECEIVE_WAITFOR - wait_stats |
|
sos_scheduler_Yield |
 Karthik Yella |
broker_receive_waitfor |
|
Ooh Troy, CPU pressure |
|
was it sp_whoisactive? |
|
it was sp_who2 |
|
@Carsten, it's the script Brent was just talking about |
|
if you look at the twitter feed for #QuestQA, you'll find the links |
| Jorge Segarra (@sqlchicken) |
Michelle Ufford's Index defrag script: http://bit.ly/cEdovU |
|
ok thanks |
|
BROKER_RECEIVE_WAITFOR is an indication that Service Broker is running, but it's effectively an "idle" event |
| Jorge Segarra (@sqlchicken) |
|
ari...spotlight says 12% cpu usage? |
|
wait_type wait_time PAGEIOLATCH_SH 15 |
|
whats the diference between sp_who2 and select * from sysprocess ??? |
|
@Troy, yes, but it could be that you don't have enough plan reuse b/c of loads of T-SQL, or it could be that your working set is small. Brent should cover some of this |
|
IO_COMPLETION and PAGEIOLATCH_SH |
|
OK - so I normally use sp_who2 - that doesn't mean that I'm proud of that. Used sp_who3 for a while back in SQL 2000 days, but loving the tips here. |
| Feodor Georgiev |
SOS_SCHEDULER_YIELD |
|
@Narendra, sp_who2 formats the information and limits what you receive, select * from sysprocesses (or sys.dm_exec_requests) gives you an unformatted dump of the information |
|
Does it look to ayone else like that ac logo on Brent's notebook is photoshopped in? |
|
ASYNC_NETWORK_IO |
|
top 10: 1 SOS_SCHEDULER_YIELD 2 WRITELOG 3 SOS_SCHEDULER_YIELD 4 SOS_SCHEDULER_YIELD 5 PAGEIOLATCH_SH 6 PAGEIOLATCH_SH 7 PAGEIOLATCH_SH 8 PAGEIOLATCH_SH 9 SOS_SCHEDULER_YIELD 10 SOS_SCHEDULER_YIELD |
|
so using sys process table I can see activity on particular databse which is not possible using sp_who.. Am i right?? |
|
Msg 102, Level 15, State 1, Line 28 Incorrect syntax near '.'. |
|
where on twitter? |
|
hhmmm |
| Jorge Segarra (@sqlchicken) |
SQLCAT whitepapers on WAIT types: http://sqlcat.com/whitepapers/archive/2007/11/19/sql-server-2005-waits-and-queues.aspx |
|
where on twitter? |
| Jorge Segarra (@sqlchicken) |
@jason, search #questQA for tweets on this event |
|
BROKER_RECEIVE_WAITFOR |
| Karthik Yella |
@Narendra...If u want to search by a database...you can filter using sysprocesses |
| Jorge Segarra (@sqlchicken) |
also here's the page he just put up http://sqlserverpedia.com/wiki/Wait_Types |
Nick Weber's username is changed to Nick Weber (@Toshana).
| Jorge Segarra (@sqlchicken) |
http://brentozar.com/go/poll2 Second poll question |
|
thanks karthik yella from NJIT |
| @SQLJackal |
poll time.............weeeeheeeeee |
| Karthik Yella |
Yes |
|
We use Precise InDepth |
|
but I hate it |
|
@Narendra, yes, that is one difference. |
| Colin Smith (@Smithco32) |
run it again is what i do |
| Jorge Segarra (@sqlchicken) |
execution plans FTW! |
| @SQLJackal |
http://www.brentozar.com/go/poll2 does not work |
|
We also run the query again |
|
does Kevin Kline remind anyone else of "Al" from Tool Time? |
|
OK, here's a poll... who's sexier? Brent or Kevin? I vote Kevin! |
| The Man |
Can the video camera intensity be turned down some? |
|
DMVs have a last run date/time for each query within a batch.... |
| @SQLJackal |
good one banjamin..... haha 'Tool Time' |
| Jorge Segarra (@sqlchicken) |
To understand Execution Plans download Grant Fritchey's (@gfritchey) free e-book: http://www.sqlservercentral.com/articles/books/65831/ |
|
Kevin looks like the USA bobsled team gold medal champion |
|
@Benjamin Kevin's not wearing the Al Borland shirt. |
|
#questQA, couldn't find that on twitter |
|
@Jack LOL good call |
|
@artem funny |
| Jorge Segarra (@sqlchicken) |
@jason http://twitter.com/#search?q=%23questQA |
|
#QuestQA also not found on Twitter |
| Jorge Segarra (@sqlchicken) |
|
Kevin doesn't llok like he's holding bakc the laughter like Brent did earlier. |
| The Man |
Can the rear monitor intensity be turn down? |
|
Where the bacon? |
|
you want everyone to wake up, give out some shwag |
|
eye bleach |
|
Got disconnected from the session and had to reconnect. |
|
shawg yes |
| Jorge Segarra (@sqlchicken) |
buahaha got em! |
| Gareth (@GarethSwan) |
Go, Chickenman !!! |
|
good one! |
| Jorge Segarra (@sqlchicken) |
notice I changed my av to a penguin? closest thing I could find to a chicken on here |
| Rob Kalkman (@whois101) |
Funny, sound and picture are out of sync.... refreshing... (hope to be back soon) |
|
I thought you were running Linux |
| Colin Smith (@Smithco32) |
@sqlchicken, Thanks for the link to the ebook. |
|
Anyone running linux and managing SQL server? |
|
not at the same time Rudy |
|
do these only run from MASTER? I get a syntax error when running it from user databases |
| Jorge Segarra (@sqlchicken) |
@colin, you're welcome! |
| Bob McLaren |
So where do I go to copy/paste this cool DMV query you've got here? Do you have these posted at questkb.com? |
|
That is a great book. I am reading it right now. |
| @christinaleo |
Michelle Ufford, http://sqlfool.com has a great sproc that looks for queries with missing indexes and logs those to a maintenance table that you can use for later analysis |
| Carm Vecchio |
Knee Pads.... |
| Brian Keener |
If you've disabled your default trace some of those management studio reports won't work. |
| Brian Keener |
Schema change history is one of those. |
|
sys.dm_db_missing_index_details is good for missing indexes |
| Gareth (@GarethSwan) |
@Rudy I have Linux on my desktop & RDP into my SQL dev box that has all the client tools installed. |
| Gareth (@GarethSwan) |
@Rudy I do the same from my MacBook Pro. |
|
anyone else seeing syntax error with these? |
| Antoni Franklin |
You know Gareth I think I should do that as well. |
|
SELECT t1.object_id, t2.user_seeks, t2.user_scans, t1.equality_columns, t1.inequality_columns FROM sys.dm_db_missing_index_details AS t1, sys.dm_db_missing_index_group_stats AS t2, sys.dm_db_missing_index_groups AS t3 WHERE database_id = DB_ID() AND object_id = OBJECT_ID('t_sample') AND t1.index_handle = t3.index_handle AND t2.group_handle = t3.index_group_handle; |
| Jorge Segarra (@sqlchicken) |
Michelle Ufford (@sqlfool)'s index defrag script is here: http://sqlserverpedia.com/blog/sql-server-bloggers/automated-index-defrag-script/ |
|
@Gareth, Thanks |
|
what was the book he mention? |
|
running SQL under hypervisor = running SQL under Linux |
|
I love when voice and video is out of sync |
| Jorge Segarra (@sqlchicken) |
@miguel Grant Fritchey's SQL Server Query Performance Tuning Distilled: http://www.amazon.com/Server-Performance-Tuning-Distilled-Second/dp/1590594215 |
| Brian Keener |
I've had huge arguments with our VMware admin |
| Brian Keener |
About the balloon driver |
| Karin |
is there something similar to this "balloon driver" on VMWare as well? |
|
thank you |
| Jorge Segarra (@sqlchicken) |
@miguel also download Grant's free ebook on execution plans: http://www.sqlservercentral.com/articles/books/65831/ |
Artem Ervits's username is changed to Artem Ervits @dbist.
| Jeremy Huppatz (@ozziemedes) |
You an also clear theproc cache uing DBCC FREEPROCCACHE |
|
Will Brent be a SQL Jedi Master? |
| Jason Boyd |
VMWare does have a baloon driver, memctrl I think off the top of my head |
|
so given the choice between physical and VM for a database is the choice usually physical? |
Jason Wisener's username is changed to One Penny.
| Karin |
thanks! |
| Ari Weil (@aweil) |
@greeleygeek, that's not really a simple answer |
| Brian Keener |
USA's largest gift card processing company runs over 300 instances, 100% virtualized. |
|
that is a great question Kelly |
|
@jorge Cool thanks |
| Gareth (@GarethSwan) |
@greeleygeek It depends. |
| Jorge Segarra (@sqlchicken) |
physical is preferred but "it depends". If your SQL database is only going to be 1GB with 5 users you can virtualize that no problem. A high-volume OLTP database with thousands of users I'd go physical |
| Colin Smith (@Smithco32) |
Lost the feed |
|
Wait - what does he drive? The world wants to know. |
| Jorge Segarra (@sqlchicken) |
Currently over 50% of my prod databases are virtualized (VMware) |
|
honda fit |
|
LOST VIDEO AND VIDEO |
| Ari Weil (@aweil) |
Yes it's true, a Honda Fit |
|
If you lost audio/video, hit refresh on your web browser.[ProcessingInstruction] |
|
no video |
| Brian Keener |
There's nothing inherently wrong with virtualization. You can get excellent performance from virtualized servers. |
| Eli Weinstock-Herman (@tarwn) |
I like how the audio cut out to save brent from saying he had to drive a Fit.. |
| Gareth (@GarethSwan) |
You have to size the SQL server & then check out whether you'd prefer it to be physical or VM. |
| The Man |
back |
|
At least it is not a Toyota then you shouldn't drive it at all |
|
how many users/applications use those Jorge? |
| @SQLJackal |
@brento is being modest, he drives a Porche 911 |
|
That is without taking it in to get the break pedal fixed and the steering column looked at |
|
virtual=limited number of cores also-- 8 max I think in 4.0 |
| Antoni Franklin |
Yeah I am running Jorge on 50% virtualized, but I could go as high as 75%. |
|
@Kevin, can we move on from VMWare? |
|
That is a baby Honda minivan |
|
@ari right now I have the choice to stay physical or go virtual. Virtual has nice admin possibilities, but I worry about I/O as we scale out if we switch. |
| Jorge Segarra (@sqlchicken) |
Talk to @sqlsarg he virtualized a good portion of OSI Restaurant Partners (aka Outback Steakhouse) 's prod databases w/o issue |
|
I have server with 20 GB and the buffer cache is high(close to 18GB). What I can do for the memory pressure? |
| Colin Smith (@Smithco32) |
I have some sql instances that have a decent volume and they do OK. But I really love VM just for what @brento is saying now. P2V old hardware. |
| Gareth (@GarethSwan) |
@SQLKackal He drives his Fit like a Porchse. |
| Brian Keener |
You can't just take the knowledge you've gained over the past 10 years, build a virtualized DB server,and expect good results. There's an entire new set of metrics and configurations you need to consider. |
|
I am running all of our sharepoint on a VMware |
| Ari Weil (@aweil) |
@greeleygeek, I'll keep the IO topic top of mind |
| Jorge Segarra (@sqlchicken) |
absolutely agree with @brian |
|
Mr. Mechanic do they have a few suggestions as in websites for virt. they could email us? |
| Jorge Segarra (@sqlchicken) |
If you're interested in virtualizing SQL Servers check out the PASS Virtualization Virtual Chapter http://virtualization.sqlpass.org |
|
@ari cool. thanks! ok...onward |
| Ari Weil (@aweil) |
hypercritical.com is a good blog |
|
Can these canned reports be scripted out? |
|
@John Brent did a podcast on SQL virtualization |
| Brian Keener |
You can open them in SSRS |
|
I'm thinking we've turned vconference from a porche into a fit |
|
you can see the canned reports SQL by running profiler! |
| Ari Weil (@aweil) |
You can also open them in Business Intelligence Management Studio for editing |
| Antoni Franklin |
@greeleygeek I will say this VMWare has a tool which monitors a server and can basically tell you whether it has too much I/O for VMWare |
|
there's a bug in schema change report if there are thousands of schema changes. the report does not have a where clause and hence causes the memory overflow |
|
Cool thx |
|
Change Control; Change Control; Change Control |
| Brian Keener |
I'm a big fan of change control. The DBA I replaced wasn't. That's the problem. |
|
Chapter 14 rocks!! |
|
@antoni cool. definitely needs more testing/investigation as an option |
| Ari Weil (@aweil) |
@Antoni & @greeleygeek, so does Quest. I'll try to speak about it during the last session |
| Karthik Yella |
Is Brent talking about performance dashboard reports? |
| Ari Weil (@aweil) |
yes |
|
I don’t see the “non default config” report on my list of reports. I’m using Microsoft SQL Server Management Studio 10.0.2531.0 [ProcessingInstruction] |
|
Oh noo, are they gonna sing? LOL |
| Vince Amyotte |
are the reports functionality only in the 2008 studio? |
| Brian Keener |
You need SQL 2005 SP2 installed to have the reports for 2005 SSMS |
|
hmmm I don't see the non default report |
|
no 2005 as well |
|
Nasty I/O on the pole... is this conference x-rated? |
| Bob McLaren |
@Vince - I've got these reports in SSMS 2005 |
|
no it's in SQL 2005 SP2 as well. |
|
yeah, change control is sooo important. I love database triggers - write those to a change log, nice! |
|
Is there a SQL 2008 Performance Reports? |
|
in 2008 they are already included |
|
the sql dashboard is awesome for sql 2005, but it doesn't exist for 2008 |
| Ari Weil (@aweil) |
@Sandy, hopefully Brent touches on the dangers of triggers...can be a risky change control process |
|
I see alot of reports, but not server dashboard |
| Karthik Yella |
performance dashboard reports are custom reports....right? |
|
Awesome, got it! thanks |
|
@summer - you have to install it, but it is free to download/install |
| @SQLJackal |
here's the link to the reports mentioned by @brento http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en |
| Ari Weil (@aweil) |
@Kathik, @Summer, they're built into SQL Server 2008 management studio |
| Antoni Franklin |
Never knew quest did , but we have VMWare onsite during a conversion and they backed off several database servers on the IO alone and we are running nahelems. I figure if their inhouse experts backed up that said enough. |
|
most excellent, Wayne! |
|
True Ari, use it for very important things like Create Database and Drop Login |
| Bill busking |
what is bad about setting max-memory |
|
Is the video stream available to view later? I have to leave soon |
|
The sessions will be on demand here from March 4 – April 3rd. |
| Karthik Yella |
Oh...I have not used Sql Server 2008...so pardon me |
|
fanboi! |
|
Any other special reports that your aware of? |
|
Great' Thanks for all this. |
|
Get excited Kevin |
| Ari Weil (@aweil) |
@Bill, setting max server memory INCORRECTLY can be dangerous |
| Jorge Segarra (@sqlchicken) |
@bill you want to set max memory bc if your SQL Server had a query that "runs away", by default SQL Server sucks up all the memory it can. If you dont specify a max mem itll take all the memory on the system causing the entire server to be crushed/non-usable |
|
when will your kindle become hopefully my kindle? |
|
Everybody get's a Kindle right? |
|
max memory can hurt you if you don't know about it |
| Jorge Segarra (@sqlchicken) |
Kevin's book SQL in a Nutshell: http://www.amazon.com/SQL-Nutshell-OReilly-Kevin-Kline/dp/0596518846 |
|
max memory - 1G (so 1G goes to OS)? |
|
Hey Partick, Kerri says hi back!! |
| Brian Keener |
Setting max memory is extremely important with SQL 2005 64-bit, as I recall |
| Brian Keener |
And lock pages in memory. |
| Ari Weil (@aweil) |
@MerelyMortal, that's a very general best practice |
| Nick Weber (@Toshana) |
linked servers neeed memory, and additional services |
|
By default on a 32-bit system, 2 GB goes to OS. You can then easily change that using the /3GB switch |
|
good to set it if you want more than 2GB |
|
@Ari - I read conflicting posts regarding turning on /3gb if you want to turn on AWE. What's your recommendation? |
|
What about max memory setting on a server with multiple instances?? |
|
Thanks @Ari |
|
only morrons installs applications on SQL Servers |
|
Whats amazing is that most of those settings are inherited from sql 2000. |
| Brian Keener |
Not setting lock pages in memory for 64-bit sql 2005 will end in tears. |
| Jorge Segarra (@sqlchicken) |
Just understand what is on your system and exactly what is goign on there before you start playing around w/ those kinds of settings |
|
max memory good on multiple instances - there is no memory sharing from what I recall |
|
I set lock pages in RAM for 2K5 and 2K8 |
|
Absolutely true - SQL2005 64 bit, you need to set max memory or you can end up with serious problems. Found that out the hard way |
|
lol, how does sql go? |
| Karthik Yella |
Should we enable AWE on a 64 bit Sql 2005 ? |
| Eli Weinstock-Herman (@tarwn) |
next they'll be telling us not to use the 'let file grow without limits' feature |
| Jorge Segarra (@sqlchicken) |
@paul FYI, do NOT set lock pages on virtual servers otherwise you'll have issues when you do stuff like vMotion |
|
So he is suggesting that you dont lock min and max the same at the highest level you need minus the OS? |
|
karthik - no . no awe for 64 bit |
|
what is the best practice relative to total memory |
|
So how does max memory work with multiple instance installed?? |
| Carm Vecchio |
CU7 |
|
Just don't install SSMS or VS on your servers |
|
our Tivoli backup client always steals from SQL..... until we set Lock Pages in Ram..... made the Tivoli admin sad! |
|
Because as a normal I always do as a normal. |
| Nick Weber (@Toshana) |
NO |
|
@Brent - I read conflicting posts regarding turning on /3gb if you want to turn on AWE. What's your recommendation |
| Ari Weil (@aweil) |
@nitnsalgar - totalmemory should be higher than or exceedingly close to target server memory |
|
Thanks Stephanie. |
| Jorge Segarra (@sqlchicken) |
Cumulative update SP3+CU4 = lock pages in memory on Standard: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/06/20/sql-server-2005-sp3-cumulative-update-4-is-available.aspx |
|
SQL 2008 Internals goes into details on AWE |
James Murphy-Dean's username is changed to @JMurphyd.
| @SQLJackal |
@brentO i have AWE enabled on my 64bit box, works great! |
|
@Ari, How do you set max memory on each instance installed onto 1 physical server? |
| Jorge Segarra (@sqlchicken) |
SQL 2008 Internals book (GREAT resource): http://www.amazon.com/Microsoft-SQL-Server-2008-Internals/dp/0735626243 |
|
There is a dynamic cache bug in x64 server 2008 that will steal memory from SQL even beyond the minimum-- see KB971442 |
| Ari Weil (@aweil) |
@Rudy, you need to gather data to see how much memory each instance requires to operate well, and then take into account how much added memory the OS and other processes require. There's a formula in the SQL Internals 2008 book that covers how to start the sizing work. |
| Brian Keener |
AWE does not need to be enabled if you have more than 12gb of memory |
| Jorge Segarra (@sqlchicken) |
Brent's shared bookmarks: http://delicious.com/brento |
| Brian Keener |
Everything online says 16gb |
|
@brent - the post is for sql2000, what's recommendation for 2005 |
|
Thx Ari |
|
do you have any comments on using Shared data disk and clustering? |
| Brian Keener |
But 12gb has had significant issues on many of our servers with AWE |
| Ari Weil (@aweil) |
@Maurice, what are you looking for? |
|
Damnit |
|
on a 16G server, running SQL2008, is 12G a good max mem size + [AWE]? at times we see all memory used, and peformance is in the toilet. |
|
This is great stuff! |
|
benefits like what? |
|
64bit clustering using SQL 2k8 standard with 2 node and database being a shared data disk? |
| Brian Keener |
32-bit, Wayne? |
| Ari Weil (@aweil) |
@Maurice, shared data disk as a standalone...if you can afford it. Otherwise, if you have a fast enough array or a SAN that's performing well, you can combine the shared disk resource with the data drive (typically) |
|
@Brent or @Ari - system cache issues on 64 bit system. How can I control the excessive growth of system cache on 64 bit? this is a known issue. |
| Brian Keener |
Wait |
|
Are there any good resources for performance and troubleshoot the SQL on VM? |
| Brian Keener |
I said AWE. I mean PAE. |
| Brian Keener |
LOL |
|
sp_who2 replacement (http://sqlserverpedia.com/wiki/Misc_DMV_queries) I get a syntax error when running it in a DB other than master. Nothing stands out at me. Do these have to be run from master? |
|
speaking of clustering-- when can we expect to see real active-active clustering in SQL? |
| Ari Weil (@aweil) |
@Hsao, if you go to quest.com/backstage you'll find past webcasts on the topic, and Brent has quite a bit on his blog www.brentozar.com |
|
Any hints on where to find out more about the Management Data Warehouse? |
|
@paul - never - onlt Open VMS can do that |
|
database mirroring doesn't (or didn't) work well for more than 10 databases (on SQL Server 2005) |
|
that was a huge limitation that we ran into |
|
@christine you can use this service http://www.microsoft.com/downloads/details.aspx?FamilyID=e24ade0a-5efe-43c8-b9c3-5d0ecb2f39af&displaylang=en |
|
kathi kellenberger has written a 5page into to clustering on sql server standard magazine |
|
Nice to hear Brent mention the Screen of Death. My coworkers never seem to know what I am talking about when I mention it. |
|
otherwise, it worked really well |
| Jorge Segarra (@sqlchicken) |
@paul try using Adam Machanic's whoisactive script instead: http://sqlblog.com/blogs/adam_machanic/archive/2009/12/03/who-is-active-v9-57-fast-comprehensive-dmv-collection.aspx |
|
@Paul why bother with that when you can use my Who is Active script http://bit.ly/630IUW |
|
great answr |
|
Are you guys going into Insite? |
|
great answer, thanks |
|
anyone here using MDW? |
|
@Jolene: how is that possible we have it happen on a regular basis |
|
anyone here using MDW? |
| Brian Keener |
Brian, AWE is necessary on any amount of RAM over 4gb on 32-bit systems. Sorry... |
|
Data Collector can be a space hog |
|
Thanks, Brent. I was curious because there's not a lot out there about it that I can see. |
| Brian Keener |
yeah, I meant PAE |
| Brian Keener |
Oh, PAE, is a different story |
|
@Kevin did you see my tweet |
|
@Allen - thanks. checked that before. What's the recommended system cache setting do you know? |
|
for more MDW see Brent's book Chapter 15 |
| Brian Keener |
AWE, PAE, whatever. ;D |
|
log shipping is the best option for lots of databases? |
|
@keith wow. didn't know that. the problem we have is the manual failover and the DNS changes to make the apps run again. |
| Jorge Segarra (@sqlchicken) |
@chris that's definitely an "it depends" answer |
Allen Kinsel's username is changed to Allen Kinsel (@sqlinsaneo).
|
I always wonder the same thing! |
|
Kelly, with the appropriate connection string the application should handle a mirroring failover without any changes required |
|
We turned it on and it took up 20GB in less than a week. Apparently you can adjust the collection and correct that but I am still not sold |
| Jorge Segarra (@sqlchicken) |
If you have lots of databases on one server and they ALL need failover capability you'd probably be best going to a cluster setup (if funds allow) |
LEON BEKKER's username is changed to Leon.
|
According to this Denny Cherry article he recommends not using SQL Lock pages in Memory when running under VMWare http://itknowledgeexchange.techtarget.com/sql-server/vmware-and-sql-and-lock-pages-in-memory/ |
|
anyone have transactional replication on their primary db to create a reporting db and then log shipping for dr... if so any issues? db is supposed to be around 1tb |
|
What is the biggest reason why NOT virtualize a production SQL Server? What it if it is in a one-host/one SQL Server instance? |
|
@christine we dont use it because of the other impacts, but MS recomended 512mb max |
|
@Laura: we used mirroring and then a custom snapshot procedure to do the same thing |
|
Thanks, guys. That does give me something to go on regarding MDW. |
Jeremy Brown's username is changed to Jeremy Brown (@jbrown414).
|
@Jorge, good point. We use XOSoft from CA for excellent HA, even better than MS cluster |
| Jorge Segarra (@sqlchicken) |
@merelymortal again, it depends. Whats the usage like on that one db? can your virtualization setup provide the necessary IOs/throughput for your app? Lots to consider |
|
@Allen - thanks. in our 64 bit environment, the system cache can go up to over 10gbs, consuming all the avail. memory on a server |
| The Man |
Adjust the rear monitor intensity and camera intensity so that we can see the monitor and demo desktop clearly. |
|
@merelymortal licensing, its by processor so you get 2 quad cores for 2 processor licenses in vm you only get 2 processor licenses (unless you go ent and license the hdware) |
|
@Allen - what other impacts by using it? |
|
the Physical currently is on a 16GB/ quad-core... going to a Host with 64GB/ dual 8-core... |
|
@Christine-- do you have the patch loaded for dynamic cache? see KB971442 |
|
I am actually interesting in finding out some info on quest insite and c2 log collection if you guys have the chance. |
| Antoni Franklin |
@merelymortal how much IO are you looking at? I mean VMWare themselves will backup off of IO intensive (database) boxes |
|
@christine, dont do file copies using explorer and the probelm will disappear |
| Jorge Segarra (@sqlchicken) |
@merelymortal again, that's a beastly box its coming off of. Is SQL Server really doing anything on there? |
|
@Philip - can you please send me the link for that KB. I can't find the kb |
|
if the licensing piece is covered, would you recommend that switch from Physical to Virtual? On the IO side, all the DB will be on the SAN (raw mapping, not using vmdk)... |
| Antoni Franklin |
@MerelyMortal I must be missing something are you going to virtualize a physical onto a 1 host standalone box? |
|
you have to call to request the patch-- it isn't written up yet... |
|
@Allen - the system cache growth was triggered by running sqlsafe backups and other tools. It's particularly related to 64 bit sql server standard edition |
|
@sqlchicken... yes, the SQL Server is actually doing a lot..CPU and IO intensive... |
|
exactly what I've seen with large file I/O |
|
it would depend, only after testing would we move, of course thats our process for any phys-virt |
| Antoni Franklin |
@MerelyMortal I understand about the SAN, but they still backed up off of Fiberchannel connected SAN and a SAN we have connected through a Flex 10 to iSCSI. |
| Jorge Segarra (@sqlchicken) |
@merelymortal what you could try doing is building a VM and installing SQL on it, restore a copy of your database to it and test it out. Look at your metrics and see if it fits your needs, otherwise scrap the move |
| Jorge Segarra (@sqlchicken) |
that's the beauty of VM. build/test/destroy or rollback change with relative ease |
|
@sqlchicken I think that's exactly what I'm going to be looking at after chatting with you guys. |
|
actually took one server down from 32GB reserved minimum down to 70MB before I realized it was happening, killed a file copy and it began recovering. |
|
will this chat be available for email or saving to disk - because I don't see a way to save the chat. This chat and conference is so good with great info - I don't want to lose it!! |
|
Thanks @sqlchicken. I will do that. When I go look for metrics, what do you recommend to look at? The only thing is that with the test VM, the workload is not the same as it is being used in Production... |
|
Maurice - right click the window, use "Save chat log" |
| @christinaleo |
right click on the chat area, and there is an option to save |
|
@maurice - if you right mouse click in teh chat you can save it |
|
cool! it's alway the simplest thing that kills me! |
| Jorge Segarra (@sqlchicken) |
@Maurice Ray: right click and choose "save the chat log" |
|
The final word on AWE: http://blogs.msdn.com/slavao/archive/2005/11/15/493019.aspx -- "64 bit platform ... you don't have to turn on AWE" |
|
I just want to say to all of the seminar teachers - THANK YOU - THANK YOU - THANK YOU! |
| Ari Weil (@aweil) |
OOH, @slavao's blog is a must read |
|
And why wouldnt thie final word come from Slava.... perfect sense
|
|
Yes thank you guys without you we would be lost |
| Ari Weil (@aweil) |
Slava was on the team who wrote the SQLOS |
| Brian Keener |
I can't even figure out why AWE is a checkbox for 64-bit systems? Has anyone explained WHY it would be useful? |
| Jorge Segarra (@sqlchicken) |
@AdamMachanic FTW!!!! |
|
I would like to thank everyone for the information they are providing in Chat. Lots of tips for beginners! |
|
@Brian: It's a checkbox because the SSMS team didn't bother to turn it off |
|
indexes are the bacon of SQL |
| Bob McLaren |
Just removed and re-added an index this morning! Purging 7million records tookminutes instead of hours, and re-building the index took less than a minute. |
| Jorge Segarra (@sqlchicken) |
Couple more resources for beginners. Free webinar series from PragmaticWorks: http://pragmaticworks.com/resources/webinars/February2010Webinar.aspx Also check out my blog project SQL University at http://sqlchicken.com/sql-university |
| Vince Amyotte |
and sometimes the bacon get burnt |
|
deletes/updates/inserts = DUI |
|
black cats are like burned bacon |
|
I love bacon. |
| Jorge Segarra (@sqlchicken) |
Oh man, I LOVE my new Twitter avatar |
|
Worth referring to this video http://sqlserverpedia.com/blog/sql-server-performance-tuning/sql-server-performance-tuning-formula-1-style/ |
| Jorge Segarra (@sqlchicken) |
@brent that dark cat's eyes are creeping me out |
|
DO you have a SQl script which help me to script indexes from database with includes? |
|
well Brent finally managed to get that DUI joke in |
|
@sqlchicken nice! it's fitting |
| Ari Weil (@aweil) |
Every time you create unecessary indexes @kekline kills a kitten |
|
Reminds me of the cat that walked in front of my car the other night |
| Nick Weber (@Toshana) |
We moved majority of our SQL servers to a VM env on 3 HP blades (each blade is 4 core 6 proc and 128GB Ram)all in different Enclousers infront of EMC DMX but soon to move to a HDS UPS V. |
| Jorge Segarra (@sqlchicken) |
According to my recent webcast everytime you shrink a database God kills a kitten |
|
I want more bacon |
| Brian Keener |
BACON!!! |
|
@ari lol |
| Antoni Franklin |
Hmm so if that is the case according to our vendors ke is the mike vick of cats.... |
|
shrink shrink shrnk |
|
mmmm bacon index |
| Jorge Segarra (@sqlchicken) |
I'm fairly certain Satan programmed CA Arcserve to make my life a living Hell |
|
of course, it depends.... often you need an index to identify the rows to update/delete |
| Brian Keener |
Bite your tongue Mr fleming |
|
@Jorge-- it isn't just Arcserve, its CA in general |
|
Bite your tongue Mr Fleming |
| Jorge Segarra (@sqlchicken) |
@philip good call |
| Ari Weil (@aweil) |
@Ian, this is the clarification you probably were after |
|
Apparently the vconference is powered by kittens and I just killed the ones which keep the video in sync. |
|
Where can I get the scrips in this training session? |
| Jorge Segarra (@sqlchicken) |
@heeyoon they're at http://questkb.com/live |
|
@heeyoon www.questkb.com/live |
|
sorry, how did he get those results? |
|
Actually, Mr Fleming, it was your mentioning the word "shrink" without the double-quotes |
| Stephen Dyckes (@SDyckes) |
Nice lost reference |
|
They are plugging questkb.com/live every 30 seconds. |
| Ari Weil (@aweil) |
Drop it like it's hot @brento |
| @christinaleo |
excellent resource for monitoring index usage: http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/02/18/analysing-indexes-summary.aspx |
|
Where can I get script to script indexes with Includes? |
|
My cats are enjoying the conference because they have me here all day giving them scratches. |
| @SQLJackal |
here's the link for removing indexes query http://sqlserverpedia.com/wiki/Find_Indexes_Not_In_Use |
| Bob McLaren |
Wow, I just found a PLETHORA of unused indexes in my DBs. Thanks Guys!!! |
|
If you are running a packaged application (like PeopleSoft) - don't drop the index, disable it. |
|
should reads_per_write be high or low? |
|
Thanks! |
|
I have a ton of unused indexes but I can't remove them because it is a vendor db... I do have some of my own that need to go. |
|
I'm asking because I don't know. Should we really be adding and dropping indexes in purchased software such as ERP's? |
|
some indexes are just used periodicaly but are very useful,be careful to drop them (they should be used may be 4 times a year) |
|
@David: good call. Didn't think about that |
|
Where can I get a script to generate scripts for indexes with Includes? |
| Ari Weil (@aweil) |
reads per write should be high |
|
It might be best to DISABLE the index instead of dropping it... until you're really sure it's not used |
 Karthik Yella |
reads per write should be high....then its a good index |
|
Wow, Kevin called me Mr Fleming. I thought that wass my dad....but he's not a DBA |
Charles Hunt's username is changed to Charles Hunt (@charlezhunt).
| Bob McLaren |
Is there a way to reset these counters on a per-DB basis? |
|
BACON! |
|
@christine found this: http://support.microsoft.com/default.aspx/kb/971442/ |
| Colin Smith (@Smithco32) |
bacon Fetish much? |
| Ari Weil (@aweil) |
@mcLaren - be careful not to drop the indexes until you are certain they're not needed, or unless someone created them b/c of the missing indexes DMV alone...and even then not until you're certain. |
|
A bacon store. Nice! |
| Laura Krantz |
for crying out loud...what's up with all the bacon?? |
| Antoni Franklin |
No matter what we talk about it comes back to bacon..... |
| Jorge Segarra (@sqlchicken) |
Snippets are a godsend. For those who don't know snippets are shortcuts you can create for queries. For example that quote unused index script from that page? I just type (I chose "fuix" as find unused indexes) fuix and press TAB and SSMS automatically spits out that entire script for me |
|
Think they are hungry? |
| Jorge Segarra (@sqlchicken) |
You can get snippets for free by installing SSMS Tools pack available at http://ssmstoolspack.com |
|
If you are working with a vendor-built database do you recommend changing the fill factor to a lower number rather than dropping an index? |
|
Kevin needs to close his lges |
| The Man |
Must just be a lot of pigs? |
|
or "legs" |
| @christinaleo |
I wish we could get English bacon in the states |
|
Dude, I'm not wearing a kilt! |
| Jorge Segarra (@sqlchicken) |
@sandy be very careful when tuning vendor db's as you may void support agreements by changing stuff so check w/ them first |
| Bob McLaren |
@Ari Maybe I'll drop 10% of them at a time... |
|
bacon chocolate is good |
|
English bacon is typically from Denmark! |
|
That's a relief! |
|
eating a bacon flavoured mint currently. |
|
Maybe I need to focus on other parts of the set? |
 |
| Jorge Segarra (@sqlchicken) |
well not void but you know what i mean, you might cause issues. Also messing w/ indexes/configs could actually cause MORE problems if you're not careful |
|
Wonderful explaination of indexes! |
|
Are you gusy in front of the green screen? |
|
"guys" |
|
Jorge - you are soooo right! that's one reason I was curious if we're "allowed" lol to do so, should we just drop the fill factor on unused indexes and of course, use change control? |
|
Nope |
| Jack Cannon |
Why is Category a varchar instead of an ID field? |
| Ari Weil (@aweil) |
@sqlchicken, very true, many vendors (3 VERY common and big ones I have to deal with on a regular basis) will make your life a misery if you do anything to their databases |
|
applying bacon scented lib balm |
|
Maybe category needs characters - "BAC177"? |
| Jorge Segarra (@sqlchicken) |
also to let everyone do NOT touch any databases that are in Sharepoint as they are very VERY specific about what you can/can not do to those. |
|
lol so if your vendor writes crappy code you're just stuck - yuck |
|
Good call Jorge-- I have had to rebuild after programmers thought they could 'clean up' |
|
And Sharepoint is a trainwreck of a schema. Pls allow Msft's duct tape and bailing wire do its work unhindered. |
|
yep, don't touch the SP dbs for sure!! |
|
what is the difference between include and a traditional covering index? |
Antoni Franklin's username is changed to Tony Franklin.
|
But if my query is "where qty_in_stock < @minQty" will I get the same performance gains via this index? |
| Jorge Segarra (@sqlchicken) |
yeah pretty much Sandy. Sucks, doesn't it? One thing you can do though is approach the vendor and offer your help. @sqlsarg did this with many vendors and actually got them to rewrite a lot of bad code by offering to help and optimize their stuff |
|
thanks re: fill factor! |
| @christinaleo |
included columns only have the data on the leaf level - a traditional covering indexing carries the data to all levels of the index |
|
@Jose: Included columns don't count towards the index columns number |
| Ari Weil (@aweil) |
@sandy, no worries - hopefully this helps |
|
Please show the syntax again please... |
| Ari Weil (@aweil) |
@Leon, which? |
|
A covering index sorts on every column. An include index sorts only on the named column, but include the data of the included column  |
| Jorge Segarra (@sqlchicken) |
@jose for indexing read Tim Ford's (@sqlagentman) Indexing Best Practices: http://sqlserverpedia.com/blog/sql-server-bloggers/my-top-5-sql-server-indexing-best-practices/ |
| Tony Franklin |
@Kevin What is that connected to your laptop? |
|
Inclde is SQL 2008 only, right? |
|
How many times can he say bacon without taking a breath?  |
|
"Include" |
|
Here is the fill factor webcast archive http://www.quest.com/events/listdetails.aspx?contentid=8929&technology=34&prod=&prodfamily=&loc= |
| Roger (@SQLCzar) |
Includes are available in 2005 as well |
|
Tony, it's an external hard drive attached with velcro in case I need to pull it off in airport security. |
|
But I just bought the book. Ugh |
|
Kevin was zoned out. |
|
| Colin Smith (@Smithco32) |
so does 100% make sense in a datawherehouse or another type of read intensive database that does not have many DUI? |
|
Bacon coma? |
| Tony Franklin |
@Kev Never thought to do that... and I have miles of velcro around.... this video has saved me time already today on a non SQL level LOL |
| Ari Weil (@aweil) |
@Tony, this is a Quest standard, we all have strips of velcro on our laptops. HA! |
|
@Brent, what's the best setting for fillfactor? |
| Jorge Segarra (@sqlchicken) |
@christine lol "it depends" |
|
Is there a way to see if you need to use the PAD_INDEX feature? |
|
Thanks guys! |
|
|
just note that FILL FACTOR is never used for existing indexes. it takes effect only during the rebuild. |
| Tony Franklin |
@Ari I guess Brent is a renegade |
| Jorge Segarra (@sqlchicken) |
@christine check here: http://sqlserverpedia.com/search/?search=fill+factor |
|
Christine, I usually use 75% for a standard ol' oltp database, and 100% (or 0%) for OLAP. But "it depends" is a much better answer. |
|
For static and not changing much data, it's okay to have 100% fill factor? |
|
Joseph, use DBCC SHOWCONTIG |
| Ari Weil (@aweil) |
@Jorge - nah, he just doesn't need an external hard drive full of VMs to demo products from |
|
MerelyMortalDBA - Yes, absolutely! |
|
Have to go to a meeting... |
John Jakubowski's username is changed to John Jakubowski (@jjakubowski).
MerelyMortalDBA's username is changed to Mary.
|
100% index usually good to do on read-only or mostly read because it makes SELECT faster |
| Karthik Yella |
The fill factor setting is a little confusing in the UI. In th UI it says free space percentage. so If u want 90 % Fill factor u have to set the free space pecentage to 10 |
| Jorge Segarra (@sqlchicken) |
@Ari lol oh well, I'll gladly take that off his hands then. You know, as a favor. I'll take that Kindle too |
Jason Wisener's username is changed to Select *.
|
Tony, just be sure to get an external USB drive that doesn't require an additional power source |
|
@Jorge , @Kevin - thanks. Our server is kind of mix of oltp and reporting. People do reporting directly on production, which is bad I know. |
|
ouch, isn't SHWOCONTIG pretty IO intensve? I was hoping for something in a DMV somewhere that coudl show me. |
|
Hmmm, seems like OR Mappers like select * |
|
Poor Kitty! |
|
so is that kitten getting ignored? |
| Jorge Segarra (@sqlchicken) |
You're welcome Christine. That's what the community's here for, we all love helping out! |
|
What if you need all the fields? What is more efficient, * or listing the fields? |
|
Kevin Kills Kittens ..boooooo |
|
Poor kitten. |
|
Kills a kitten -eeeeeek |
| Jorge Segarra (@sqlchicken) |
lmao I love the sound effect of the kitten spine snap |
| Tony Franklin |
@kev I have one, but when I go in the data center have to hold it or find ways to prop it up, I never thought to do the obvious.... velcro LOL |
| Bob McLaren |
Fill Factor Question: What does a fill factor of 0 do? |
|
So was that an intentional Stephen Lynch reference? |
|
Karthik - correct. It's inverted. So you say what you want "filled" not what you want "free". If you're an Oracle person, it's called "percent_free" |
|
Is there a wav file of that? lol |
|
BWAHAHAHAAAAA! Kitties!!!! |
|
So frameworks like Nhibernate and ORMappers, that populate all properities on objects, are basically doing select * |
|
If so I will be impressed |
| Jorge Segarra (@sqlchicken) |
@bob it gets you to the unemployment line faster lol |
| Bob McLaren |
100 |
|
|
| Tony Franklin |
@Kev If I would not have missed the meeting in Memphis, I probably would have learned this a month ago |
|
Is there any bacon involved when killing a kitten? |
|
haha poor kittebs |
|
http://obsidianwings.blogs.com/obsidian_wings/2003/12/about_our_masco.html?cid=2299794 sometimes they fight back |
|
Bry-Ann, if you're putting it in production, list all the columns. |
|
Jonathan, love me some Stephen Lynch "My Name is Sah-tahn!" |
| Ari Weil (@aweil) |
FYI, fill factor 100 discussed here: http://sqlserverpedia.com/wiki/Fill_Factors best for read-only databases like data warehouses, but bear in mind that changes can create problems with this approach |
|
When you use the include the index uses additional space to include that field correct? have a 3rd party app where the vendor is concerned about adding includes due to space consumption. |
| Karthik Yella |
Do we have a SQLPASS Group in NYC Area? |
|
@Kevin - index tuning advisor puts too much load on a server. I can't run it on prod. But if I feed it with a trace file from prod and run it on test, will the recommendations be accurate? |
|
that is a great question christine quan |
| Jorge Segarra (@sqlchicken) |
@laura it really depends on what is kept in that column and how many rows there are in the table |
|
What is the meaning of the "impact" column in the missing index query? |
|
@sqlchicken - is the column in the include stored with the index? |
| Ari Weil (@aweil) |
@cristine, be aware that the tuning advisor will treat every index as an island. You have to take into account the aggregate effect of changing indexes (adding, removing, or changing) on the overall performance of your applications |
| Tony Franklin |
How accurate is the index tuning advisor? It has been hit and miss with me. |
|
@christine if your test environment is set up like prod and you have a similar amount of data, it should be accurate. |
| Jorge Segarra (@sqlchicken) |
@tony youll find a lot of us say those wizards are absolute crap as it makes a LOT of assumptions |
|
@Joseph, test is never set up the same as prod |
|
Christine - typically, DBTA will be useful in that case. Oh, esp in SQL2008. Earlier versions are only so-so. |
|
there is also a report that shows up for missing indexes under the performance dashboard - anyone ever use those as a starting point? |
|
agreed christine. |
|
@christine many of out test systems are full copiesof prod. |
| Jorge Segarra (@sqlchicken) |
@laura yes I believe so but lemme verify real quick |
|
yes, but alot of test env. are not the same "hardware" |
| Ari Weil (@aweil) |
@Laura, good starting point, but you have to follow the paradigm of seeing what the impact of adding an index will be before simply following its advice |
zakir hussain's username is changed to Zak.
|
Thank you |
| @christinaleo |
@Laura - the included column is only stored at the leaf level of the nonclustered index - it doesn't carry up the levels like the key columns do |
|
@Kevin - yeah I meant DBTA. just wondering if I run it in test , are the recommendations accurate? |
|
@laura The Include is stored at the leaf level, but not the intermediate pages. |
|
Is there a good query to run to archive important DMV stats just prior to a service restart? |
|
dui's are bad |
|
I was speaking mostly of data. Hardware is going to matter less tothe tunig advisor than the schema and amount of data |
| Jorge Segarra (@sqlchicken) |
ah ok, thanks for answering that @christinaleo |
| Ari Weil (@aweil) |
and statistics too |
| Bob McLaren |
QUESTION: Can the index stats be purged on a per-DB basis? |
|
didn't the sql 2005 dashboard have a 'missing index' function that gave you the 'create index' commands...is this basically the same thing? |
|
I always exceed 80% on sys databases is that bad? |
| Ari Weil (@aweil) |
@Chris yes, but again, sometimes the recommendations will have negative impact on your application environment |
|
Isn |
|
20% free? I wish, when I ask for more space, I get "> SELECT finger FROM hand WHERE id=3" |
|
@Bob No, they can't |
|
Isn't there an index option that says use / don't use temp db ? |
|
lol @ Philip |
|
lol, philip |
| Jorge Segarra (@sqlchicken) |
lol @philip |
|
Don't you want to figure out how big the index is (paying special attention to whether it is a clustered index which means you need space for all indexes), then make sure you have 2.5 x's that space (this is from oracle days) |
|
Wow that would be nice |
|
lol @philip |
| Jorge Segarra (@sqlchicken) |
@mark that option is for when you're doing index maintenance like rebuild/reorg |
| Karthik Yella |
@Mark: You have an option called SORT IN TEMPDB |
| Bob McLaren |
K, Thx |
|
Phillip, I feel you, man! That's harsh. |
|
so you can't do it/ |
|
Is there a fool proof version of Missing indexes? Similar to Adam Machanics sp_whoisactive |
| Roger (@SQLCzar) |
Online re-index seemed to take 200% of the clustered index size |
|
Debbi, that sounds like a good recommendation. ) |
|
WOW... when using the indexes not sued script on a box that has been up for some time, I am startled by the huge number with a reads/write ratio of zero.... basically indicating it is useless. Silly vendors!! |
|
thx |
| Jorge Segarra (@sqlchicken) |
Index statistics article: http://sqlserverpedia.com/wiki/Index_Statistics |
Nitin Salgar's username is changed to @nitinsalgar.
| Roger (@SQLCzar) |
I know that there is extra space concerns when online re-idex when sorting in TEMPDB |
|
I remember something like HeDGE FACTOR i.e. the Index space (required) = 1.2 X table space |
|
pay attention now. |
|
what about the order of elements in the index, I read somewhere that is must by a left justified subset for the query to use an index |
|
BrentO needs to repeat Ari's questions/Statements for those of us without good hearing or great sound systems. |
|
NO, a covering index included all columns needed to return the results sets. |
| Ari Weil (@aweil) |
@Pat, sorry, thought I was being loud enough. We'll do that |
|
no that's not a covering index |
| Carm Vecchio |
on-line creates a new index in tempdb so the original can still be used |
| Tony Franklin |
@Kev you have to get Brent to repeat the questions because Ari sounds muffled for some reason now |
| @christinaleo |
The difference is between key columns and included columns |
|
Thanks, Tony, will do. |
|
Christina, isn't that what I said? |
|
| Jorge Segarra (@sqlchicken) |
Nice Airplane reference, +5 dexterity |
| Vince Amyotte |
video is frozen |
|
Jorge-- do you like gladiator movies? |
|
The point is that an index is not by defintion covering or non-covering. The quality of covering is relative to a particular query. So an index may "cover" one query and not "cover" another query. |
| Carm Vecchio |
bacon movies... |
| Jorge Segarra (@sqlchicken) |
| @christinaleo |
@kevin - the key columns are carried to all levels of the index - included columns are only on the leaf level |
| The Man |
my video is fine |
|
Jorge buffed me! |
|
Yeah, Donald Rum... such a brillant man. |
|
Good thing I'm wearing my undershirt of smiting, +20 to hit bro! |
| @christinaleo |
@kevin so you could have a covering index with or without included columns |
|
Is index data stored in the data table? Does it differ for clustered/unique/non-clustered? thanks! |
|
Brent, fot he ONLINE indexing the SQL engine uses the VERSIO STORE facility ( for the rows being modified and are being accessed by the index op) |
|
Should PK indexes automatically cover all fields in the table? Meaning there should not be a bookmark or lookup if I am doing PK index seek and filtering on additional columns? Thank you |
|
Ah, excellent, Christina. Thanks for the clarification. |
|
If tempdb has a disk all to itself, is there any performance drawback to making it huge? |
| Ari Weil (@aweil) |
@Ram, I'll probably cover that in the last product session, but very true on the version store |
|
yeah, I sure did run out of tempdb doing an online index just the other day too |
|
What is the link to the code used in this vconference? |
| Ari Weil (@aweil) |
@Nina, www.questkb.com/live |
|
I work with a DBA that thinks it's perfectly ok to schedule weekly index reorgs without checking for available space before the job runs. Am I crazy to think this is bad practice? |
|
I am looking for a script to script all indexes from a database including includes |
|
that is one fat cat |
|
Nicholas, no - not really. You used to be able to create TempDB in RAM for that matter. In fact, you still can with specialized RAMDisk software. It's blazing hot but, of course, you have to give up RAM to make it happen. |
| @christinaleo |
@Dexter - Get a copy of SQL Server 2008 Internals - it will make sense of how the different types of indexes work on the underside |
|
Heaps come from developers, not DBAs!!!!! |
| Ari Weil (@aweil) |
@Kimberly, no, you're not crazy...but we are, so take that with a grain of salt |
| Ari Weil (@aweil) |
@Narayanan, it's on http://www.questkb.com/live |
|
Narayanan Palissery, get a copy of red-gate |
|
Kimberly, that's very dangerous. Reel that DBA in! |
| Jorge Segarra (@sqlchicken) |
@kimberly if youd like figure out best practices with maintenance plans check out Brad McGehee's free ebook: http://www.sqlservercentral.com/articles/books/68380/ |
|
Hi Mary |
|
Is there a recommendation with the use of PK and Clustered index? For some reason, PK is always assigned to be the Clustered Index as well. Would it make sense to have them differ from each other? |
|
Narayanan, it's right there in the SSMS interface. |
| Jorge Segarra (@sqlchicken) |
also you often don't need to do reindex/rebuild all indexes at a time. Try out Michelle Ufford's (@sqlfool) Index maintenance script: http://sqlserverpedia.com/blog/sql-server-bloggers/automated-index-defrag-script/ |
|
@Kevin and Ari thank you! This has been a struggle for me. I'm the co-op so people don't want to listen to me |
|
@mary CIs are good for range scans. you can put PK on another filed |
|
My primary databases actually have no primary keys. |
|
Brent, what is good practice to keep/drop CI/NCI indexes druing heavy BULK loads? |
|
David, this is a problem. |
| Ari Weil (@aweil) |
@David, that's interesting, why? |
| John Jakubowski (@jjakubowski) |
|
Thanks! |
|
Because my ERP Vendor is the anti-christ. |
|
dave, are you from pitt by any chance? |
| Ari Weil (@aweil) |
@David, great answer!! |
|
cool Narayanan |
|
It's awful. |
|
Gives TOAD and other programs fits. |
|
Alter index disable works on SQL 2005 too |
| Bob McLaren |
FYI - I disabled indexes this morning in SQL 2005 |
|
@David: wow. granted we have one that doesn't use FK so I don't know how much better I am |
|
No, Dallas. Why? |
|
Let me guess th vendor wants their code to handle those sorts of things.... |
|
Oh, thanks Nitin |
| Bob McLaren |
what about filtered inex |
|
obviously mine have no FK's either. |
|
what ERP is that David? |
|
@David: what erp? |
| Ari Weil (@aweil) |
@David and check constraints and triggers enforce everything |
| Dexter Jones |
@christinealeo - Thanks, I will. |
| Karthik Yella |
anyone from NYC area? |
| Bob McLaren |
Not familiar with filtered index |
|
It's called Made2Manage. |
|
Will you raise your hand for a second Kevin? I'm curious what the delay is between you guys saying something and the audience hearing it. |
|
@david ours doesn't have any constraints or foreign keys - app is supposed to handle everything (gotta love 3rd party software) |
|
lol |
|
People who administer it often call it Made2Damage. |
|
A friend of mine is a dba and his name is David Stein. |
|
lol |
| Karthik Yella |
@David I think its Mad to Manage |
|
I would recommend adding customized/clustered/PK indices based on Execution Plan review, Script it/them, then rerun the script after each Update/Upgrade by the Vendor... |
|
Sites with info on filtered indexes: http://sqlfool.com/http://statisticsio.com |
|
uggh. I hate 3rd party. We have one vendor that insists adding indexes is a modification of the table and in effect is not allowed by contract. Point is...ready your 3rd party contracts carefully in regards to the database. |
| Bob McLaren |
Thanks guys, now I *AM* familiar with filtered indexes! |
|
Filtered indexes allow you to have more than one null in a column yet still have a unique index. |
|
read...not ready I mean |
|
Tbanks! |
| Jorge Segarra (@sqlchicken) |
http://sqlfool.com = Michelle Ufford's blog http://statisticsio.com = Jason Massie's blog |
|
or "thanks" |
|
I'm famous. |
| Dexter Jones |
I'm guessing Brent is not a decaff guy... |
|
That is caffeinated water. |
|
except great plains it still stinks |
|
and then will build a Data Warehouse on those tables. |
|
Can't say enough good things about Michelle "sqlfool" Ufford |
|
David you are made to manage |
| Jorge Segarra (@sqlchicken) |
NOT ACCESS, JET DAMNIT, JET!!!! |
| Eli Weinstock-Herman (@tarwn) |
he discusses trigers in his book... |
|
what is his website? |
| Jorge Segarra (@sqlchicken) |
</mongering> |
|
JET is more like an old prop plane |
| Jorge Segarra (@sqlchicken) |
@ismael Brent's blog is http://brentozar.com |
|
sound volume has gone down |
| Jorge Segarra (@sqlchicken) |
JET is more like poop |
|
thans |
|
JET is still used by Exchange as I recall |
| Jorge Segarra (@sqlchicken) |
that's right Brent, SAY MY NAME! lol |
|
Is there a SQL Server 2008 version of the Performance Dashboard Reports? |
|
@Jorge: nice |
|
We re-index every sunday |
| Ari Weil (@aweil) |
@Daniel, yes and they come with SSMS 2008 |
| Jorge Segarra (@sqlchicken) |
@daniel yes, you can use the 2005 dashboards just need to do slight tweak. Brent will post that soon IIRC |
| Jorge Segarra (@sqlchicken) |
lmao |
|
@Jorge HA! let Brent try saying mine |
|
we run a script weekly to check fragmentation levels and if it is in one range defrag and if in another rebuild |
|
I would need at least 465% |
| Jorge Segarra (@sqlchicken) |
@laura sounds like youre doing it right! |
|
Laura, I believe that's what Michelle Ufford's script does too |
|
Paul, then your customers will expect that all the time. |
| Ari Weil (@aweil) |
@Laura, agreed, good work - are you getting through all the indeces though? |
| Bob McLaren |
@BrentO - AMEN brother! Preach it!! |
|
keep it slow |
|
they do already..... lol |
|
I have rebuilt fragmented indexes (as indicated by the DMVs) and it still shows fragmentation in the DMV views. Have you experienced the same? |
|
Brent, progress made from DBCC ShowContig to DMV - Index-physical-stats for Frag info. Is the progress is also true in terms of resource usage (mem / Cpu)? |
|
is there way automate the update statistics only when needed |
|
Didn't Paul Randal have a blog post about how bulk inserts are actually faster with CI on a table opposed to a heap? |
|
Jay, I have seen that too. |
|
@Ari so far yes as the db isn't huge though the problem I am going to face is the db will be 1 tb in size and the vendor does not do partitioning |
| Tony Franklin |
Man you guys make me more dangersous errr I mean skilled everyday |
| Jorge Segarra (@sqlchicken) |
@narayanan yes, go get Michelle Ufford's (@sqlfool) script and schedule it http://sqlserverpedia.com/blog/sql-server-bloggers/automated-index-defrag-script/ |
| Ari Weil (@aweil) |
@Narayanan, that's what the built in auto-update statistics should do, but the threshold for it to run is 20% change of the underlying data which depending upon the number of rows in the index, could take a long time to hit |
|
Do you have a link to that? |
| Tony Franklin |
"dangerous" |
|
Michelle Ufford's Script? |
|
I have rebuilt fragmented indexes (as indicated by the DMVs) and it still shows fragmentation (after rebuild) in the DMV views. Have you experienced the same? |
| Stephen Dyckes (@SDyckes) |
@SQLFools script Rocks!! |
|
@Ari, does this script work on SQL 2000? |
| Jorge Segarra (@sqlchicken) |
Michelle Ufford script for Index maintenance: http://sqlserverpedia.com/blog/sql-server-bloggers/automated-index-defrag-script/ |
|
Jay, I have seen that too. |
| Ari Weil (@aweil) |
@Narayanan, better to run when it's appropriate, so create a job to run during your maintenance window to check stats and if necessary update them WITH the appropriate sample |
| @christinaleo |
@Jay Shah - how many pages are in the index? indexes with only a few pages ( like <10) tend not to defragment, and it doesn't really matter on indexes that small |
|
I have about 300 tabs open thanks to all of you... I have some great reading to look forward to. Many of these I've never seen before. Now all I need is to find an extra 10 hours a day. |
| Jorge Segarra (@sqlchicken) |
yes @Rudy, the script is built to adjust to 2000, 2005 and 2008 |
|
Thx |
| Bob McLaren |
@BrentO - Not sure I understand why I should update stats after an index defrag |
|
@brent how long will these links stay there on your live page ? |
| Tony Franklin |
@Phil I understand my fans kicked on and I cannot find anything |
| Ari Weil (@aweil) |
@Bob because the default is only to update a sample of the stats on the index, so performance may not reflect the improved concurrency |
|
@Bob so it has stats to use the new indexes with |
|
Nice job guys! |
|
Well done guys! |
|
@bob I believe the stats are only updated after a rebuild not after a reorg by default hence the need to update teh stats |
| Jorge Segarra (@sqlchicken) |
@suleman what you can't find on the live page you can most likely find at http://sqlserverpedia.com |
|
clap, clap |
| Tony Franklin |
Great job guys |
| Bob McLaren |
Thx all. |
| Jorge Segarra (@sqlchicken) |
EXEC sp_audience_applause |
|
@sqlchicken do you have tom la rock's duplicate indexes script? |
|
great information for all levels! |
|
Great job thanks for the info. |
|
I have to say this has been incredibly awesome. Thanks to Quest for putting this on...<clap><clap> |
| Jorge Segarra (@sqlchicken) |
@nitinsalgar no I don't but Brent should be getting it posted soon |
|
@sqlchicken thanks |
| Bob McLaren |
But if it's just a defrag, it's not a new index, so why are the existing stats sufficient? |
| Bob McLaren |
I meant, why *aren't* the existing stats sufficient (without an update) |
| Jorge Segarra (@sqlchicken) Bob McLaren |
existing stats may not take into account any massive changes (bulk inserts/deletes, etc.) that may have occurred during maintenance |
|
better stats = better plan |
|
@bob @kelly @Jorge stats and index reorg are 2 different independant things. they just go hand in hand |
Mary Myers%2DDevlugt's username is changed to MaryMyers.
| Jack Cannon |
What is the URL to follow this on twitter? |
Select *'s username is changed to Phil McCracken.
| Jorge Segarra (@sqlchicken) |
You want the statistics to be as accurate as possible so the engine can be optimal. Sometimes in large DBs you can't sample all of the data (i.e. terrabytes of data) so you need to take a sampling of that and build statistics from that. Otherwise your other option is to do a full scan and build stats based off all rows |
| Bob McLaren |
I guess I just don't understand how stats ever get out of sync. When you perform a bulk DUI, do the stats not get updated during that transaction? |
| Jorge Segarra (@sqlchicken) |
@jack look for #QuestQA |
|
@bob no. stats are not updated with data updates |
| Jack Cannon |
Thanks |
| Jorge Segarra (@sqlchicken) |
@bob yes and no. Statistics update automatically after a certain percentage of the overall data has changed so in that respect it does update |
|
How does the Query Optimizer Engine work? |
|
typically takes 20% of underlying rows to get updated before the stats are automatically updated |
| Tony Franklin |
Just the idea of putting velcro on my laptop will save my company at least 1K on damaged drive replacement this year alone |
| Bob McLaren |
Ah, but stats do not update after every transaction then? |
| Jorge Segarra (@sqlchicken) |
This article tells you how it works (index statistics): http://sqlserverpedia.com/wiki/Index_Statistics |
| Jorge Segarra (@sqlchicken) |
@bob no, otherwise the database would never get any work done since itd be updating stats all the time. |
|
@bob no they're not |
|
stupid chat lag... makes me answer already answered questions... |
| Phil McCracken |
thanks Jorge |
| Bob McLaren |
Excellent, Thx. This webinar has been awesome by the way. |
| Jorge Segarra (@sqlchicken) |
You're welcome Phil |
| Phil McCracken |
Yes, Quest should do this weekly. |
|
Any threshold recommendations on the index rebuild/reorg regarding page_counts? We use a script similar to Michelle Ufford's and if the page_count is > 8 pages we take a look at it. I was reading somewhere that it should be around 1000 pages. |
|
When would the perfmon poster that was mentioned in the morning session be available? Thanks! |
| Phil McCracken |
popcorn time. |
| Jorge Segarra (@sqlchicken) |
hey all for those who don't know Mladen Prajdic wrote the (absolutely essential, IMO) plugin for SSMS called SSMS Tools Pack http://ssmstoolspack.com . HIGHLY recommend you go download that and check it out. Snippets feature alone is worth the install. |
| Vince Amyotte |
im not sure if they could get a weekly thing done due to the work involved. a monthly session would be awesome though. |
|
Yeah, we'll fill yer cracken. |
|
I am going for ice cream |
| Jorge Segarra (@sqlchicken) |
@marcia funny you mention that, they talked about that at PASS Summit (http://summit.sqlpass.org ) and Paul Randal, SQL diety and guy who worked on DB engine team, said he basically made that number up so it really depends. |
| The Man |
I'll take vanilla
|
| Tony Franklin |
@jorge is this for 2005 2008 or both? |
|
You can rate the speaker at http://speakerrate.com/speakers/3091-brent-ozar |
| Jorge Segarra (@sqlchicken) |
is it safe to install toolspack in production env. |
| Jorge Segarra (@sqlchicken) |
@tony, it works on SSMS 2005 or 2008, just specify which version when you download |
|
ah yes, it ALWAYS depends. Depends on what, though? |
 Stephen Wynkoop |
@brento - nice. |
|
love the goggles. need that for the photoshoot at the #sqlpass summit |
| Jorge Segarra (@sqlchicken) |
@ahmed absolutely safe |
| Tony Franklin |
BRent WTH?!?!? |
| Bob McLaren Jorge Segarra (@sqlchicken) |
SSMSToolsPack adertises that it is an add-on to SSMS Express. Does it also work on SSMS proper? |
| Jorge Segarra (@sqlchicken) |
lmao @brent |
|
damn, I missed something. |
|
I'm not a doctor, but I'll take a look |
| Jorge Segarra (@sqlchicken) |
@bob yes, it works on full-fledged SSMS 2005 or 2008 |
|
is there a date for the next event? |
| Bob McLaren Jorge Segarra (@sqlchicken) |
Sweet |
| Tony Franklin |
@jorge do sp independent? |
|
Love the graphic |
|
Kermie is preggers? That is odd..... |
|
yep, frogs they are a changin |
|
Sexting - that's why Kermie was at the dr's office |
| Jorge Segarra (@sqlchicken) |
Frogs change sex. Has Jurassic Park taught us nothing?!? |
|
Wasn't if just for being ill? I seem to remember that episode Muppet Shoe |
| Jorge Segarra (@sqlchicken) |
I think I just made Kevin laugh |
|
er show |
| Ari Weil (@aweil) |
@sqlchicken - AMEN! |
|
is there a date for the next event? |
| The Man |
Sharon can be your date... |
|
Dr. Horrible! |
|
anton, go to http://www.quest.com/backstage for our other upcoming events |
| Jorge Segarra (@sqlchicken) |
@anton check http://www.quest.com/backstage/ for Quest events |
| Ari Weil (@aweil) |
@kimberly gets the reference! |
|
ooo do I win a kindle? lol |
|
SQLLuch.com offers some good sessions too. |
| Ari Weil (@aweil) |
@kimberly, well there's the one that @brento dropped... |
|
@THeMan |
|
thanks for the links |
|
lol that's a bonus |
|
is there anyway.. can you findout the latest activity on a specific datafile?? |
|
what is in that bottle next to Brent! Beginning to wonder.... |
|
Brent's going to have a red mark on his forehead when he takes thos goggles off. |
| Ari Weil (@aweil) |
yes, start with the virtual file stats DMV |
|
You can see the multitude of older Quest SQL Server webcasts at http://www.quest.com >> About Us >> Events, then select the Archived tabs |
| Jorge Segarra (@sqlchicken) |
Marlon Ribunal @marlonribunal put together a great page with all SQL webcasts http://dbalink.wordpress.com/webcast-list/ |
|
is Kevin the hammer? oh wait... we know what the hammer is. haha sorry Kevin. |
|
@Ari. How about on sql 2000? |
| Tony Franklin |
I think Brent can pull it off. If he went to the store I bet he would get a lot of medical questions |
| Ari Weil (@aweil) |
@Vel, you can use DBCC for help in that regard. I'll find a link... |
| Stephen Wynkoop |
http://twitpic.com/16fdy3 - Dr. Ozar (@brento) and Kevin Kline (@kekline) on today's show |
|
Sure.. Thanks Ari! |
|
Finding webcasts that comunicate at the entry level is sometimes difficult. I sure am glad I chose to attend this one! |
| Jorge Segarra (@sqlchicken) |
buahah nice Swynk, ill be saving that |
|
Jolene, there are also a lot of good 100 level sessions at http://msdn.microsoft.com and http://technet.microsoft.com |
|
The market in Chicago sucks. Nobody’s ever hiring College graduates as SQL DBAs. |
|
Thanks Kevin! |
| Phil McCracken |
oh |
| Phil McCracken |
my |
|
I have a vendor who named all of their additional data files with .mdf extension, what are the ramifications of that? |
|
sql 2000 used fn_getvirtualfilestats |
| Phil McCracken |
what type of doctor? |
| Tony Franklin |
@wrd sfas You have to go south we don't have enough |
|
@Artem nothing |
 MaryMyers |
SQL 2000 - use :: fn_virtualfilestats |
|
dbcc loginfo |
|
Is anyone experiencing low audio volume - I had to turn up my volume to max and I have external powered speakers |
|
@Artem SQL does not care what the file extension is as long as it is formatted correctly |
| Ari Weil (@aweil) |
@Joseph and @Mary, thanks for the save |
|
2000 -- fn_virtualfilestats |
|
oops nice lag everyone answered. |
|
but that's incorrect, no, otherwise MS would've left it as .mdf instead of .ndf |
| Jorge Segarra (@sqlchicken) |
@vel install the SSMS Performance Dashboard, has a IO statistics report built-in |
| Vince Amyotte |
how do you spread the load after you add the new file? |
| Colin Smith (@Smithco32) |
got in a bit late fo this one but when did DR. Horrible get here and when does he start singing? |
|
Thanks Everyone... |
| Ari Weil (@aweil) |
@Vince, they should've just answered your question, did that make sense? |
|
Vince, don't add a new file. Increase the size of existing files |
| Bob McLaren Jorge Segarra (@sqlchicken) |
QUESTION: I know that a 1 Terabyte RAID5 comprised of just 4 drives is "bad". Can you help me quantify (for my boss) exactly *how* bad it is? |
| Jorge Segarra (@sqlchicken) |
Performance Dashboard download link: http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&DisplayLang=en |
|
Kevins comment on growing file sizes would not apply to log files... correct? |
| @JMurphyd |
You know bacon’s bad when a healthier choice is a donut. |
|
Completely OT: Did we ever find out what the box with the pretty blue light is? The one attached to Kevin's laptop, that is.. |
| Bob McLaren |
QUESTION: I know that a 1 Terabyte RAID5 comprised of just 4 drives is "bad". Can you help me quantify (for my boss) exactly *how* bad it is? |
| Eli Weinstock-Herman (@tarwn) |
We'll convince him to sing at SQL Saturday |
| Ari Weil (@aweil) |
@Stephen, correct |
|
Bob - 4 spindles for 1 tb?!? this is a huge built in bottleneck. |
| Ari Weil (@aweil) |
@Bob, just because it's fresh in my mind, Brent's book has a chapter on that that provides the specifics you're after |
| Phil McCracken |
what is the query to get that result back? |
|
Imagine you want to support 100,000 cars per hour on your road, only 4 lanes? Insane. |
| Vince Amyotte |
Is there a recommended configuration for number of data files for a tempdb? |
|
benjamin that's a External HD |
| Ari Weil (@aweil) |
@Phil, that's a select from the virtual file stats DMV |
| Jorge Segarra (@sqlchicken) |
@bob tell your boss putting SQL Server on a disk array like that is like building a Ferrari and giving it square wheels. He'll get the picture |
|
ah, ok, thanks |
|
I hit "session Room" link again and sound increased - fyi |
|
I was wrong, it's fn_virtualfilestasts, not fn_GETvirtualfilestats |
| Gareth (@GarethSwan) |
I know that server !!! |
| Kevin Lasky |
square wheels will prevent it from rolling down a hill when he parks it |
|
If I have "one big ass" file and want to split it up into smaller equally sized files, what steps are required? |
|
Anyone find a best max size for data files when using a san? I ask because our san folks can't say as they are using 60 gig chunks to make up whatever size we request and we have a multi tb database we are planning so I have to speck out lun sizes - the original design was to have 7 1 tb drives |
| Phil McCracken |
what is the synatx? |
| Bob McLaren |
Thanks for the creative responses guys. |
| Jorge Segarra (@sqlchicken) |
@vince that's a debatable topic but typically folks tend to say one file per physical core for tempdb |
|
If all the equally sized files on the same LUN of a SAN - is there a performance advantage? |
|
@bob I would say it depends, if your talking a small time db then its fine but if this is a consolidated db server with high load, you should run |
| Ari Weil (@aweil) |
@sqlchicken, latest advice is 1/4 or 1/2 of the cores on the machine... |
|
Is there a requirement that tempdb data file size to be same, when using multiple files, for the load balancing/parallellism to work? |
| Jorge Segarra (@sqlchicken) |
ah cool, thanks @ari, I know that argument has always been kind of nebulous |
| Phil McCracken |
was it
sys .dm_db_file_space_usage |
| Vince Amyotte |
@Jorge thanks |
| Ari Weil (@aweil) |
@Sreekanth, it's not a requirement, but if they're not sized the same the round robin won't work as well and SLQ Server will hit the file with the most free space most |
|
Next time, I'll do this in a smoking jacket with a pipe |
|
David, there is not mush point in splitting one large ile into smaller files if you are keeping them on the same LUN |
|
Is that a best practice to move clusterd indexes to seprate file? |
|
Thanks. |
|
@Kevin, it would be much better to dress as Moist if you're sitting next to Dr. Horrible. |
|
That makes sense. |
|
i generally use the perfmon setting at about .5 or .75 percent full of the log files after running for a few weeks and a 1/2 on the cores how do you come up with your max size. |
| Jorge Segarra (@sqlchicken) |
@narayanan best best practice, ideal world where unicorns are alive and the planets align, yes. But in reality sometimes its either not needed or not possible |
| @christinaleo |
what ari said. . . that's why the same file size is important |
|
Give Ari a mic as you can barely hear him |
|
@jorge +! |
| Phil McCracken |
yes, size is important |
| Jorge Segarra (@sqlchicken) |
hey Allen! |
|
it has nothing to do with disk space, just the file space used versus file space allocated |
| Karthik Yella |
Laura you should specify to your SAN team what throughput you require read and write. Also specify i/o per second that you require. It shouldn't matter too much how they configure this as long as they can give you the throughput you are looking for. Remember 1 single drive is unlikely to give you more than 40MB/s. A fast drive will start at 80MB/s but as you fill the disk it will slow down to 20MB/s |
|
Database snapshot - the index usage produce correct result? |
| Jorge Segarra (@sqlchicken) |
anyone else get amused when @brent goes "OOOOOH!" |
| Bob McLaren |
What is the performance difference between filegroups on 8 sep disks vs. 1 filegroup on a 8-disk raid array? |
|
how does that restore you mention work when we backup with LiteSpeed? |
| Ari Weil (@aweil) |
@Bob, which RAID? |
|
Is Brent auditioning for the part of Doctor Nick in the Simpsons? |
|
lost video....... |
| Laura Krantz |
@sqlchicken I laught every time |
|
Have you heard of separating the tempdb database onto separate drives per core? |
| Bob McLaren |
Either pure striping or RAID 5 |
|
Obvious answer is RAID 5 is going to provide more fault tolerance. |
|
What would be advantage of Quest lite speed over sql server 2008 native backup compression |
|
on Database snapshot - the index usage script produce correct result? |
|
DATA, CORE AND SYSTEM PARTITIONS |
|
No, he is getting ready for the DR OZ show! |
| Laura Krantz |
@maurice, yes I have...1 per core. However, that isn't always the best configuration. You have to test it on your particular system |
|
@parag-- you only get compression with Enterprise version |
|
This diagram that I made might help, found here.... http://www.e-squillace.com/tech/techdiagrams/DatabaseConstructionBuildingBlocks.htm. Make sure you pick the "Files & Filegroups" sub-diagram. |
|
@douglas @Karthik - thanks... I tried but, got some odd respnoses back (basically what the vendor states is the speed of the san) I also brought up disk partiiton alignement and am fighting about that as well.... |
|
Maurice, look through the chat log here - we've already discussed this. |
| Jorge Segarra (@sqlchicken) |
For design best practices and generally awesome information in that arena check out Louis Davidson (@drsql)'s book: http://www.amazon.com/Server-Relational-Database-Design-Implementation/dp/143020866X |
|
ok |
|
is filegroup recovery / data file recovery an Enterprise Edition only option? |
|
Brent, Is it a good reason to have as many # of Files as many CPUs on the box for TEMPDB ? |
| Jorge Segarra (@sqlchicken) |
no @keith, filegroups are in Standard as well |
|
Ram, scroll up, this was answered earlier. |
| Bob McLaren |
@Ari - Thx! |
|
@Brent, partitioning is only available in sql enterprise edition |
|
i/o pathways |
| Jorge Segarra (@sqlchicken) |
partitioning is sweet |
|
|
I love all this talk but when do we get the shwag |
| Ari Weil (@aweil) |
@Narayanan, insofar as that point in time is concerned, yes |
|
If you are runnign under NAS.. what would be the best option for thsi example? |
|
The best questions get the best shwag? |
| Jorge Segarra (@sqlchicken) |
@vel i generally wouldn't recommend running a SQL Server off a NAS (NAS <> SAN) |
|
NAS is not a good type of media for SQL |
| Phil McCracken |
so what was the answer? |
|
NAS are considered very bad for database applications |
|
Lynchi Shea has articles on this |
| Karthik Yella |
@Laura, this can be a common issue that SAN vendors try to avoid. They will try whatever they can to avoid providing any kind of SLA for your performance, but you want your boss to insist. I have seen most SAN's average less than the I/O speed of your laptop. I have seen some SAN's perform as little as 4MB/s, which is slower than a hard drive from the eighties. |
| Phil McCracken |
what is NAS? |
|
Network Attached Storage |
|
network attached storage |
| Carm Vecchio |
Shameless |
|
NetApp considered a NAS or a SAN |
| Phil McCracken |
yes, |
|
NAS uses network protocols that are too chatty, once again refer to Lynchi Shea articles |
|
Thanks!!!! |
| @christinaleo |
NetApp is a SAN |
|
They make both. |
|
@Brent- how do you defrag a SAN drive? I know it's not recommended |
| Phil McCracken |
is NETApp considered a NAS? |
| Bob McLaren |
So if I am on a RAID5 arrary, any reason to split up the files/filegroups? |
| Karthik Yella |
iSCSI can solve some of the NAS chatty issues |
| Jorge Segarra (@sqlchicken) |
@phil NAS = Network Attached Storage http://en.wikipedia.org/wiki/Network-attached_storage |
|
SAN software handles defragmentation of SAN I believe |
 Jonathan Gardner |
@Brent I already got the book on the way |
|
no |
|
Christine, at a sector and/or hardware level? |
| Jorge Segarra (@sqlchicken) |
SAN offers the cache which is what helps in the performance |
|
@kevin - on a hardware level |
|
Christine, look at the diskpar.exe and diskpart.exe Windows utils. |
|
My san drives are very fragmented |
| Jorge Segarra (@sqlchicken) |
also SANS are flexible in that you can have SATA drives or Fibre channel drives in it |
| Phil McCracken |
is NETApp considered NAS or SAN ? |
|
are u going to talk about Copy Only Backups for Adhoc Backups |
|
@Kevin, but it's not recommended to defrag SAN |
|
The SAN vendor should also provide tools to help with that. |
| Nick Weber (@Toshana) |
it can be both |
|
Phil, NetApp is usually NAS. But they also make SANS |
| Jack Cannon |
What is wrong with the "tbl" prefix? |
| Ari Weil (@aweil) |
@Narayanan, what do you want to know? Do you have a specific question? |
|
@kevin, no they don't provide tools |
| Nick Weber (@Toshana) |
It is a SAN that has a NAS head on it |
| Vince Amyotte |
can you break a table up after the fact? |
|
Many companies pushing IT to go into VMs and, as a side effect, because of that to NAS. How would you address this to protect database environment from VM consolidation? Thnaks. |
|
Vince, sure you can ... |
| Ari Weil (@aweil) |
Copy only backups can be helpful to create an on-the-fly backup in some cases...DBAs tend to use it to get developers (for example) a quick copy of the database without changing the recoverability of the database |
|
@Brent @Kevin Are you going to cover split i/o as it is such a challenge on large SAN implementations? |
| Jorge Segarra (@sqlchicken) |
Check out Brent's SAN 101 video: http://sqlserverpedia.com/blog/podcasts/storage-area-networks-sans-101/ |
|
I want to know how they work, if you can point to me a URL that will be great |
| MaryMyers |
schema partition |
|
@Brent - do I need to have a datetime field in order to do table partitioning? |
|
kevin kline looks sleepy |
|
Can you apply a partitioning scheme on an already existing table (with no partition), or does it need to be rebuit? |
|
Narayanan, start at Wikipedia for very broad and general technology info. |
| Ari Weil (@aweil) |
|
Nitin, I pulled an all-nighter. Didn't even get in bed last night. |
|
Thanks |
|
Mary, rebuild |
| Jorge Segarra (@sqlchicken) |
yes Mary, you can parition on existing table. It doesn't change the table physically , partitioning is simply a logical boundary to which you separate data at |
|
I understand. Just pulling your leg. Dont be offended |
| Ari Weil (@aweil) |
@Mary, yes |
|
where can I down load this webcast?  |
| Jorge Segarra (@sqlchicken) |
i think i have that right |
| Vince Amyotte |
he neglected to say which bar he was at |
| Ari Weil (@aweil) |
@Mitch, http://www.questkb.com/live |
|
Jor-GEE, rebuild! |
| Jorge Segarra (@sqlchicken) |
@mitch this webcast will be on demand for a month at http://www.vconferenceonline.com/shows/spring10/quest/conference/ondemand.asp |
| Jorge Segarra (@sqlchicken) |
ah thanks Kevin, my apologies |
|
Is there a link that can guide me or anyone interested, for applying an already existing huge table? |
|
I can't stay after this presentation but wanted to thank you guys for all your hard work, and to Quest for providing this....great job |
|
JK, SQLChicken, just a preference on my part not a requirement |
| Jorge Segarra (@sqlchicken) |
for the record i havent done partitioning in practice yet |
|
Does Partitioning work on developer edition? |
|
|
Mitch, the recordings will be available from today until 30 days hence. |
| Ari Weil (@aweil) |
@nitin, yes |
|
This is going back a bit, but is there a index defrag script for SQL 2000? |
|
does anyone know the answer to my question above |
| Jorge Segarra (@sqlchicken) |
@christine read up on paritioning here http://sqlserverpedia.com/search/?search=partitioning |
|
how do i partition a already available table |
| Ari Weil (@aweil) |
@Rudy, yes, check www.sqlskills.com |
| @christinaleo |
@christine quan - you can partition on fields other than datetime datatype |
|
thx Ari |
| Ari Weil (@aweil) |
@nitin, check out sqlserverpedia.com and search for partition script |
| Gareth (@GarethSwan) |
Hey, I know that server, too !!!! |
|
Kevin, I have rebuild indexes that were fragmented (based on the DMV view). After rebuilding them them they still showed as being fragmented. I am not sure exactly how many pages the index had but some indexes were fairly large. |
|
socket to me |
|
Christine, you need to set a partition "range boundary". It need not be a datetime |
|
thanks. |
|
did the sound just go funky for you guys? |
|
yeah |
|
indeed |
|
sure did... |
|
yes |
| Laura Krantz |
funky sound |
 Brian Dill |
yes sound is weird |
|
wow, evil sounding |
| Colin Smith (@Smithco32) |
wow the sound is like a slow tape |
|
Yeah |
|
was hot... |
|
LOL |
|
love it... |
|
it just went awesome for me. |
| Jorge Segarra (@sqlchicken) |
ummm is the audio getting garbled for anyone else? they sound like they're being possessed by demons |
| MaryMyers |
sound funny - yep |
|
yea Satan interrupted us. |
|
yep, I hear someone else talking too |
|
sounds like Max Headrum |
| Bob McLaren |
YES! Satan voice |
| Jonathan Gardner |
yeah |
|
Yeah, funky |
|
they need to fire their DJ |
| Stephen Dyckes (@SDyckes) |
the doctor must be Dr Jeckyll |
|
i kinda like it this way |
|
like there's another sound source too |
| MaryMyers |
it was evil |
| Tony Franklin |
Are you getting lagging sound? Is Brent the devil? |
|
...and I thought it was for real... LOL |
|
That is the devil chanelling through BrentO |
|
Weird sound Possessed? |
| Kimberly StJacques |
wow |
|
hahaha, i thought it was just me |
|
refresh |
|
that's better |
|
Table partitioninig is 666 |
| Jorge Segarra (@sqlchicken) |
THE POWER OF SQL COMPELLS YOU! I NEED AN OLD DBA AND A YOUNG DBA! |
|
Yeah, audio is out |
|
Sounds like a record running a slow speed. |
|
I did, didn't help |
| @JMurphyd |
dr evil |
| Tony Franklin |
Quick Kev throw holy water on Brent!! |
| Bob McLaren |
all better now |
| MaryMyers |
now better |
|
that was fantastic. |
| Eli Weinstock-Herman (@tarwn) |
refresh fixed audio |
|
audio is ok now |
|
Dr. Evil? |
|
Now it's better. |
|
The browser refresh fixed the sound. |
|
no it is |
|
Yes now |
|
we need a SQLexcorsist |
|
os now |
|
its better now |
|
ok now |
|
yep |
|
yes audio is better |
|
we're good to go.. |
|
before the end of the session, Brent should yell: "21 Jigowatts!?!" |
|
ha ha |
|
OK now |
| Jorge Segarra (@sqlchicken) |
it is ok |
| Colin Smith (@Smithco32) |
sound is fixed now |
| Karthik Yella |
refresh fixes the sound |
| Jonathan Gardner |
yes |
| Kimberly StJacques |
I think this segment should be called 'SQL Gone Wild' |
| Gareth (@GarethSwan) |
Just refresh !!! |
|
1 Billion Dollars |
| Jorge Segarra (@sqlchicken) |
This space...is clear... |
| Nick Weber (@Toshana) |
Even though partitioning has been around for awhile in Oracle for some reason it was never used at my place of employment untill the SQL folks suggested they partition a table with 10+ yrs of SAP data and they were shocked by the preformance improvement. |
|
didn't work for everyone, including me, until brent changed something |
| @JMurphyd |
smells like bacon.....musnt eat kitty |
|
BrentO sounded like when I was a kid a my 10 year old friend dropped my GI Joe in the swimming pool. |
|
When would you want a heap? |
|
Can you cite a valid case for a heap? |
|
what is a aligned partition and its usefulness! |
| Jorge Segarra (@sqlchicken) |
Get your heap learn on: http://sqlserverpedia.com/wiki/Heaps |
|
I've got a steaming heap right here. |
|
Mary, an easy example is a very small look up table, say one showing the postal code for all 50 US states. SQL Server will always do a full table scan for tables that small, so there's no reason to put indexes on it. |
|
a heap for a logging table? when it's just inserting only and rarely purged? |
| Jorge Segarra (@sqlchicken) |
@ram partition alignment is teh awesome and gets you 30-40% performance improvement |
|
Thanks Kevin |
| Jorge Segarra (@sqlchicken) |
Read @paulrandal 's post on finding the partition alignment: http://sqlskills.com/BLOGS/PAUL/post/Using-diskpart-to-check-disk-partition-alignment.aspx |
|
SQL can't defrag a heap I think. |
|
Jorge, that kind of partition is different than what we're talking about. |
|
You're talking about disk sector partition alignment, not database partitioning. |
|
@sqlchiken, i see something in the DTA - aligned partitions - what actaully the DTA suggests on this? |
|
Aspiring Geek has lots of info on diskpar |
| Jorge Segarra (@sqlchicken) |
@kevin, someone asked about partition alignment. Thought they meant disk. Either way here's teh SQLCAT whitepaper on alignment: http://sqlcat.com/whitepapers/archive/2009/05/11/disk-partition-alignment-best-practices-for-sql-server.aspx |
|
UUUh... a kitten will get killed! |
|
yesssss |
|
no start |
|
Ok, cool - thanks for answer all of their questions! |
| Jonathan Gardner |
RIP kitten |
|
you DO NOT need to have CMS configured for the multi-server query...you can do a multi-server query from a simple server group in SSMS |
|
Not more kitten deaths... stop the madness! Have some bacon instead! |
| Phil McCracken |
I think Kevin needs a lazy boy recliner |
| Jorge Segarra (@sqlchicken) |
@chris CMS is helpful as you don't have to keep re-registering all yoru servers on different SSMS installs |
|
you can rebuild the table in 2008 removing forward pointers though (also rebuilds nonclust idx's) |
|
@jorge, yes...cms helps but isn't required |
|
whatever keeps him awake |
|
Should we report Kevin to the SPCA? |
| Colin Smith (@Smithco32) |
so then the answer would be to goup the servers? |
|
I need a RedBull! |
|
@Kevin, have some bacon instead |
| Jonathan Gardner |
One per execution of a Select * |
| The Man |
lets just take his bacon |
Artem Ervits's username is changed to Artem Ervits @dbist.
|
but since it is done on the folder level, and theres 10 Servers underneath that folder, that's SELECT * against 10 servers right? 10 kittens? |
|
lol |
| Phil McCracken |
I hear it "has wings" |
Dandy Taylor's username is changed to Dandy Taylor (DEVHermit).
| Jorge Segarra (@sqlchicken) |
ill be damned, thanks for heads up on local registered groups @chris |
|
Brent, I want somebody's brain to explode please say "THERE ARE NOW 20 REASONS WHY ACCESS STILL SUCKS ' |
|
how can I install CMS? |
| Jorge Segarra (@sqlchicken) |
now i have to update my policy-based mgt talk lol |
| Phil McCracken |
Lo |
|
Can I have my kindle? |
| Karthik Yella |
I Love Dr Brent of all the Dr's i visited bcos he is not charging anything.....free service |
|
it is installed automatically Johnny |
|
Can I plug the book I'm currently writing? Called "SQL Server DMVs in Action" |
|
you just need to register one SQL 2008 as CMS |
| Phil McCracken |
yes, when do we all get our kindles? |
|
Can I have my kindle? |
| Jorge Segarra (@sqlchicken) |
@johnny if you have a SQL 2008 server installed in your environment and you have SSMS 2008, click on the registered servers tab. Right-click Central Management Servers folder and click on Register CMS |
| Bob McLaren |
QUESTION: If I only have one physical disk to put my tempdb files on, should I still split up the files for my 4-CPU server? |
|
Ian, where can you get that book? |
|
q: is there any rule of thumb on the amount of traffic on tempdb for snapshot isolation level? is this isolation level recommended? |
|
can I have your kindle too |
| Jorge Segarra (@sqlchicken) |
@johnny connect to your SQL 2008 database and click OK. That server is now considered your CMS. EASY! |
|
Bob, probably not. |
| Ari Weil (@aweil) |
@Bob, yes! You're avoiding latching the PFS tables, not going for IO throughput on spindles |
|
www.manning.com/stirk It has lots of useful performance/troubleshooting DMV code. The first 4 chapters are available now... |
|
Oooh, thank's Ari |
|
@Brent: how do you handle partition disk names when you run out of alphabet letters for drives? |
| Jorge Segarra (@sqlchicken) |
Partition Alignment whitepaper: http://sqlcat.com/whitepapers/archive/2009/05/11/disk-partition-alignment-best-practices-for-sql-server.aspx |
|
James May, the guy from Top Gear? |
|
Did he really say DOS prompt??? Command prompt please. DOS is dead |
| Ari Weil (@aweil) |
@Artem, sure, it's worth a shot! Tell us how it goes... |
|
Do I need to align my disks for windos 2008? |
| Jorge Segarra (@sqlchicken) |
@Daniel no Windows 2008 automagically does it for you (and the peasants rejoiced) |
|
Would disk-sector alignment apply to a SAN, say an EMC san? |
|
Daniel, not for Win 2008 or later |
| Jorge Segarra (@sqlchicken) |
you only need to manually align partitions on Windows 2003 or lower |
|
@Artem hehehehe... no Jimmy May from MS |
| @JMurphyd |
Also see Windows Server Administrators Pocket Consultant by William Stanek |
|
@danile windows 2008 partitioned disks are automatically alinged |
|
Must be Sprint |
|
Stephen, in many cases yes it does apply to SANS |
|
Not always, but usually |
|
HAHA the Tool Time reference. |
|
Long live DOS! |
|
What if I use SAN disks and move the LUN to a server 2008 from a server 2005 |
|
right... |
|
will that sector alignment save diskspace as well (due to efficiency), or does it only improve performance |
|
thx |
|
how can you tell if your storage is already aligned? |
| Carm Vecchio |
so is alignment destructive? |
|
Benjamin, there's compression for that |
| @JMurphyd |
how would one go about aligning disks on SAN? |
| @JMurphyd |
how would one go about aligning disks on SAN? |
|
|
Also I believe you have to do the disk partition alignment prior to putting data on the disk or SAN drive |
|
look in disk managment Kevin |
|
Nice, Ari has Mic now. |
|
Is there a way to test if your alignment is off? |
|
Miladen u use UNC paths |
|
Video is frozen |
|
Phillip, read the white paper. The diskpar.exe command enables you to test and report on whether alignment is play or not. |
|
Hey DOC, I have ever-increasing transactional logs? currently backing up with truncate frequenctly then shrink according to BOL. anything better? |
| Jorge Segarra (@sqlchicken) |
@stephen check @paulrandal 's blog post on how to check alignment http://sqlskills.com/BLOGS/PAUL/post/Using-diskpart-to-check-disk-partition-alignment.aspx |
| Phil McCracken |
what name was that? |
|
Brent is the doppelganger for John Oliver of The Daily Show |
| Phil McCracken |
who's blog? |
|
@artem: thanx |
| @SQLJackal |
what is the pros/cons of using Mount Points?? |
|
That's a veeery dark side |
| Jorge Segarra (@sqlchicken) |
@phil he was referring to http://midnightdba.com for Powershell |
| @christinaleo |
so if there are already TBs of data on your SAN, and they're not properly aligned, then you're out of luck? especially if your SAN admin ignores you |
| Carm Vecchio |
thanks kevin |
|
Maurice, you probably have full recovery mode on without running regular transaction log dumps |
|
powershell script for disk partition alignment http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/03/01/getting-partition-offset-information-with-powershell.aspx |
|
Do not truncate your translog if you're backing up. You're destroying the LSN chain and you won't be able to restore. If you don't need translog backups, then set the DB recovery mode to simple. |
| Ari Weil (@aweil) |
though you may have some long-running transactions that aren't allowing your transaction log to be truncated if you're in SIMPLE recovery |
| Phil McCracken |
Blog or Article to "check" if you are out of aligment? |
|
is there a way to do the partition alignment on an iSCSI drive? it seemed that windows considered it to be a "dynamic" drive and there was no option to do that . . . |
|
Sweet. I only have 225ish TB of disks that have been migrated from other versions. Should be an afternoon project. |
| Feodor Georgiev |
dont shrink the database |
|
if we shouldnt truncate the log |
|
how should we reclaim space? |
|
don't shrink the bacon |
| Jonathan Gardner |
more kittens die when you shrink a db |
| Phil McCracken |
the bacon must not be lean, if it shrinks |
| The Man |
at least they are small ones
|
| @JMurphyd |
mmmm Kitty bacon |
| @christinaleo |
@nitinsalgar - check out Paul Randal's blogs on managing tlog size |
|
LOL |
|
shrinkage is bad...just ask George |
|
How about doing a backup of the tran log, and then shrink it (the log file not the datafile) to a manage-able size. Is that a good practice? 1:4 ratio for the Data and Log? |
| Phil McCracken |
I know, I hate it when my bacon is shrunk |
|
Yout tlog to data Ratio varies wildly with the type of DB. there is no one answer for that. |
| Jorge Segarra (@sqlchicken) |
@mary check out this article by Kimberly Tripp on how to best manage your t-log file: http://sqlskills.com/BLOGS/KIMBERLY/category/Transaction-Log.aspx#p3 |
| @JMurphyd |
ahh music to shrink bacon by |
|
Thanks Jorge |
| Eli Weinstock-Herman (@tarwn) |
if your transaction log is growing to an unreasonable size you need to figure out why it is growing to that size and solve root cause, otherwise it's just going to continue to expand when you least want it to (ie, when it is doing a lot of work) and your not going to have a good handle on your potential disk usage |
|
@JMurohyd, this think is Kevin's death kitten march |
| Tony Franklin |
Randomly shrkinging logfiles now by flipping to simple and back now..... bwah hahaha haaaa |
| @JMurphyd |
yuppers from the comfort of his lazyboy |
|
If you're frequently shrinking the log file then I think your disk isn't sized correctly. OR do more frequent backup logs to clear out the committed transactions. IF you don't need translog backups then set the DB Recovery to simple. Then you can issue a CHECKPOINT to flush out the comitted transactions. SQL does it automatically, but sometimes you have to add it to maintenance routines if it'snot doing it frequently enough. |
| Eli Weinstock-Herman (@tarwn) |
Simple still has trans logs |
| Eli Weinstock-Herman (@tarwn) |
and the right dev can blow those up in a heartbeat |
|
< wonders why MS put the shrink commands if we should be using them? |
| Eli Weinstock-Herman (@tarwn) |
emergancies |
| Eli Weinstock-Herman (@tarwn) |
emergencies too |
| Tony Franklin |
@ Eli all shrinkage is an emergency |
|
You probably still need to shrink once in a while, but the translog backups & disk size should be configured so you don't have to do it every day. |
|
My problem is when I reindex a table the log file grows and grows |
| Jorge Segarra (@sqlchicken) |
shrink has its uses but folks that dont understand the ramification of using it cause headaches that could easily be avoided |
|
I think that the chat is just as good as the vconf |
| Eli Weinstock-Herman (@tarwn) |
@Tony Agree, i wish it was far more painful to shrink, known too many companies to use it as a fix-all instead of actually fixing the issue |
|
is moving to 14 disk Equalogix iSCSI - one RAID 50 array (will host all user 's DB's/Log/Tempdb) - good or bad? |
|
@Jorge: yes your right. Then when the DB has activity and auto-grows it slows the applications down |
|
thanks for a great webinar |
| Charles Hunt (@charlezhunt) |
@Zak i hope you're backing up to an alternate location |
| Nick Weber (@Toshana) |
@Zak, you can use iSCSI for databases but I would not typically recommend it |
| Tony Franklin |
Grrrrrr now I have a meeting in the last hour......... &%$#@*&%^%$%% |
| Karthik Yella |
@Zak: having both the data and log on a single array is not advisable.... |
Andrew Saalmann's username is changed to @saalmann.
| Nick Weber (@Toshana) |
@Zak if you have to use iSCSI Equalogix break the disk up to seperate luns, data, log min |
| Jorge Segarra (@sqlchicken) |
@zak like the others have said, iSCSI not the greatest for SQL plus putting all your DBs/Log/Temp db on same spindles will just cause IO contention |
The Man's username is changed to LA Jack.
|
it's 4:03 do you know where the schwag is |
|
what do you guys do when san admins don't want to create separate luns for storage? just hope san software will figure things out? |
|
ok, i'll bite. what's the new big gotcha for shrinking a db? |
| Eli Weinstock-Herman (@tarwn) |
@dbist yep, brent is drop tetsing it |
|
If this session would have been held before PASS it would have been at lot easier to win at twitter bingo. I still recognise the twitter names and feel like I am getting to know everyone a little better. |
|
@anton You have the san admin conveniently disposed of. |
|
|
|
Thanks for all the input. The current designed LUNs are smaller (less disks) and we are having heavy disk i/o. will plan on physical partition of data and log instead of logial. |
| Nick Weber (@Toshana) |
@anton it all depends on the SAN some SAN's like Xiotech use all the spindle in a custom raid setup. Since I also work on the SAN team I had to educate others why I needed the spindles seperated. |
|
kinda like kittens |
| Karthik Yella |
@Debbi,Shrinking causes fragmentation |
|
can someone explain little bit more about how to analize DMV query to show procedure cache |
|
when SAN admin refuses to work with you, run a tool like PAL, create a report and convince him/her of disk bottlenecks. |
| Vince Amyotte |
what is the PAL tool? |
|
Performance analysis of logs |
|
true but after shrinking - rebuild indices. of course that's only if there was alot of space freed up |
|
google it |
| Nick Weber (@Toshana) |
it's on codeplex |
| Jorge Segarra (@sqlchicken) |
@zak check out @paulrandal 's blog post on benchmarking a 1 TB database. Yes most of ours arent that large but basics still hold true: http://sqlskills.com/BLOGS/PAUL/post/Benchmarking-1-TB-table-population-(part-1).aspx |
|
PAL is a free tool on Codeplex that you can use to analyze a perfmon log |
|
Start with education.... There are lots of reasons they will come around. |
| LA Jack |
 |
| Kevin Lasky |
nothing worse than a fragmented kitten |
|
thanks. education and kittens it is. |
| LA Jack |
gone |
|
@Brent, is there a Quest tool for index defragmentation? |
|
the video and audio disappeared |
| LA Jack |
back |
|
Brent just got downgraded on laptops |
|
no video or audio |
|
....and yes, I am refreshing |
|
they should show their conferences in 3D |
|
i'm sad that no one is dressed up in this session |
|
no video and audio, refresh, but still do not have it. |
|
does anyone know of a good tool for data load? to test new h/w. |
|
@anton, IME, SAN Admins look at DBAs the same way that some DBAs look at developers. We consume a lot of resources and they think they know the best way. Get to know them, treat them less like adversaries, and you can get a lot more leeway out of them. also, showing them proof always helps. |
|
whoever designs their GUI should be fired. |
| Jorge Segarra (@sqlchicken) |
@zak try SQLIO, here's a tutorial: http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO |
|
thanks |
| Jorge Segarra (@sqlchicken) |
nosounds |
|
profiler can also benchmark old and new hardware |
| Colin Smith |
@jorge great link and @Brento is awsome for doing the SQLIO post. I know I have used it and my boss loved the results. |
| Brent Ozar |
It's very configurable, Mladen. But a lot of people love it. |
|
still no vedio and audio, anyone else has the same problem? |
|
me either |
|
Yes |
|
Keep refreshing! |
| Jorge Segarra (@sqlchicken) |
@hongmei refresh the page |
| Colin Smith |
@Hongmei refresh |
|
yeah, I've got not video or audio |
|
Yes same here |
| Brent Ozar |
KK> Anyone have sound? |
|
if Apple would've designed it, it would only have one button |
|
I did refresh |
|
even after refresh |
|
I can see and hear |
|
even after refresh |
|
i think one of the biggest issues is a convinience factor. having one lun gives you more flexibility in assigning storage space to servers |
|
me 2 i did refresh and nothing |
| Colin Smith |
I can see and hear as well |
|
I did refresh couple times already. Will wait much longer I think. |
| Jorge Segarra (@sqlchicken) |
@artem and it would be "magical" and "whimsical" and "change your life" |
| Jorge Segarra (@sqlchicken) |
no sounds |
|
it works fine |
| Jorge Segarra (@sqlchicken) |
keep refreshing the page @ahmed |
|
no video |
|
Took about 6 refreshes for me earlier |
|
no sound |
|
@brent. the colors are killing me. the data given is great! |
|
no sound or video for me, refreshed 5 times so far |
| Laura Krantz |
I have video or sound after many refreshes |
|
in spotlight, can i see all my logical HDD partitions in the windows piece? i think it is limited to 8 |
|
no sound and no video too |
|
close the page and reopen |
| Karthik Yella |
Need to head out for a meeting....thank you very much Brent ,Kevin and Ari |
|
@anton it all depends on how you use your environmnt. we have lots of cloning going on in our environment, so one lun for all DBs would definitely not work here. |
|
had sound and video, then it went blackout - nothing |
| Kevin Lasky |
my mouse is getting pissed at all the refreshing... gonna feed it to the kitten soon |
|
still no luck. Maybee it's a sign that I should go to bed. It's 10PM here |
|
the same |
| Brent Ozar |
KK> Thanks Karthik'! |
|
no audio |
|
Stll no sound or video and yes F5 even yet again |
|
no video |
|
hi i am not able to see the video |
|
Brent, I have rebuild indexes that were fragmented (based on the DMV views). After rebuilding them they still showed as being fragmented. I am not sure exactly how many pages the index has but some indexes were fairly large. |
|
new browser, same issue |
| Brent Ozar |
KK> Johnny, refresh please |
|
nothing... I close and open another window |
|
no audio nor video. |
|
tried everything no sound and no video at all |
|
No video or sound. Refreshed dozen times. |
|
refresh is not working |
|
did it work before |
|
fresh, close and opened didn't work here either |
|
refreshing isn't working |
| Brent Ozar |
KK> Zak, up to 8 in the main window and as many as you want in the drill-down window |
|
gggg. |
| Kevin Lasky |
where's the mod? why was i kicked out? |
|
refresh does nto work, try at least 10 times. Try to close and re-enter webcast, still no luck yet. |
|
Sorry about the audio/video problems! I wish we had a quick fix for you guys, but check the links at the bottom of the screen for help. They connect you to support. |
|
reboot? |
|
Still working great here!! |
|
i closed and opened a new browser and also have refreshed and still not video |
|
no audio & Video.. |
|
Close and reopen still no video |
|
thank. can i choose which logical i want on the main screen? |
|
don't rub it in jolene |
|
still no vedio and sound. |
|
somebody call 911 |
|
still working fine here |
|
working fine for me |
|
Also working fine. |
|
no video or audio |
| Neel Paudel |
not for me as well. |
|
click on the "session room" to reconnect. |
|
Im in East Coast USA & not working |
|
not working... |
|
What is that Performance Analysis tool? Those are not in the SpotLight tool? |
|
Folks - if you don't have audio or video, we can't fix it in here. On the browser window where the video should be, there's a link for problems with the audio/video. Click there. |
|
the same me... east cost... |
|
no woring. |
|
try everything, still no vedio and audio. |
|
just lost it |
|
Mary - this is Spotlight. We'll show Foglight Performance Analysis later. |
|
Performance analysis is a seperate product. |
|
me too just lost it all |
|
now its lost |
|
I just lost it as well |
|
er.. no working, I'm just north of you guys in Utah |
|
No video and audio for me either |
|
just lost - virginia |
|
back |
|
back |
|
refresh worked for me |
|
just came back up |
|
Central Zone. Just lost both! Woops it is back! |
|
now is back |
|
got the video and audio now |
 LeelaKrishna Kanikicherla |
Any luck |
| Colin Smith |
refreshed to get it back |
|
finally get it back.. |
|
Vedio lost |
|
We didn't here the last 30 sec
|
|
back after refreshing |
| LA Jack |
back utah |
|
or so |
|
I have video and sound back. |
| Laura Krantz |
working here now |
| Kevin Lasky |
@Brent... can you type a live transcript and provide all slides here while the video/audio isn't working?  |
|
back |
|
no video, no sound |
|
back |
|
Seems they need more bandwidth before the next virtual conference ... |
|
where's the session? |
| LeelaKrishna Kanikicherla |
 still no luck |
|
back |
 David Postlethwaite |
I have it back |
|
back |
|
I do too- closed down I E and opened in chrome |
|
can we rewind a min ? |
|
move to East Coast? |
|
I agree Tony! |
| Jorge Segarra (@sqlchicken) |
Since it hasn't been mentioned in awhile, reminder to everyone that slide decks and resources can be downloaded at http://questkb.com/live/ |
|
back now |
|
what OS is that netbook running |
|
Refresh and it back |
|
Artem - my netbook's running Windows 7 Ultimate. It's a temporary one though - I'm giving this one away.\ |
|
@Artem, DOS...lol |
| Colin Smith |
My money is on Hackintosh |
| Colin Smith |
I run Win 7 on my netbook and I love it |
|
its back for me, i am using IE |
| Jorge Segarra (@sqlchicken) |
@colin its a Macbook Pro running a VM |
|
how much RAM is left for OS after antivirus is running |
|
I'll announce it in here before we say it on the webcast - I'm giving this netbook away to US residents who come up with the highest-voted #SQLServerPediaTraining tweet as rated by users on http://buzz.sqlserverpedia.com! |
| Jorge Segarra (@sqlchicken) |
HOLLA! |
|
Tell us what you thought of our training, like "#SQLServerPediaTraining was better than sliced bacon!" |
| Laura Krantz |
does it come with stickers? |
|
Jorge should win! |
|
Is there any way to stop this chat window from auto-scrolling ? I'm trying to read the past comments, but it keeps going to the bottom when a new comment is added. Annoying. |
|
US only...booooooooo |
|
You can vote for yourself, too. |
|
nevermind. Right-click. Auto-scroll. Duh. |
|
he deservers a netbook, I deserve a kindle |
|
Hey Brent, are there downloads for Kevin's sessions this morning? |
| Jorge Segarra (@sqlchicken) |
haha nice @artem I like your thinking |
|
so wait if I tweet #sqlserverpediatraining I am entered to win? |
|
wait, Windows 7 Ultimate on a netbook? That's not even enough RAM to run a screensaver |
|
@Artem yep, if you're a US resident and people vote your #SQLServerPediaTraining tweet the highest. |
|
@Paul not yet, but should be within a few days. |
|
good luck with that |
| Colin Smith |
Windows 7 ultimate runs better on my netbook than XP did when I bought it. I have upgraded to two Gigs but that was well after I installed Win 7 |
|
tyvm |
|
interesting |
| Colin Smith |
I had Hackintosh, Win7, Ubuntu all running for a while with a tripple boot. That was fun |
|
Whew. Restarted IE and got the video back. Luck I did not miss Brent saying anything. |
|
@M heh |
| Jorge Segarra (@sqlchicken) |
@brent how do you add stuff to buzz? |
|
That would be "yakkity sax" |
|
@Jorge it automatically imports tweets, blog posts, etc every X minutes. |
|
buzz pulls from twitter automatically when you add twitter account |
| Jorge Segarra (@sqlchicken) |
oooh fancypants mr ozar |
| Jorge Segarra (@sqlchicken) |
@artem, he's talking about Buzz at sqlserverpedia. They stole the name lol |
| Jorge Segarra (@sqlchicken) |
|
umm patent infringment? |
|
@Artem I had a product named Buzz a decade ago. |
|
what patent? |
| Rob Kalkman (@whois101) |
He's talking 'bout us! |
| Jonathan Gardner |
So what you are saying is it is our fault |
|
I'm somebody! yay! |
|
@brento you should sue Google for sharing your name |
|
i mean buzz |
|
@BrentO drug users were using it before me. |
|
The #SQLServerPediaTraining tweets are already so funny that it gives me another idea - we'll print the top few of them on our next round of Twitter shirts! |
|
examples? |
| Eli Weinstock-Herman (@tarwn) |
Wow, did you hear the pause in his voice before he said developer? |
|
ghetto mac |
|
Our developers don't want to know how to make the app better |
|
salam |
|
Why is it that there are some occasions wherein Spotlight shows high CPU usage, but when drilling down on which process has the highes CPU time, it shows 'LAST COMMAND' is "RESOURCE MONITOR" and it's sleeping? |
|
Damnit! What if I'm not a tweeter? |
|
hmmm so i dont even need to type in anything, i am from london |
|
I'm no twitting tweet. |
|
Philip, sign up for a twitter account just to enter. |
| Jorge Segarra (@sqlchicken) |
lol @philip, sign up for Twitter its free and def worth it as the SQL community on there is top notch |
|
What other areas that can be looked out to find out the shooting gun? |
|
Twitter...like we don't have anything better to do. |
| Jorge Segarra (@sqlchicken) |
Using the #sqlhelp tag alone is worth its weight in gold in starting out using Twitter |
|
exactly David |
|
Tweetheplanet |
|
@David: Buy some of this handy Quest software and that could be true! |
|
what if I don't tweet? |
|
If you're not a Twitter user, I agree with @Jorge - that #sqlhelp tag alone is so helpful. |
|
here is a live proof that mac is not good to run windows |
|
If you don't tweet, you can't win. |
|
it's very slow... |
|
twitter is rightfully blocked @ my office. |
|
what is "#sqlhelp" |
|
@Johnny I wasn't running Windows - that's OSX. It wasn't good enough to run LogMeIn.com, oddly. |
|
Ari, did you speak to the ever-increasing transactional log - log-hell? without shrinking? |
|
@Christine go to http://questkb.com/live and there's a link to SQLHelp info. |
|
already did. You can't trust Quest. They're like a drug dealer. Give you a bunch of trial licenses, get you hooked then threaten to cut you off. =) |
Richard Garrett's username is changed to Richard Garrett (@NotCranium).
| Jorge Segarra (@sqlchicken) |
Check out my blog post on why Twitter can help you out at work: http://sqlchicken.com/2009/12/real-world-value-of-twitter-at-work/ |
|
It's like - Beer for everyone - ........if you live in Denmark, Vejle, Grejs (my town) .bla bla bla. HAte this |
|
Can we have a representative demo on-site or protype or just free demo does this allow for t-shirts ) |
|
@David your first hit is free. |
|
@Annette I'm not sure what you mean about t-shirts? |
|
then use remote desktop in mac |
| Jorge Segarra (@sqlchicken) |
Ahhh Foglight for SQL Server...*SNORRRRRRRT* #SQLSERVERPEDIATRAINING |
|
Johnny can't do that when the servers are in another state behind firewalls. |
|
also you can use VPN with remote desktop |
|
@Brent, I can't find sqlhelp on that link |
|
@Johnny only with a VPN router on the other end. I appreciate your enthusiasm to help, but trust me, I've been there. |
|
I just had 3 quest peeps at my site this morning. |
|
@Christine it's here - http://www.brentozar.com/archive/2009/12/i-need-sqlhelp/ |
| Jorge Segarra (@sqlchicken) |
@christine if you want to learn about #sqlhelp check out http://sqlchicken.com/2009/12/need-sqlhelp-throw-up-the-bat-signal/ |
|
thanks |
|
i use mac with VPN and remote desktop now... i try everything else without success |
|
BrentO, like the racing car on the book! F1, F3 or Mazda lite? |
| @christinaleo |
|
@Johnny agreed, got a $400 VPN router at home waiting to be configured. |
|
thanks |
|
hey Brent, did you drop the netbook also? |
|
Goodnight everyone - been a nice training - very usefull. But I have to get up erly in the morning so have to watch the recorded remaining sessions. Take care of the kittens |
| Vince Amyotte |
ive been trying to get IPSecuritas working for my client software to get into work. |
| Jonathan Gardner |
audio drop |
|
juniper Brent!! |
| @christinaleo |
@Maurice Ray: THis is very good too: http://www.sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-1-Running-out-of-transaction-log-space.aspx |
|
Is it #SqlPedia in twitter ? |
|
appreciate it!! thankx |
|
#sqlserverpediatraining |
|
that's a long hash tag for a 140 character field |
|
thanks Artem |
|
@Artem I gotta be honest - maybe it's getting late. Maybe I'm a little punchy. But I get the feeling that you complain a lot. |
|
it's getting late |
|
interesting thing about buzz.sqlserverpedia.com, the sorting is less than desireable |
|
but a great concept, I like it |
|
can I get a free book ? |
|
@Allen that's great feedback - shoot me an email at brent.ozar@quest.com with your thoughts. |
|
@Johnny we're giving way books to random US resident registrants tomorrow. Good luck! |
David Mathein's username is changed to Dave.
| Rob Kalkman (@whois101) |
Actually, it is a pretty good book, but it takes me a few more hours than he's talking about |
|
@brent thanks for a phenominal day of free training. It was far better than I had expected for free - in fact it was better than some of the training I have paid for. Too bad my team mates did not opt to get up at 4:30 in the morning to attend. |
|
do I need to twiter?? I don't have time for that... |
|
@Rob Ari's a voracious reader. We're all psyched that we got Kindles - we carry around several books at a time!\ |
|
@Laura cool, glad you liked it! That's great feedback. |
|
@Brent its truely unfair, we guys too deserve something besides the nice share of knowledge in the presentation |
| Jorge Segarra (@sqlchicken) |
@laura that's awesome of you to have that kind of dedication. |
|
@Suleman er, what? |
| Jorge Segarra (@sqlchicken) |
@suleman its not brent's choice, is Quest. Its cost-prohibitive (and probably laws issues) with shipping overseas |
| Rob Kalkman (@whois101) |
@BrentO - that's the way to go |
|
@brent, like books or take aways from the session, ( i am from london ) |
|
@sqlchicken well with the budget cuts there is no paid training this year so you have to do what you can to learn what you need to do your job more efficiently or you end up spending more time doing it. |
|
I agree with Laura great free training for nothing |
|
lol i really wish you guys had a session here too |
|
@Suleman okay, I'm sorry that we couldn't give you free stuff too, BUT hang in there - if you attend our events in London, you can win swag! |
| Vince Amyotte |
is the Performance Analysis for SQL Server that is being diplayed the Froglight Performance Analysis? |
| Jorge Segarra (@sqlchicken) |
@laura have you attended a http://sqlsaturday.com before? GREAT free training put on by local user groups |
|
@Vince yep, absolutely! My favorite Quest product. |
|
it's two different apps Vince |
| Rob Kalkman (@whois101) |
@BrentO Would it work faster if I put the Kindle under my pillow at night - I'm kinda short on time during the day |
|
Brent a last Q from me: To nail down the high CPU usage is it better to use DMVs or Extended Events? The reason is, I asnwered DMV / Profiler once on web and I was wrong. I read someting bt Ext.Events on web, but it is not as easy as using DMG, pls advise. |
|
Performance Analysis of Logs is a free tool on CodePlex |
|
@sqlchicken unfortunately I am sacramento, ca and we don't have a sql user group out here. |
|
@Ram either of them can work well. |
|
@Artem that's a different tool, obviously. |
|
will this slide deck be available on http://questkb.com/live/? I don't even see an entry on that page for Ari's 4pm section |
|
Laura I'm in sacramento too! |
|
@Laura, if there is not a SUG in your area, start one!! |
|
@Keith yes, you bet! It'll be there in a couple of days. I'm super-anal about having mine up ahead of time but these other guys work too hard to do that ahead of time. |
| Vince Amyotte |
Thanks for the replies. |
|
@annette cool - I was on a site where someone had talked about trying to start one but, it was a lot slower going and harder than he expected. |
| Jorge Segarra (@sqlchicken) |
@laura start one up! http://www.sqlpass.org/PASSChapters/BecomeAChapter.aspx contact Blythe Morrow. Or check out the Virtual Chapters http://www.sqlpass.org/Community/VirtualChapters.aspx |
 @nitinsalgar |
@laura there is one in bay area http://www.baadd.org/ |
|
@nitinsalgar true but, I live 3 hours from the bay area (i'm actually an hour away from sacramento) can't get the time off to go to the meetings htere. |
| Jorge Segarra (@sqlchicken) |
All PASS Chapters (worldwide): http://www.sqlpass.org/PASSChapters.aspx |
| Jorge Segarra (@sqlchicken) |
@laura you should get with @annette and start up a chapter |
|
@Brent, @Ari, @Kevin, Does it make sense that CPU usage can spike high and spotlight points to RESOURCE MONITOR, which unfortunately, doesn't show any much. |
|
| @JMurphyd |
Is there anyone signed on that is interested in a newly forming study group to prep for SQL MSTC exams ? |
| Jorge Segarra (@sqlchicken) |
| Vince Amyotte |
I think I can hear Kevin snoring in the corner.. |
| LA Jack |
That's the kittens |
|
How long will the links exist on www.questkb.com/live |
| @saalmann |
Brent this is fantastic training and free to top it off, is there any chance that this kind of training will become a monthly thing? |
|
great.. Tks!! |
|
@LA Jack kittens? |
|
can you size the proc cache in 2008? |
|
@Brent @Ari @Kevin Great session , i have enjoyed all the sessions, i use spotlight in my company... |
|
Pain of the week |
|
Yes I think I will |
|
This has been terrific! Thank you very much! |
| LA Jack |
I meant all - sorry; Kevin snoring in the corner |
| Charles Hunt (@charlezhunt) |
What @Suleman said! |
| Jorge Segarra (@sqlchicken) |
@saalmann there's monthly free training by the PASS Virtual Chapters http://www.sqlpass.org/Community/VirtualChapters.aspx or check out http://sqllunch.com |
|
This is great! Thanks! |
|
so far this has been a very interesting session |
| Jorge Segarra (@sqlchicken) |
POTW webcasts are awesome |
|
Thank you so much for all the great tips |
|
this is great!!! Thanks! Thanks!!!!! |
| Colin Smith |
Thans you guys so much for doing all this. I learned a ton and now I have a ton more to go learn. Thanks again |
|
How long will http://questkb.com/live/ stay up with info from today's sessions? |
|
Sure |
|
I have enjoyed all the Quest web casts I have seen so far! |
|
Thanks guys... Now I need to go check on my kittens, and find some bacon. |
| Stephen Dyckes (@SDyckes) |
I wish I could have given my full attention to the experts today, I would have learned even more. Thanks guys! |
|
I've noticed execution plans are different on clusters than on stand alones. Its the same exact query, same hardware, a copy of the cluster dbs. Is there a reason for the performance variance? |
|
keep up the good work guys! |
|
Great stuff guys-- any chance you guys will offer free tools for MCTs? |
| Jorge Segarra (@sqlchicken) |
Pain of the Week webcasts: http://www.quest.com/backstage/pow.aspx |
|
Thanks for all the great info! |
|
I want to thank you guys for a great conference! I suggest that everyone - keep these guys fat and happy! I'm sending a coupon for pizza hut, I hope everyone does the same: here: http://www.pizzahut.com/BigEatTinyPriceMenu/?WT.mc_id=061509BETP_Wild_Card |
|
@Philip we do for MVPs, but not MCTs. |
| @nitinsalgar |
Virtualization VC training is awesome http://virtualization.sqlpass.org |
|
Gents - the training has been most excellent. Informative + Balanced + Real World + Entertaining = WOW! |
|
Zahid, workload the same? |
|
Please take a moment to answer the questions in our survey athttps://vovici.com/wsb.dll/s/37ccg435e5 |
|
I've noticed execution plans are different on clusters than on stand alones. Its the same exact query, same hardware, a copy of the cluster dbs. Is there a reason for the performance variance? |
|
Thank you guys for a great event. |
| @saalmann |
Jorge, thanks for the link, you seem to have a link for everything, how do I get a hold of that bookmard list??? |
|
Excellent event!! |
|
Great training guys! THANK YOU!!!! |
|
Thanks for a great training session guys - great job! |
|
Thanks so much. I got up at 4:20am to attend - and I'm very glad I did. Very useful to this "accidental" dba. |
|
Thank you for the webcast! Hope next time you can have more in-depth perf tuning training. |
| @christinaleo |
You guys rock! Thanks very much |
|
This was great. thank you |
| Jonathan Gardner |
thank you guys |
|
Thanks guys! |
| Vince Amyotte |
Awesome job on the training guys. Thanks for the great event! |
|
I've noticed execution plans are different on clusters than on stand alones. Its the same exact query, same hardware, a copy of the cluster dbs. Is there a reason for the performance variance? |
| Stephen Dyckes (@SDyckes) |
This Saturday in Charlotte NC, Can't wait! |
|
Can we get posters online without mailing ? |
|
Please visit the Quest SQL Server promotions pagehttp://www.quest.com/backstage/promotion.aspx for posters |
 Michael Deputy |
Thank you for an awesome event. |
|
Thanks |
| Kelly (@greeleygeek) |
Excellent excellent stuff. Thanks guyz! And thanks to Jorge for all the chat answers |
|
Can this chat script be available as well on the On-Demand site? |
|
This was great... Thank you |
| @nitinsalgar |
Kill a kitten one last time |
|
thanks you a lot |
|
This has been a wonderful event! I've learned a lot. Thank you! |
|
The slides will be available later at http://questkb.com/live - thanks![ProcessingInstruction] |
|
Super job today, thanks! |
|
Save the kittens |
|
Brent/Kevin/Ari - this is a great webcast. Always hated seeing Spotlight pages on my mobile. Not htat this webcast will change that. But now at least I know the different uses of the products. Thanks. |
|
The sessions will be on demand here from March 4 – April 3rd. |
|
thanks |
| Jorge Segarra (@sqlchicken) |
survey done |
|
Great job |
|
Thank you |
|
thanks guys that was great. |
|
thanks |
|
Thanks Stephanie |
|
Thank you for the great training! |
|
Thanks. |
|
Nice one, guys! |
|
Bye from Italy! |
| David Postlethwaite |
thank you |
|
thanx |
|
Excellent Job!!! |
|
Thanks |
|
Thanks, guys. It was a great day. Lots of good information. Brain hurts. |
|
very useful |
| Colin Smith |
I will just be waiting for my Kindle now, Thanks again |
|
awesome - thanks for the info overload |
| Rob Kalkman (@whois101) |
Thanks guys - I'll have to watch the presentations I missed from the recording. |
| Jorge Segarra (@sqlchicken) |
thanks |
| Rob Kalkman (@whois101) |
Thanks guys - I'll have to watch the presentations I missed from the recording. |
| Jorge Segarra (@sqlchicken) |
thanks |
|
Sorry, Colin. I think you're queued up for the broken one. |
| Jorge Segarra (@sqlchicken) |
id do a standing ovation but my coworkers would look at me funny (more so than they already do for a guy with a rubber chicken at his desk |
|
Thanks a lot everyone! Great webcast! |
|
Thanks! |
|
Thanks! |
| Jorge Segarra (@sqlchicken) |
Remember to right click chat window and save so you dont lose all links/info |