Tuesday, November 25, 2008

Hardware at a Software problem?

I'm trying to get people to change their thinking. Should we really be throwing more hardware at inefficient code? Not all code is inefficient, but some of it is! What is the cost tradeoff? People say, it's ok to throw money at Hardware because it's cheaper than getting a human to fix the code and everybody is over worked and underpaid!

I've always thought that you fix problems at the software level, so that your software runs absolutely efficiently and performs better, but is a new way of thinking? Hardware is cheap (especially in the INTEL /AMD world as compared to the Sun world), developers are expensive? I understand that at one point that it will get significantly more expensive to change the hardware, but till then?

What would you do?

Monday, November 24, 2008

Faster Disks for Dbs?

I was having a conversation with my colleagues on Db performance, when it veered into Solid State Drives for TempDb. Assuming that since TempDb is very high writes and less reads, the faster the disks can write, the better it is, and the more you have the I/Os split up, the faster it will be.

That got me thinking - for places that manage a number of databases or even 1 with high volume, wouldn't it make significant difference if we drop in a solid state drive for Temp? This got me further thinking - if all Temp is expendable, and not really stored, why should it be a drive at all.

Why not use RAM Disk instead? Power outage - doesn't matter - since the data is all Temp anyways!

But what about taking it up a notch. (If it's not done already - I'm claiming rights to it :-) ) . Why not storage providers like EMC or others offer Tray's of just RAM for Temp storage? DBA's could potentially create the TempDb / Tablespace on the RAM Disks. When DBAs are managing large number of instances (Oracle) they could just as well point to this RAM disk in this tray.

Wouldn't that significantly improve performance? Instead of always looking at increasing I/Os on disks - especially for Temp, wouldn't this be a better way to go?

I'm writing this before any research on this topic, but I couldn't stop myself! Have any of you done any experiments with this? Do you know of / have any articles on this topic? If so - can you send me a link :)

Thursday, November 13, 2008

India - Stark Contrasts!

I recently came back from my vacation in India. I love India. It's where I was born, where I studied and was raised for a better part of my life. Now that I stay in the US, and only go back for vacations and family visits, I can talk about how it has developed and perhaps not....

What I found in most places I traveled to was ...The roads need to get better. People need to be more civic minded. People need to realize that the Government cannot do everything! Ofcourse - you can also see that the Government employees are only interested in making sure that their wallets are well padded and more money flows under the table than in public. Thats for another discussion.

The reason I write this is is - I've visited a couple of Software Development shops there. They're awesome. Some of the larger ones have canteens to buy food at (not vending machines, but actual food) and a very nice atmosphere. I was surprised at the number of flat screens. I also visited a number of malls ( you cannot believe the number of these complexes that have sprouted up all over the city - even in almost villages!). You can get some of the finest designer items from Gucci to Versace to anything you name it you get it. Whats even more surprising is, that most of these shops have buyers - and most of them are middle class working men and women!

Here's where the stark contrast comes in. When you enter any of these malls - it feels like you've been transported into a different country. The creature comforts, the designer brands and what not. Exit that mall and you're back in the midst of bad roads and sometimes very polluted air. I think this tells more on the government of the city, state & country more than anything else. The people in India are very creative. They make the best of what they have. Yet - the Government does not reciprocate, their employees - all they do is pad their pockets with bribes, and spend that money in these malls, but no services are provided to the public.

Until that mentality changes, until the people demand more, get educated (they try, but a huge uneducated population is better for the politicians - give them a beer and ask them for their vote) and DEMAND more - I don't think the city is going to change.

They changed to an open market, because the country as a whole was pushed to the brink with it's debt and policies. I hope the country is not pushed again to the brink due to the lack of infrastructure. This is probably the best time for India to reinvest in the infrastructure - not just by private industry, but by the government too....

I guess I could have summed this whole post into one word - Infrastructure!

I wish I did have pictures though. It would definitely show the stark contrasts.