[Video] Office Hours 2016/10/05 (With Transcriptions)
This week, Brent, Richie, Tara, and Erik discuss their learning styles, Always On Availability Groups, memory leaks, windows updates, how to transition from developer to DBA, upgrading SQL server from 2008 to 2014, temp tables vs table variables, and how to become an MVP.
Here’s the video on YouTube:
You can register to attendnextweek’s Office Hours , or subscribe to our podcast to listen on the go.If you prefer to listen to the audio:
Podcast: Play in new window | DownloadEnjoy the Podcast?
Don’t miss an episode, subscribe via iTunes , Stitcher or RSS .
Leave us a review in iTunesOffice Hours Webcast 2016-10-05
Brent Ozar: We got a couple of early questions, or not really questions, but comments from folks. One person says, “Thank you for the set SPN answer last week. Robert Davis’ blogpost SQL Solider was great.” Totally agree. I love that myself, refer back to it all the time. Another person says, “Last week I asked about parameter sniffing issues and as you guys suggested, I’ve applied the update statistics and it worked for me. Thanks for your help.” Awesome. Glad to hear it. That’s very cool.
Erik Darling: Handy dandy. That will be 50 bucks.
Brent Ozar: Just hold your credit card up to the screen and then…Should I put 3 2TB databases on one server, or 3?
Brent Ozar: Upendra asks, “We have three critical databases and the total size of them is about six terabytes. Would you recommend putting all three databases on the same instance or breaking up each database onto its own instance?”
Tara Kizer: Are you virtualized? Because that might change my answer. If you’re virtualized, I’d probably split them up into three virtual machines.
Erik Darling: I’d probably split them up either way.
Brent Ozar: And why? What would be your guys’ concerns when you’re running databases of that size?
Erik Darling: Resource contention, locking. That would be a concern of mine with a database that size but not necessarily with keeping them on the same server. But yeah, resource contention mostly. One big giant table starts getting write in, buffer pool gets cleaned out from something else, so all of sudden just kind of fighting each other. Unless you have terabytes and terabytes of memory to make sure everything is cached when you need them, could be trouble.
Brent Ozar: I like it in terms of management for backups in CHECKDB too. Man, if you’re going to do a backup or a restore of a two terabyte database, that can be pretty tough, and other people on the same box will feel it at the same time you’re running backups or CHECKDBs. At this tier, it’s likely going to be Enterprise Edition. It’s likely going to be SQL Server Enterprise Edition so it’s going to be expensive when you say, “I want to break it out to multiple servers.” So start with that question around how long can we be down when this box goes down. If that answer is shorter than your time to restore, like if it would take you eight hours to restore all these databases, it’s time to start thinking about things like clustering or Always On High Availability.Is there any good documentation on Always On?
Brent Ozar: Which leads to a next good question. “Is there any good documentation on Always On High Availability?” Before I let anybody else answer, I just want to give you gold star for putting a space between Always and On. Look at you. I still do Always On as all one word myself. Microsoft keeps changing this stuff. So you guys, where do you go to learn about Always On High Availability stuff?
Tara Kizer: When I was learning it back in 2012 and 2013, I actually learned by doing it. Just implementing it. Starting in a test environment, dev environment and promoting it through the different environments. Working with QA and development, making sure that everything worked properly. I’m not even sure that I referred to any documentation back then. Maybe for some quick help but I’m a learn-by-doing type person.
Brent Ozar: Yeah. How about you, Erik?
Erik Darling: Same boat. There is not a lot of great documentation, at least for free, unless you work here. So I would say learn by doing. If there’s anything you can’t figure out, ask a question specifically about that on dba.stackexchange.com or something until you get a really specific answer because a lot of the documentation is pretty high level. That’s probably the road I’d take.
Brent Ozar: I think to some extent that’s probably something we all have in common too. When you have to learn new features as they’re just coming out, there just isn’t good documentation yet. You have to start playing around with betas. When Always On Availability Groups first came out in 2012, those of us who wanted it had to start playing with it as soon as the alphas and betas were hitting. There wasn’t a good Books Online. You had to go and do. Often, I’m the kind of a guy who given the choice between reading about it and actually trying to do it, I’ll go copy/paste me some syntax and start breaking around to see what happens. Richie, I know you’ve been having to learn stuff like crazy as we’ve been developing new apps. When you go to learn, what’s your style of learning?
Richie Rump: So you know, I don’t always go learning things, but it turns out that we have a nice blog called brentozar.com. Is that too upfront? No?
Brent Ozar: No.
Richie Rump: Even before I came and worked here, I was constantly on―not only our blogsite but also I actually picked up a couple of our courses. I love our courses. I think we’re some of the best in the business. I tend to do a lot of video courses so the Pluralsights and even some of the YouTube stuff because those kind of get to the meat of the matter. I can kind of passive listen to a lot of those things. As I’m kind of doing something else, email or whatever, I can kind of grok what’s going on. If I need to go back, I can go back. But that kind of gets you―hey, all I want is enough to get going. When I get going, if I run into other problems, then I could do the Stack Overflow or whatever but I just need to get started. The stuff on YouTube, but mainly Pluralsight and our site, brentozar.com, has been really helpful.
Brent Ozar: If you’re a developer out there in the audience, Pluralsight is a great investment, just the rapidity of how of how fast they bring out new courses. It’s also interesting that between the crew of us, I think Richie is actually the only one who likes learning via videos or likes learning passively, which is hilarious for me to say because we run a training company that sells videos. I love doing them and I know that a lot of customers enjoy learning via videos. I don’t like watching learning videos at all. They make my skin crawl.Erik Darling: May
本文数据库（mssql）相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库
本文标题：[Video] Office Hours 2016/10/05 (With Transcriptions)