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
    Ryan D. McCarthy being sworn in as Army Secretary Oct. 10, 2019. (Photo credit: Sgt. Dana Clarke/U.S. Army)

    Army wants to spend nearly $1B on cloud, data by 2025

    Army Secretary Ryan McCarthy said lack of funding or a potential delay in the JEDI cloud bid "strikes to the heart of our concern."

  • Congress
    Rep. Jim Langevin (D-R.I.) at the Hack the Capitol conference Sept. 20, 2018

    Jim Langevin's view from the Hill

    As chairman of of the Intelligence and Emerging Threats and Capabilities subcommittee of the House Armed Services Committe and a member of the House Homeland Security Committee, Rhode Island Democrat Jim Langevin is one of the most influential voices on cybersecurity in Congress.

Stay Connected

FCW INSIDER

Sign up for our newsletter.

I agree to this site's Privacy Policy.