Building onto the system

The Houston Independent School District went live in September with Microsoft

Corp. SQL Server 6.5, which was the latest version of the database available

at the time. As the database grew over the first two to three months, and

more and more people were accessing the system, HISD experienced poor response

time and system locks, said Daryl Ann Borel, HISD assistant superintendent

for technology and information systems.

In January 1999, officials decided to upgrade to the newly available

SQL Server 7.0.

"The upgrade was completed in early March and was extremely successful,''

Borel said. "Response time improved 300 percent, the average wait time was

reduced 876 percent, and the system locks declined to zero." SQL Server

7.0 provides SAP's ERP package with a solid database foundation by increasing

system availability and response time and economizing database size, Borel

said. SQL Server's efficient architecture shrank the previously 45G database

to 30G, saving disk space and increasing performance.

"SQL Server's robust processing capabilities cut data processing time

considerably, and system administration is now simpler than ever," she said.

"Batch and background processing, which previously took three to four hours,

now takes less than 30 minutes to complete. The time needed to generate

reports was cut from a maximum of one hour to less than 15 minutes."

Featured

  • Defense
    The Pentagon (Photo by Ivan Cholakov / Shutterstock)

    DOD CIO hits pause on JEDI cloud acquisition

    Dana Deasy set cloud as his office's top priority. But when it comes to the JEDI request for proposal, he's directed staff to "pause" to compile a comprehensive review.

  • Cybersecurity
    By Gorodenkoff shutterstock ID 761940757

    Waging cyber war without a rulebook

    As the U.S. looks to go on the offense in the cyber domain, critical questions remain unanswered around who will take the lead and how clearly to draw the rules of engagement.

  • Government Innovation Awards
    Government Innovation Awards - https://governmentinnovationawards.com

    Deadline extended for Rising Star nominations

    You now have until July 18 to help us identify the early-career innovators and change agents in government IT.

Stay Connected

FCW Update

Sign up for our newsletter.

I agree to this site's Privacy Policy.