Available to
Staff
Researchers
IT Professionals
Fees
See Details

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) to coordinate consultations and service requests. 

Current Status

There are currently no alerts.

Maintenance

Services scheduled for maintenance over the next 7 days. Please refer to the calendar view of alerts for a complete schedule.
There is currently no planned maintenance.

Past 90 Days

Color bar indicators flow left to right, from oldest to most recent status.

Alert History

Start: 
Tuesday, November 15, 2022 - 12:00am
End: 
Monday, November 21, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, November 21, 2022 - 11:45pm
Start: 
Tuesday, September 20, 2022 - 12:00am
End: 
Monday, September 26, 2022 - 11:45pm
Description

Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.

Last updated: 
Monday, September 26, 2022 - 11:45pm
Start: 
Tuesday, August 16, 2022 - 12:00am
End: 
Monday, August 22, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, August 22, 2022 - 11:45pm
Start: 
Tuesday, July 19, 2022 - 12:00am
End: 
Monday, July 25, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, July 25, 2022 - 11:45pm
Start: 
Tuesday, June 21, 2022 - 12:00am
End: 
Monday, June 27, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, June 27, 2022 - 11:45pm
Start: 
Saturday, June 11, 2022 - 10:00am
End: 
Saturday, June 11, 2022 - 12:00pm
Description

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 

Last updated: 
Saturday, June 11, 2022 - 12:00pm
Start: 
Saturday, June 11, 2022 - 10:00am
End: 
Saturday, June 11, 2022 - 12:00pm
Description

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).

Last updated: 
Saturday, June 11, 2022 - 12:00pm
Start: 
Tuesday, May 17, 2022 - 12:00am
End: 
Monday, May 23, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, May 23, 2022 - 11:45pm
Start: 
Wednesday, May 4, 2022 - 10:45am
End: 
Thursday, May 5, 2022 - 8:00am
Updates
Thursday, May 5, 2022 - 8:00am

This issue is resolved. 

Description

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
 

Last updated: 
Friday, May 6, 2022 - 11:14am
Start: 
Tuesday, April 19, 2022 - 12:00am
End: 
Monday, April 25, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, April 25, 2022 - 11:45pm
Start: 
Tuesday, March 15, 2022 - 12:00am
End: 
Monday, March 21, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, March 21, 2022 - 11:45pm
Start: 
Tuesday, February 15, 2022 - 12:00am
End: 
Monday, February 21, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, February 21, 2022 - 11:45pm
Start: 
Tuesday, February 1, 2022 - 12:00am
End: 
Monday, February 7, 2022 - 12:45am
Description

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.)

Last updated: 
Monday, February 7, 2022 - 12:45am
Start: 
Tuesday, January 18, 2022 - 12:00am
End: 
Monday, January 24, 2022 - 11:45pm
Description

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.

Last updated: 
Monday, January 24, 2022 - 11:45pm
Start: 
Tuesday, December 21, 2021 - 12:00am
End: 
Monday, December 27, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, December 27, 2021 - 11:45pm
Start: 
Tuesday, November 16, 2021 - 12:00am
End: 
Monday, November 22, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, November 22, 2021 - 11:45pm
Start: 
Tuesday, October 19, 2021 - 12:00am
End: 
Monday, October 25, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, October 25, 2021 - 11:45pm
Start: 
Tuesday, September 21, 2021 - 12:00am
End: 
Monday, September 27, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, September 27, 2021 - 11:45pm
Start: 
Tuesday, August 17, 2021 - 12:00am
End: 
Monday, August 23, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, August 23, 2021 - 11:45pm
Start: 
Tuesday, July 20, 2021 - 12:00am
End: 
Monday, July 26, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, July 26, 2021 - 11:45pm
Start: 
Tuesday, June 15, 2021 - 12:00am
End: 
Monday, June 21, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, June 21, 2021 - 11:45pm
Start: 
Tuesday, May 18, 2021 - 12:00am
End: 
Tuesday, May 25, 2021 - 11:45pm
Description

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.

Last updated: 
Tuesday, May 25, 2021 - 11:45pm
Start: 
Tuesday, April 20, 2021 - 12:00am
End: 
Monday, April 26, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, April 26, 2021 - 11:45pm
Start: 
Tuesday, March 16, 2021 - 12:00am
End: 
Monday, March 22, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, March 22, 2021 - 11:45pm
Start: 
Tuesday, February 16, 2021 - 12:00am
End: 
Monday, February 22, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, February 22, 2021 - 11:45pm
Start: 
Tuesday, January 19, 2021 - 12:00am
End: 
Monday, January 25, 2021 - 11:45pm
Description

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.

Last updated: 
Monday, January 25, 2021 - 11:45pm
Start: 
Tuesday, December 15, 2020 - 12:00am
End: 
Monday, December 21, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, December 21, 2020 - 11:45pm
Start: 
Tuesday, November 17, 2020 - 12:00am
End: 
Monday, November 23, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, November 23, 2020 - 11:45pm
Start: 
Tuesday, October 20, 2020 - 12:00am
End: 
Monday, October 26, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, October 26, 2020 - 11:45pm
Start: 
Tuesday, September 15, 2020 - 12:00am
End: 
Monday, September 21, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, September 21, 2020 - 11:45pm
Start: 
Tuesday, August 18, 2020 - 12:00am
End: 
Monday, August 24, 2020 - 11:45pm
Description

Managed Windows Servers will be undergoing monthly patching during their normally scheduled maintenance window.

Last updated: 
Monday, August 24, 2020 - 11:45pm
Start: 
Tuesday, July 21, 2020 - 12:00am
End: 
Monday, July 27, 2020 - 11:45pm
Description

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. 

Last updated: 
Monday, July 27, 2020 - 11:45pm
Start: 
Tuesday, June 16, 2020 - 12:00am
End: 
Monday, June 22, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, June 22, 2020 - 11:45pm
Start: 
Tuesday, May 19, 2020 - 12:00am
End: 
Monday, May 25, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, May 25, 2020 - 11:45pm
Start: 
Tuesday, April 21, 2020 - 12:00am
End: 
Tuesday, April 28, 2020 - 11:45pm
Description

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.

Last updated: 
Tuesday, April 28, 2020 - 11:45pm
Start: 
Tuesday, March 17, 2020 - 12:00am
End: 
Monday, March 23, 2020 - 11:45pm
Description

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.

Last updated: 
Monday, March 23, 2020 - 11:45pm
Start: 
Saturday, September 28, 2019 - 9:00am
End: 
Saturday, September 28, 2019 - 12:00pm
Description

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.  

Last updated: 
Saturday, September 28, 2019 - 12:00pm
Start: 
Tuesday, December 4, 2018 - 6:30am
End: 
Tuesday, December 4, 2018 - 8:00am
Description

IOWASQLSEC4 will be unavailable intermittently for up to 30 minutes while the system is migrated to a new Windows cluster.

Last updated: 
Tuesday, December 4, 2018 - 8:00am
Start: 
Friday, September 28, 2018 - 8:00pm
End: 
Friday, September 28, 2018 - 9:00pm
Description

IOWASQLSEC4 will be intermittently unavailable for up to 30 minutes to resolve an issue with Windows clustering services.

Last updated: 
Friday, September 28, 2018 - 9:00pm
Start: 
Thursday, July 26, 2018 - 10:00pm
End: 
Thursday, July 26, 2018 - 11:00pm
Description

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. 

Last updated: 
Thursday, July 26, 2018 - 11:00pm
Start: 
Thursday, April 5, 2018 - 6:00pm
End: 
Thursday, April 5, 2018 - 8:00pm
Description

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. 

Last updated: 
Thursday, April 5, 2018 - 8:00pm

Microsoft SQL Server Hosting and Administration Contact Information

Contact ITS SQL Server Support at ITS-SQL-Help@uiowa.edu