I’ll be honest, I was *really* looking forward to using the Utility Control Point feature in SQL 2008 R2. I wanted to give the UCP a test drive, kick the tires, and get out on the open road. I even started asking around to see if we could get our hands on the shiny new Data Center edition of SQL Server 2008 R2, because I have a lot more than 25 instances here and I know that I need that version in order to assign them all to one UCP.
And just as I was getting started I found myself overcome with emotions. First was shock and denial (“no, that can’t be true”), followed by pain (“this hurts”), then anger (“&@$&%^@%”), loneliness (“I don’t have any more”), and finally acceptance (“well, I guess that is how it is going to be”).
I am talking about, of course, the fact that the UCP is only for SQL 2008 R2 instances:
In this release, the UCP and all managed instances of SQL Server must satisfy the following requirements: SQL Server must be version 10.50 or higher.
Yeah, they did.
So if I want to start using the UCP I will need to get two instances of SQL 2008 R2 running (one to be the UCP, and the other to be registered in the UCP). What are the chances of me having multiple instances of R2 up and running in my shop before the end of the year? Very little. What are the chances of me having one instance of R2 up and running? Also very little. What were the chances of me having at least one because I thought I could start using the UCP against at least my existing SQL 2008 instances? Those chances were very high, actually. But right now I don’t see any reason for me to be in a hurry to have R2 deployed.
And that’s too bad, because I was really excited about using the UCP. I don’t know why the UCP is exclusive to R2, but by doing so it doesn’t make me want to push people to upgrade/migrate to R2 any faster. In fact, chances are I’ll just wait for SQL 11 to be released instead of dragging people to R2.
But first it would be nice to get rid of SQL 2000. If only there was a good way to effectively monitor and control those systems from a common point…