Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX


Heard on .NET Rocks!: Kimberly Tripp on SQL Server : Page 3

Carl Franklin and Richard Campbell interview Kimberly Tripp to discuss SQL Server 2005 SP1 and more.

.NET Rocks! (continued)
Kimberly Tripp: It's critical data in a very short burst timeframe. It has to have massive transaction loads, yeah. I don't know of that specifically, but... Carl Franklin: But they basically did it with SQL Server and some serious hardware, probably like Compaq or HP hardware and they simulated the load that it would [take], based on the number of people who vote every year, which I guess isn't that many, but less than American Idol.

Kimberly Tripp: This week especially, because that was the finale of American Idol; they were talking about the fact that there were 64 or something million votes cast in the four hours. Carl Franklin: It's insane.

Kimberly Tripp: A lot of people vote more than once, so that's a little bit different than the national election obviously. Carl Franklin: Now, if we can do that and we are still [messing] around with dimpled chads in Florida, what the hell?

Kimberly Tripp: I know, isn't it bad? Richard Campbell: (Laughing)

Kimberly Tripp: People can vote via their cell phone. They can call in and that system in four hours can take 60 million votes, I mean, do the math on what the transactions per second is for that. Carl Franklin: Right. So, Mr. Bush if you are listening, Richard and Kim and me, maybe Forte and Miguel Castro, we can get together and solve this problem in probably a couple of days. Oh, maybe not.

Kimberly Tripp: From billable hours, let's actually make it a couple of weeks. Carl Franklin: Couple of months.

Richard Campbell: (Laughing) Carl Franklin: Couple—5 or 6 months, 7, 8 months; but it is amazing.

Kimberly Tripp: Okay, so that's 4444 transactions a second. Carl Franklin: Nyah!

Kimberly Tripp: 4000—that's pretty impressive. Carl Franklin: That is impressive.

Kimberly Tripp: 4444 transactions a second. Richard Campbell: That's like a TPM number in the quarter million range. That's, as big as they get.

Kimberly Tripp: Yeah that's pretty impressive. So, yeah, it would be interesting to know what the American Idol hardware is. Carl Franklin: Yeah it would, wouldn't it?

Richard Campbell: So, let's talk 64-bit. I love my 64-bit SQL Server. It's amazing. It's awesome. I have now got a 64-bit system running as a workstation. Kimberly Tripp: Yeah, but how much memory do you have?

Richard Campbell: Four GBs. Kimberly Tripp: Yes, see 64-bit on 4GBs is just—I don't know, it's...

Carl Franklin: Just stretching out a little bit. (Laughs) Kimberly Tripp: Well, you are not seeing the full benefit of 64-bit, because in the 32-bit address space for Windows you are at 4GB and so, Windows can do pretty well with that. You don't tend to see just huge gains until you start going into the extended memory or the areas where you might be putting pressure on resources that have to live in real memory.

Carl Franklin: Right. Kimberly Tripp: Stored procedures, locks, user connections, those kind of things that have to live in real memory—if those are your bottlenecks or your problems and you go to 64-bit, you'll just be like, "Wow, this is amazing!" But I have also had people that say to me, we went 32 to 64, and we haven't really seen a big benefit yet. But again, they are more scalable, they are going to be able to access their data cache more efficiently and effectively, and they'll be able to grow significantly better going to 64. So we maybe don't see the benefit now, you should be able to see the benefit, but boy, when you are on larger memory implementations, data warehouses and so forth, those are the guys that just kind of go: 'Our data warehouse bill dropped from X hours down to half that or quarter that,' and there are a lot of things there and they can get some huge benefits. But I am running 64-bit at home too, Richard. I am right with you, I am running a dual-core, dual-proc, 4GB of memory, 64-bit machine as my main, kind of, test machine and so forth. So I love it, but I do run into things occasionally where I want to stick some stupid little applet or some gadget on my machine and there aren't 64-bit drivers.

Richard Campbell: The killer is our USB-related things… Kimberly Tripp: Exactly.

Richard Campbell: USB devices stuff where they just don't have the driver for it. Kimberly Tripp: Yeah, exactly, and I just kind of get frustrated with that. I'm like, darn it. I wish I could run this on this machine. Right now, I am still struggling with having to have multiple 32- and 64-bit machines, but I run Virtual PC as well, actually sorry, Virtual Server because there isn't a 64-bit Virtual PC. But Virtual Server, Richard, I don't know if you know this, I just learned this myself, you guys know Virtual Server is free?

Richard Campbell: Yeah. Kimberly Tripp: Virtual Server R2 is actually fully downloadable for free from www.microsoft.com, 32-bit or 64-bit? So, very cool.

Carl Franklin: Wow. Richard Campbell: And I have been blown away at how well VPCs perform running on the 64-bit.

Kimberly Tripp: There you go. Richard Campbell: Virtual Server host, it's awesome.

Kimberly Tripp: That's what I was going to say, yeah. That's what I loved doing, like on my 64-bit machine. I'll have two VPCs running, each requiring a GB of physical memory, and switching between them and everything's cool—I mean, I love that. Carl Franklin: Now this isn't Virtual Server, this is a Virtual PC you are talking about.

Kimberly Tripp: Well I am sorry, I keep saying VPCS because I am talking about virtual machines; I actually created the virtual machines on Virtual PC, but you can take the same VMCs and VHDs, bring them over to Virtual Server, and they pretty much run exactly the same… Carl Franklin: Okay.

Kimberly Tripp: So, I actually move them between my machines. When I am on my laptop, I am on a 32-bit machine on Virtual PC. And when I am on my server at home, I am on Virtual Server on a 64-bit machine and I literally just copy the VPC over and start it right up—it's awesome. I mean, you can move between the environments with no problem and it really performs significantly better on the 64-bit machine with 4GBs of memory. This conversation continues online.

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date