Hey, A short one today, but I thought it might be nice to have some hard facts on the performance tuning I had been doing, rather than all hypotheticals. I’m happy to report that it went very smoothly, applying two indexes, identified by Database Engine Tuning Advisor, has eliminated all timeouts, and dropped our average […]
Follow up on last weeks problem : Performance results Read More »
Just a short one again today, as an issue came up today which required some new indexes to resolve the problem, and I wanted to stick it up while it was fresh in my mind. There are many great articles out there on SQL Profiler and Database Tuning Advisor, and Microsoft provide detailed overviews also
Evening all, hope the weekend went well for everyone. Just a short one today as I’m still in the thick of it with my SAN, oh the joys! This topic cropped up yesterday when a colleague of mine was setting up a 60GB database for mirroring, and after spending hours transferring the file, discovered he
One question I seem to get asked a lot is what is the difference between Replication and Mirroring when it comes to SQL, and especially for the Sys Admin stuck in the middle, what is the best one to use for a Disaster Recovery scenario. Firstly, for people who haven’t heard of either, both replication
Replication VS Mirroring, and what to use for a Disaster Recovery setup Read More »
Another one close to my heart today, and apologies for it being a little shorter than usual, a problem with table locking is taking up all of my free time! This is just a short guide to what locking is, how it works, why each different type is good and bad, and in turn how
How locking works on a table, and how it can affect your applications Read More »
This is a topic that is close to my heart at the moment. We are using a slightly older SAN here at the moment, and at the time it was set up, it was set up slightly below optimal. So now we are paying the price as our database performance requirements have outgrown the setup
Choosing the right RAID, and why disk layout is so important to a DB Read More »
So a two-for for the first day. One thing I find going in as a DBA to smaller companies is that the SQL versioning across the site is very rarely uniform. I think the reason for this, is that there are quite a few different versions of SQL, and unless you delve deeply, they all
SQL Editions and Development Vs The Real World (Not the MTV Version, sorry) Read More »
First post! Woo! Not as epic as it sounded in my head. So a little bit about me. I’m the Senior SQL DBA for a multi national company based in Dublin, and have been for almost 4 years. Before that, I worked as a Sys Admin/Guerilla DBA for many other companies. Having worked as a
