Slow performance of SQL Server Enterprise Edition
登录 | 论坛导航 -> 华新鲜事 -> 社会百科 | 本帖共有 1 楼,分 1 页, 当前显示第 1 页 : 本帖树形列表 : 刷新 : 返回上一页
<<始页  [1]  末页>>
作者:akid (等级:2 - 初出茅庐,发帖:84) 发表:2004-02-25 13:11:59  楼主  关注此帖
Slow performance of SQL Server Enterprise Edition
Hi, I've developed a database access module of a medium-size application using APO .NET on SQL Server 2000 Developer's edition under windows 2000. The desktop I'm using has P4 2.0GHz CPU and 512M memory. Now I'm doing testing on Sql Server 2000 Enterprize Edition under Windows Server 2003 Stardard edition. The server machine has 4 P4 3.06GHz CPU and 1G memory. Howevery, I founnd that insertion to the database is even slower than on my desktop! Say, insertion of 1000 records to the Sql Server on my desktop takes around 1860 ms, but 7280 ms on the server machine! Can anybody advise me what would be the possible cause of this unreasonable behaviour. Thanks a lot!
Put your OWN COOL signature here!
欢迎来到华新中文网,踊跃发帖是支持我们的最好方法!原文 / 传统版 / WAP版只看此人从这里展开收起列表
论坛导航 -> 华新鲜事 -> 社会百科 | 返回上一页 | 本主题共有 1 篇文章,分 1 页, 当前显示第 1 页 | 回到顶部
<<始页  [1]  末页>>

请登录后回复:帐号   密码