Abstract:Objective To optimize the database of LIS, and ensure the effi cient 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
s pace 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
邹向坤. 检验信息系统SQL数据库优化的研究[J]. 中国医疗设备, 2017, 32(6): 142-143.
ZOU Xiang-kun. Study of SQL Database Optimization for Laboratory Information System. China Medical Devices, 2017, 32(6): 142-143.