ITPub博客

首页 > 数据库 > 数据库开发技术 > If SQL 2005 is slower than 2000 (gethering.....)

If SQL 2005 is slower than 2000 (gethering.....)

原创 数据库开发技术 作者:xxdxxdxxd 时间:2007-01-03 14:13:59 0 删除 编辑
  • try running profiler for some time during these operations. help identifying the bottleneck(check for locks)...also check the transaction isolation levels u had earlier and now....
  • Have you rebuild your indexes and updated your statistics? SQL 2005 might choose a poor plan if you fail to do so since the engine has changed between 2000 and 2005
[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/1697933/viewspace-888080/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ASP sending Email
下一篇: MySQL 5.0 新特性
请登录后发表评论 登录
全部评论

注册时间:2008-09-15

  • 博文量
    56
  • 访问量
    510733