The Data & Monitoring team in ITS-EI Technology Platform Services provides MS SQL Server Database Management and Administration Services. These services include the physical design, implementation and maintenance of the database as well as data security, data integrity, backup/recovery, performance monitoring, and tuning. Database migration consulting and services are also provided.
This service is typically used by IT Professionals: Faculty, Staff, and Researchers should work with their local IT support group (such as Extended Technical Support) or application focused sysadmin to coordinate consultations and service requests.
Current Status
Maintenance
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Past 90 Days
Alert History
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
The issue has been resolved.
We are experiencing degraded performance with Peoplesoft Financials, Oracle, and SQL that is causing slowness and timeouts. Support staff are investigating the issue.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
On Saturday June 11, 2022, between 10:00 a.m. and 12:00 p.m., the shared SQL Server instances IOWASQLHOST1, IOWASQLHOST2, and IOWASQLHOST3 will be migrated to new servers, resulting in intermittent downtimes of up to 20 minutes during the maintenance window.
A list of impacted databases and further service changes are available in the following OneIT Intranet article: https://intranet.oneit.uiowa.edu/article/2022/05/changes-sql-server-shared-hosting-service
The shared SQL Server instances IOWASQLHOST1, IOWASQLHOST2, and IOWASQLHOST3 will be migrated to new servers.
During the maintenance window, databases on these systems will be sporadically unavailable for periods of up to 20 minutes. No application changes are necessary to accommodate this maintenance, however, applications that are sensitive to extended database unavailability may need to be restarted once the migration is complete. We recommend pausing data processing jobs scheduled on these servers during the maintenance and notifying customers expected to use applications connected to the servers at that time.
This migration is urgent due to recurring connectivity issues on the Windows cluster hosting these instances that have resulted in multiple outages of campus services since April 2022. Additional information about this maintenance – including a list of impacted databases – is available in this OneIT Intranet article: https://intranet.oneit.uiowa.edu/article/2022/05/changes-sql-server-shared-hosting-service.
Please direct any questions or concerns about this maintenance to the ITS SQL Server DBA team at ITS-SQL-Help@uiowa.edu or TPS-Data & Monitoring team lead, Andrea Mascher (andrea-mascher@uiowa.edu).
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
This issue is resolved.
Users using Windows authentication to IOWASQLHOST2 may be experiencing intermittent timeouts. Connections using SQL authentication are not impacted. ITS staff are currently looking into this.
Impacted instances:
IOWASQLHOST2
ICONSQLPROD
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
(Microsoft Server Security Updates for January had many issues and Microsoft ended up pulling those. On January 17, they released new Out of Band Updates to resolve issues with the original dodgy patches if they were installed, and replace those dodgy patches if they were not installed. To remain secure and fully patched, we will be deploying those Out of Band patches outside our normal production patching week.)
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be patched during their normally scheduled maintenance window. Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.
Please contact the ITS Help Desk if you are interested in the list of patches that will be applied or if you have any questions.
To support upcoming security enhancements to Oracle systems, we will upgrade Oracle drivers on a variety of centrally hosted SQL Server services. During this maintenance window, services will become sporadically unavailable. Please pause scheduled processes that run against these systems during this time.
Systems impacted include:
SQL Server Integration Services (SSIS) systems:
IOWASSISHOST1
IOWASSISHOST2
IOWASSISHOST3
IOWASSISHOST4
SQL Server Reporting Services (SSRS) systems:
IOWAREPORTS1
IOWAREPORTS2
IOWAREPORTSHOST3
IOWAREPORTS4
BISSCREPORTS1
IOWABIREPORTS1
Contact the ITS SQL Server Database Administration Team at ITS-SQL-Help@uiowa.edu if you have questions or concerns.
IOWASQLSEC4 will be unavailable intermittently for up to 30 minutes while the system is migrated to a new Windows cluster.
IOWASQLSEC4 will be intermittently unavailable for up to 30 minutes to resolve an issue with Windows clustering services.
IOWASQLSEC4 will be intermittently unavailable for up to 15 minutes during the maintenance window to resolve an issue introduced by the July 2018 Windows security patch.
IOWAREPORTS3 (SQL Server 2016 Shared SSRS Hosting Service) will be unavailable due to scheduled maintenance. Some reports on MAUI and Campus Data may be temporarily unavailable during this window, but there should be no impact to the core functionality of either service. SSRS report subscriptions scheduled on this system during the window may not execute or deliver.
Microsoft SQL Server Hosting and Administration Contact Information
Contact ITS SQL Server Support at ITS-SQL-Help@uiowa.edu