The second day in Charlotte at the PASS Summit 2013 has come to an end. I spend the whole day in a Failover Clustering pre-conference session held by Allan Hirt and it was both educating and exciting. I was pleased to realize that many of the things I have spoken in our company were also addressed and confirmed by Allan. He also reminded me of some the things I had forgotten and taught me quite a few new things as well.
First day in Charlotte started earlier than we had planned due the time difference. We also had some misfortune with us, as two from our group we delayed due mechanical failure on the plane that was supposed to bring them to Helsinki. We had no pre-con sessions for today so we had time to get to know the area around the Convention Center and the Uptown area. We did drop by the Convention Center to do our registration and to get our kit 🙂
I’ll hit the road and air (can you actually hit the air?) in a couple of days to start my journey towards Charlotte, North Carolina to attend the PASS Summit 2013. This will be my first time in the PASS main event of the year and I am quite excited that I got the company approval to go. I’ve previously attended one of the SQL Rally Nordic events, which was at Copenhagen last year, that was also a great experience and also one of the main reasons our company is now sending a group of five people to Charlotte.
In my previous post we took a quick look into one of the SQL Server features that I personally consider to be a great boon to any DBA, the Dynamic Management Views and Functions. Im going to show you through some basic examples on how you can use these views to get meaningful information out of your SQL Server instances.
I was migrating some old databases (I’ll write some more about this later) couple nights back to new database server and while that went mostly alright, things were not looking so good in the morning. I was driving on a highway, taking my daughter to daycare when the phone rang. I did recognize the number being that of my customer, so I answered.
I’ve been working with SQL Server ever since 1999, back then it was the 6.5 version which was soon replaced by the SQL Server 2000 (we skipped the 7.0 completely). Back in those days getting information out of SQL Server was much, much more difficult and you had way less tools for it. Then came the SQL Server 2005 and suddenly there was a plenty of information available to make troubleshooting and working on performance issues so much easier.
In fact there’s so much information available these days, that finding out where simply to start can be a daunting task. When I first started working with SQL Server 2005 my first task was to familiarize myself with the new feature called Dynamic Management Views and Functions, or DMV’s as they’re sometimes called. In SQL Server 2005 you have about 90 DMV’s, in SQL Server 2012 the number of DMV’s is almost 180. They’re definately an important tool in any DBA’s toolkit. And that is what this article is about, to get yourself started with the DMV’s.
As I moved from the famous “accidental” DBA role into being an actual DBA, it was quite a learning experience from the start and it is continuing to be so even this day. When I started my career, back in 1998, there were very few resouces other than actual books, about SQL Servers. Fortunately these days information is easier to find as there are numerous blogs, discussion boards, etc with exceptionally skilled SQL Server experts helping people out with their SQL Server issues.
However many of these sources have questions and answers that really go into deep technical details, which is great if that is what you’re looking for. There does seem to be a smaller number of blogs that are dedicated to people who are just starting out their DBA careers, and this is the audience I’m looking to share my own experiences with.
And with that, I’ll finish my first post.
Welcome to the SQLStarters blog!