I’ve been catching up on some work and blog reading and ran across an interesting post from Scott Drummonds – one of the most knowledgeable people on performance benchmarking I know. In his most recent post Scott tackles the issue of performance in SQL. This is something that comes up at nearly every customer account I talk to. In nearly every case where I investigate the performance issue it’s due to some sort of misconfiguration. Sometimes the misconfiguration is on the VMware side. More often than not it’s on the SQL side. For some reason people just think SQL is this big hog of resources and the only way to make it run fast and scale is to throw more raw resources at it. Very few people actually take the time to really understand the transactions going to the database, the underlying storage, or any of the other variables that could impact performance of a database transaction.
In his post, Scott goes through some of the simple things you can do to tune VMware for the best database performance possible. For an even more detailed checklist you should read up on the best practice checklist in the VMware Communities. Hopefully between these two nuggets of information you can finally lay to rest the topic of SQL performance.
Leave a Reply