What are the three biggest challenges facing teams who are responsible for monitoring and maintaining the performance of SQL Server in 2018? Find out the answer in this new report.
We asked over 600 SQL Server professionals across a range of sectors, in organizations of every size around the globe about how they monitor SQL Server, the technologies they work with, and what they thought the biggest challenges were for them and their SQL Servers over the next 12 months.
Download the full 29-page report and you’ll discover a wealth of information, including:
- The three biggest challenges teams monitoring SQL Server face in 2018
- How the role of the cloud is evolving across SQL Server estates
- Which areas cause the most problems for database administrators, developers, and other people who monitor and maintain SQL Server
What is the biggest challenge facing your SQL Server estate management this year?
Concerns around security and data protection are a big challenge, particularly with the advent of GDPR in May 2018. These concerns affect both day-to-day work and the management of SQL Server estates in general.
Lack of server space came out as the second largest challenge. Moving to the cloud was cited as a big challenge for the future, which explains the interest here. Staffing is also a concern that could be alleviated by allowing more work to be handled by cloud platforms.
How frequently does your organization deploy database changes?
A quarter of organizations deploy changes a few times a week, with about the same proportion doing so even more frequently. Finance and Technology sectors often deploy multiple times per day, whereas those working in Education tend to deploy changes less frequently.
Which of these tasks are your responsibility?
Respondents carry out a range of activities, with most respondents responsible for several areas. The most common task was performance optimization, which 70% of respondents said they were responsible for, followed by data transformations, backups, and security.