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

  • IT Modernization
    shutterstock image By enzozo; photo ID: 319763930

    OMB provides key guidance for TMF proposals amid surge in submissions

    Deputy Federal CIO Maria Roat details what makes for a winning Technology Modernization Fund proposal as agencies continue to submit major IT projects for potential funding.

  • gears and money (zaozaa19/Shutterstock.com)

    Worries from a Democrat about the Biden administration and federal procurement

    Steve Kelman is concerned that the push for more spending with small disadvantaged businesses will detract from the goal of getting the best deal for agencies and taxpayers.

Stay Connected