在Windows 7中使用Microsoft SQL Server 2008进行缓慢查询. [英] Slow query using microsoft sql server 2008 in windows 7..

问题描述

Hi..i遇到一个问题，当我尝试在Windows 7中使用Microsoft sql server 2008访问数据库时，查询速度非常慢，大约5 -10秒.使用本地PC进行查询，但是它仍然很慢..所以我想这不是由tcp引起的问题..但是我不确定它有什么问题..我尝试了几种Google方式，包括转向LLMNR的版本，更改sql management studio的兼容性，但是失败了.有人可以帮助我吗?

Hi..i face a problem that when i try to access database using microsoft sql server 2008 in windows 7, the query is quite slow, about 5 -10 seconds..I try not using client pc to access it and just using local pc to query, but the it is still slow..so I guess it is not a problem caused by tcp..but i am not sure what''s wrong with it..I try several ways from google, including turning of LLMNR, change the compatibility of sql management studio but failed..anyone can help me?

推荐答案

通过索引优化向导运行查询:http://www.datasprings.com/resources/articles-information/sql-server -2008-profiler-and-tuning-wizard [ ^ ]

Run your queries through the Index Tuning Wizard : http://www.datasprings.com/resources/articles-information/sql-server-2008-profiler-and-tuning-wizard[^]

这篇关于在Windows 7中使用Microsoft SQL Server 2008进行缓慢查询.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！