Objective To optimize the database of LIS, and ensure the efficient operation. Methods Using system software and resource monitor software, server and database usage of LIS was monitored and system was optimized for existing problem. Increasing the server memory to 12 G, the several separate tables space were created for different projects. With class-based policy, SQL Server parameters, queries and indexes were optimized. Results Time sharing processing with storage procedures and task scheduling was realized, which ensured the normal operation of the server and avoided hardware investment of changing server. Conclusion With the smallest economic value and shortest time, this study solved the problem that LIS database operated slow or cannot use last for more than ten years%目的 优化检验信息系统数据库,保证系统高效运行.方法 使用系统自带以及资源监控软件监测检验信息系统服务器和数据库使用情况,针对存在的问题对系统进行优化.增加服务器内存至12 G,为不同的业务分别创建单独的表空间,采用分级存储策略,同时优化了SQL Server配置参数、查询语句及索引.结果 实现了LIS使用存储过程和作业调度分时处理,保证了服务器的正常运行,同时也避免了更换服务器这种高额的硬件投资.结论 以最小的经济价值及最短的时间,解决了运行十余年的检验信息系统数据库慢或者无法使用的问题.
展开▼
