Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-30 : 11:19:06
|
Michael writes "We are using NT 4.0 w/SP6a, MS SQL 7.0 w/SP1 on a Compaq DL380. The server is comprised of one Intel P-III 667, 256M RAM, Mirrored 18.2 Gig HDD via Compaq array controller and one Intel PRO/100 Intelligent NIC that is full duplexed within an Intel 510 Switch.
When I run the following statement, "SELECT empid FROM emphours" via Query Analyzer the results of the search takes 1:09 minutes to return 155243 records. I have run the same statement on the server itself via query analyzer and it takes 0:06 minutes to return the same results.
I have created, analyzed and reindexed the indexes and nothing seems to change the outcome. I have tuned NT to be an app server under the server properties. I have monitored the traffic on the backbone and there is less then 20% traffic at any give time. I have run Performance Monitor on the server and watched Processor, Page/Faults and Disk access. When the query is executed via query analyzer on the server the processor spikes and for about three seconds and the memory and disk accesses are less the 5%.
Has anyone dealt with this issue in the past?
FYI - We are using IP only, not Named Pipes." |
|
|
|
|
|
Slow return on select statement