Survey: tempdb file configuration (code to run)
I’m running this survey to help the SQL Server team at Microsoft, who would like to get a broad view of current tempdb configurations. I’ll
Menu
I’m running this survey to help the SQL Server team at Microsoft, who would like to get a broad view of current tempdb configurations. I’ll
It’s been a while since I’ve done a survey, and this one is inspired by a discussion I had with Matt Slocum (b | t) yesterday that led
[Edit 12/10/14: Survey is closed see the editorial here.] One of the trends I’m seeing this year is a slow increase in the number of
It’s been five years(!) since the last time I asked about your target uptimes for your critical SQL Server instances and I think we’d all
Time for another fun survey, this time around factors causing the transaction log to grow. Imagine you’re the DBA for a company and you come
Here’s another survey for you, and I’m really looking forward to seeing and discussing the results of this one. Imagine you’re the new DBA for
In this survey I’d like to know what your experience is using the DBCC WRITEPAGE undocumented command. This survey is closed – see the editorial
In the first post of the year I’d like to kick off a survey. I’m interested to know whether you’ve ever practiced restoring or rebuilding
Time for another survey! This survey’s very simple: run the following code on as many of your production instances as you can, and post a
Time for another survey (I’ll editorialize the files/filegroups data from the last survey next week). This survey’s very simple, run the following code on as
This survey is closed – please don’t spend your time sending any more data – thanks In this survey I’d like to see what the
In this survey I’d like to know what the newest version of SQL Server is in your environment – it has to be an instance
In this survey I’d like to know what the oldest version of SQL Server is in your environment – it has to be an instance
A while back I kicked off a survey asking what mechanism you use for running your regular SQL Server database maintenance. Here are the results:
I haven’t done any surveys this year and I’d like to get back into doing one every week or so for the next few months.
In this survey, I'm interested in how often you perform a full database backup of your production databases. I'll editorialize the results in a week
In this survey I'd like to know where you store your SQL Server backups. If a disaster occurs, where do you get them from? It
For the last few weeks I've been thinking about performance baselines, mostly because I've been producing Erin's new Pluralsight course on Benchmarking and Baselining. It
In this survey I'd like to see what the distribution of the number of log files per database is for your servers. I'm planning to
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) Back in
I first started blogging about latches and some of the deeper parts of SQL Server internals last year (see Advanced performance troubleshooting: waits, latches, spinlocks)
A long time ago, in a galaxy far, far away I kicked off a survey about memory configuration. Actually it was back at the start
Back in 2009 I ran a survey about methods of running consistency checks. I recently re-ran the survey to get a better idea of the
Three years ago I ran a survey about consistency checking methods. A lot has changed since then, including database sizes, 24×7 operations, and a lot
Time for another survey – this time around memory configuration. Here is some code to run if you're on SQL Server 2008 and 2008 R2
Back in November I kicked off a survey that had you run some code to get some details about your cluster keys, nonclustered indexes, and
Continuing with my "index health" series, I've got another piece of code for you to run. This time I'm interested in the number of columns
Back at the start of August I kicked off a survey (see here) that gave you some code to run to produce an aggregate list of
A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results:
Here's a survey I've been meaning to run for quite a while – that Kimberly and I are really interested in. For all the databases
A couple of weeks back I kicked off an off-topic survey about which internet browsers and email clients people use. Here are the results:
Three weeks ago I kicked off a survey about using database snapshots – see here – because I don’t really know how much they’re used or
This survey is off-topic and was suggested by Justin Dearing (blog|twitter) and I'm curious about the results too so I agreed to run it. We're
About a month ago I kicked off a survey around regularly rebooting SQL Server (see here). There is much debate about rebooting SQL Server (or
As I was writing a quick SQL Server Magazine blog post on database snapshots while waiting for my coffee to brew, I figured it would
A month ago I kicked off a survey about MAXDOP setting – see here for the survey. I received results for 700 servers around the
In this survey I'd like to know if you regularly reboot SQL Server. There are two parts to this: a) no or yes with frequency
If I told you about an undocumented mod you could make to your car's brakes to make them more efficient, would you try it? What
(Check out my Pluralsight online training course: SQL Server: Index Fragmentation Internals, Analysis, and Solutions.) Back in April I kicked off a survey where I asked
I have a few surveys to editorialize but I'd like to kick off another one where you have to run a bit of code and
After finishing the salary survey I was kicking around ideas for the next one and thought about one of the sessions I presented at SQL
(Used with permission from Dilbert.com) Following on from the survey I did about what your company is doing for you and vice-versa (see Job
Following my survey on company and employee loyalty, job security, and retention, I think it'll be very useful to the community to do a survey
(Used with permission from Dilbert.com) It's an interesting marketplace for DBAs right now. Depending on who you speak to, and what your view into
In this survey I'd like you to run some code and then send me the results (and I'm sure someone will put together a PowerShell
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) It’s all
After a discussion on Twitter this morning, my good friend Steve Jones (blog|twitter) said it would be great to have a survey polling people on
A couple of week ago I kicked off a survey about common causes of performance problems – see here for the survey. Firstly I asked
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.