July 2006 Entries
I have been working on a "load balancing" application for OLAP applications and one or two of my previous posts touch on some things I've learned in the process. But now that I've got a working beta version I've decided to write my first "formal" article based on what I've learned. I've posted the article on my favorite developer community site, codeproject.com. Here's the link:http://www.codeproject.com/useritems/dbloadbalancerservice.aspThe article is written based on using an ASP.Net application as the client for the load balancer, but in reality the client could be windows based as well.Tags: SQL Performance, SQL Server
I've been pretty busy and haven't had time to post in a while, but this week I ran into something I thought was worthy of posting. I'm working on writing a "poor man's" load balancer for our databases. I won't go into the background this time as I will likely post details on the load balancer once I've completed it. But when it came time to work on gathering data using the System.Diagnostics.PerformanceCounter I ran into the expected permissions issue. Most examples involved using ASP.Net to display performance data, and all the examples I was running into recommended using either...
SQL Server 2005 has introduced an exciting new feature - data mirroring. And the timing couldn't be better. This summer as we upgrade our infrastructure we're working to increase our uptime and start doing some things right. Since we don't have a DBA, I get the responsibility of improving the database availability and performance. Well mirroring is just what the doctor ordered. But as usual (is it just me?) I've hit a snag trying to get it set up and running, and got an error that either no one else is getting or no one else has posted. So as...