Survey: have you ever used these DMVs?
In this week's survey I've got four mini-surveys for you, all to do with in-depth performance analysis. I'd like to know whether you've ever used
Menu
In this week's survey I've got four mini-surveys for you, all to do with in-depth performance analysis. I'd like to know whether you've ever used
A few weeks ago I kicked off a survey about disaster recovery testing and how the plan copes with human factors. You can see the original
This survey follows on from the survey results I just blogged about, and is particularly apt given we're here in Dallas this week teaching our
About a month ago I kicked off a survey asking what you look for when first analyzing a plan for a poorly performing query. You
The recent earthquake in New Zealand and this morning's devastating earthquake and subsequent tsunami in Japan set off a lot of discussion on twitter about
A few weeks ago I kicked off a survey about tempdb configuration – see here for the survey. I received results for more than 600
Back at the end of January I kicked off a survey about the relationship between your DBA and dev teams. See here for the survey.
In this week's survey, I want to know how you've got tempdb configured compared to the number of processor cores SQL Server thinks it has.
Last week I kicked off a survey about the size of the largest single SQL Server database in your company – see here for the
In my survey this week I'd like to find out how large the largest single SQL Server database is at your company (how much space
Last week I kicked off a survey about network latencies and database mirroring. See here for the original post. Here are the results of the
In my survey for this week I'm interested in what you look for first when analyzing a query plan. I'll report on the results around
Last week I kicked off a survey about how you monitor your database mirroring sessions. See here for the original post. Here are the results
I'm going to do two surveys this week. In this one I want to know what the relationship is like between the DBA team and
In my survey for this week, I'd like to know what you what the network latency is between your mirroring principal and mirror servers, and
In my survey for this week, I'd like to know what you monitor if you're using database mirroring. [Edit: The survey has closed now. See
Just before Christmas last year I created a survey to ask you what your job title is and additionally, if you wanted, what you actually
At the end of December I showed you how to discover if power saving is enabled on your server, which can lead to variable and
(Yes, I know I haven’t editorialized the last survey on What’s in a Job Title – I will in the New Year.) Over the last
There's been a lot of discussion on the MVP distribution list about various certifications and what SQL Server roles they cater to. Furthermore, there's a
I’ve recently been creating some content about wait stats analysis and I think it would be really interesting to see what kind of waits people
Back at the start of July I kicked off a survey around your plans for SSDs (see here) and now I present the results to
It's been a while since I conducted blog surveys so I'm going to do a few through July and August. First up – I'd like
(Happy Independence Day to everyone back home in the USA! We’re in Dublin for another week…) Back at the end of April I conducted a
Over the last few months there's been some noise (mostly of my making) on Twitter about the number of VLFs in transsction logs. Given the
This survey is based on a suggestion from Jonathan Kehayias (blog/Twitter). In this survey I'm asking two questions: When you're designing/implementing a database, do you
A few weeks ago I kicked off a survey asking what kind of disaster recovery guide/run-book/plan (I'll just call it a plan from now on)
In this survey I'd like to find out what kind of disaster recovery guide/run-book/plan you have, if any. When a disaster occurs, do you just
A few weeks ago I kicked off a survey on how you add geo-redundancy to a failover cluster (see here for the survey). The results
I'm moving away from strictly weekly surveys as they're a little demanding, especially when we're on the road. In this survey I'd like to know
A long time ago, in a blog post far, far away (well before I went offline in July) I kicked off a weekly survey about
In this week's survey I'd like to know how often you run consistency checks on your *most critical* production database, regardless of *how* you run
In last week's survey I asked how you manage the size of your database *data* files – see here for the survey. Here are the
In this week's survey I'd like to know how you manage the sizes of your database *data* files (remember we've already done log file size
In last week's survey I asked you what you think is the hardest thing when becoming an involuntary DBA – see here for the survey.
This week's survey is all about being a DBA or involuntary DBA – what do you think is the hardest thing when becoming an involuntary
In last week's survey I asked what you think is the most important thing when it comes to performance tuning, if you *had* to choose
This week's survey is going to provide some fun debating topics. I'd like to know what the number 1 thing is that YOU go after
In last week's survey I asked you two things, as a precursor to a whitepaper I'm writing for Microsoft The first question was what is
This week's survey is inspired by this morning's Kimberly+Paul hot-tub conversation around data-dependent routing vs. network load balancing, which then turned to SLAs. Yes, we
In last week’s survey I asked whether you’re ever tested your disaster recovery plan, and if so, what happened? (See here for the survey). Here
This week's survey is inspired from many stories I saw on the forums and Twitter this week – mostly bad, one good (someone I'm following
Last week's survey was another two-fold one – when you buy new servers, what architecture to you predominantly buy, and why?; when you buy new
This week's survey is another two-parter, part 1 of which suggested by Mike Walsh on Twitter: When you buy new servers, what archictecture do you
Last week's survey was two-fold – what's the largest SQL Server database you manage, and how many SQL Server databases are you responsible for managing.
Jason Massie posted an interesting statistic yesterday – Facebook has 1.5 petabytes of image storage, and it grows by 25TB daily – I wonder how
Last week’s survey was on what kind of backups you take, along with the recovery model used (see here for the survey). Here are the
In this week's survey I'm interested in what kind of backups you take, and also what recovery model you mostly use. If you have multiple
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.