Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
on March 19, 2019
Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers.
Take the survey before April 5, 2019.
Your time is valuable. The survey will take 5 - 10 minutes to complete. That’s not a ton of time, but it’s a noticeable part of your day, and there should be something in it for you. Here’s why it’s worthwhile to take the survey.
Database use patterns and monitoring trends are valuable to everyone in the community – and we’ve been missing out on this trend information!
This isn’t the only survey from Redgate – you may also have heard of the annual State of Database DevOps Report.
But this survey is different in important ways: it asks how you manage and monitor your SQL Server database environment, regardless of whether you think about DevOps at all.
Redgate shared the results of the State of SQL Server Monitoring Survey with readers last year, and will do so again in 2019. 2018 was the first time we know of that a survey of this kind had been done, and it will be especially interesting to notice what has changed in the past year.
If you fill out the 2019 State of SQL Server Monitoring survey, you’ll get an advance copy of the results by email
The results will help you understand:
What do other DBAs, Developers, and IT Professionals see as their biggest challenges over the coming year?
In last year’s report the biggest challenges were seen as:
1. Migrating to the cloud
2. How to deploy changes faster to larger environments
3. Protecting data – especially for compliance reasons
I’m curious to see if these priorities have changed after a year. With GDPR implementation having come to pass and more states and countries around the world passing increasing privacy regulations, I suspect that ‘protecting data’ may move up from number 3 on the list, but I won’t know until we see the data.
How much time do your peers spend examining SQL Server health and resolving issues?
This is a great question on the survey – and I think this one is absolutely worth some reflection after you take the survey (and after the results come out). Do you spend more time firefighting than you should? If so, what ideas you have to change that?
At what point to most organizations move from manual monitoring to a third party tool?
If you work for a growing company and are interested in making the case to purchase monitoring to your management, it may be useful to know information like this…
Respondents with fewer than 10 servers were twice as likely to rely on manual monitoring as to use a paid-for tool. Those with 10 or more servers were more likely to use third-party software.
Survey results will help you prioritize what to learn
Are you curious as to whether you should learn another database platform, such as MongoDB, Oracle, MySQL, Cosmos DB, or PostGres? The survey will show how much respondents report that they are using each platform, and whether they think the amount will increase or decrease.
Want to know whether you should invest time (and maybe ask for some budget) to explore cloud technologies like Azure Managed Instances, Azure SQL Database, or Amazon RDS? The survey will show how many of your peers are using each one.
Also, You Could Win Money
Everyone who completes the survey and provides their details at the end will be entered into a prize draw to win a $250 Amazon Voucher (or equivalent in your local currency).