When You Care Enough to Spend The Very Least
Dr. Dobb’s Journal just published an article of mine about SQL Server in the cloud. In it, I cover:
You can read the article, and then let me know what you think here. (They don’t have discussions on articles.)
Most SQL Server DBAs don’t even like MySQL, let alone NoSQL. They cringe when they hear people say things like, “I don’t need transactions” or “The data will eventually be consistent” or “Indexes will be supported in the next version.” SQL Server and Oracle people are constantly trying to out-feature each other, and the abject [...]
Read More »In August 2008, Lady Gaga released her premier album The Fame. This 13-track work produced several hit singles including Just Dance, Poker Face, and Paparazzi – but it also produced plenty of controversy. Her exaggerated use of fashion, musical cliches, and sex gave her plenty of media attention – both good and bad. If you’ve [...]
Read More »Pop quiz: should you be worried if your SQL Server’s page life expectancy is averaging 214? There’s only one correct answer: it depends.
Performance tuning is all about finding the RIGHT bottleneck, focusing on it, and fixing it to the application owner’s satisfaction. Learn what happens if you don’t do it right.
Read More »Erika’s friends call her “Fancy Feast” because she only likes the best things in life. She’s got champagne tastes, but we can’t afford to buy the best of everything. I recently picked up a coffee table from Ikea, and it got me thinking about SQL Azure.
In a perfect world, I’d have on-premise SQL Server for every database. I’d use cutting-edge storage and cluster everything. But this isn’t a perfect world…
Read More »I get a lot of questions from people who want to get a better job. They want to know if certification, training, or branching out will help them get the job of their dreams. These things just aren’t the real answer.
The answer is simple: the Buddy System. Learn why.
Read More »
Hi Brent,
I was wondering if you had any insight to the current state of database performance with the new Server/Sql 2008 options at Amazon EC2. You had an article a while back which criticized the performance of Sql 2005 on the 2003 servers they had, saying that the throughput was the equivalent of running your db off a thumb-drive. It appears like they’re trying to address some of the previous limitations of Windows on EC2 (server version, boot drive, etc.) and I was wondering if this translated to performance benefits.
Cheers,
Rob
Rob – good question. I’ve been curious about that myself, but since it costs money to ramp up a new server and do performance testing, I haven’t bothered. I’ve been waiting until I see word from them that there’s a better-performing storage subsystem available, or that they’ve improved it somehow. Have you seen anything to that effect?
Not to be overly analytical about the new server options, but they do in fact “feel” zippier. It’s definitely cool to see how fast they boot and even cooler that they can sit idle and uncharged in the stopped state. Neither of these perks address day-to-day operations however.
Maybe in the New Year I could provide the server(s) and you could provide the skill(s) or at least direction to dig into it a little more.
Thanks for < 1 min. reply,
Rob
You bet! If you give me the login I’d be glad to dig into the storage performance and let you know what I find. Happy holidays, and talk to you next year!