Last week on Wednesday I attended a Quest seminar which was hosted by a couple of Quest people, one of them being Brent Ozar. On my way to New York City I was reading a couple of chapters of SQL Server 2008 Administration In Action written by Rod Colledge. I was totally blown away by what I read, this is probably the best SQL Server admin book I have ever read. I will write up a review in a week or so, I still have to finish the book.
In this book there is a mention of SQL Server sprawl, interesting I have never heard of this term. After Brent Ozar started his first session he also had SQL Server sprawl on one of his slides. Now, just like me until then you might not know what SQL Server sprawl means but you certainly know what it is after I describe it. So SQL Server sprawl could be a server that sits in a closet and nobody knows what it does or who owns it but there is a sticker on it that says “do not turn off”. Or it might be an instance installed on a desktop under someone desk and it is used to generate production reports. You might have dozens of these and most probably these boxes are not maintained or backed up regularly. By now I am sure that you have a situation like this at your current job or you have worked somewhere where they had such a mess.
If you need to find out all the instances that are on your network then check out this fine post by onpnt: Scan network for SQL Server instances. In that post you will learn how you can use SQL ping to find these instances
What is the solution to SQL Server sprawl? Virtualization is one of the solutions mentioned, this is probably fine for smaller databases but I don’t see my databases going the virtual route any time soon, as a matter of fact we just purchased new servers for our SQL Servers and soon I will be running SQL server 2008 only 🙂
If you would like to read a sample chapter of SQL Server 2008 Administration In Action then visit this link http://www.manning.com/colledge/ There are 2 sample chapters available right now. The book should be available August 10 and you can already preorder it from Amazon. I will have my review up in a week or two.