SQL on separate machine very slow 
Author Message
 SQL on separate machine very slow

I have been running SQL server 7 SP2 on the same machine as my IIS
server until a few days ago and now it is on a separate machine on the
network.  The performance is much worse, but I thought SQL was designed
to be run on it's own machine.  I had been connecting using OLEDB and
changing that to ODBC seemed to speed it up a little, but performance
is still much slower than it should be.

I am wondering if there are any settings or things I should check to
make this setup work properly.

Thanks,
Bryan Whitaker

Sent via Deja.com http://www.***.com/
Before you buy.



Fri, 04 Apr 2003 03:00:00 GMT
 SQL on separate machine very slow

Bryan,

Is the hardware, OS etc the same or better on the new server? It can take a
while for SQL server (depending on several things) to run at it's peak again
after a fresh start. Are the stats up to date on all the tables? Try running
sp_Updatestats and recompile your sp's.

--
Andrew J. Kelly
Targitmail.com


Quote:
> I have been running SQL server 7 SP2 on the same machine as my IIS
> server until a few days ago and now it is on a separate machine on the
> network.  The performance is much worse, but I thought SQL was designed
> to be run on it's own machine.  I had been connecting using OLEDB and
> changing that to ODBC seemed to speed it up a little, but performance
> is still much slower than it should be.

> I am wondering if there are any settings or things I should check to
> make this setup work properly.

> Thanks,
> Bryan Whitaker

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Fri, 04 Apr 2003 03:00:00 GMT
 SQL on separate machine very slow

Check the network setup, something could be setup incorrectly.  A similar
issue occurred at my last job and we found out that one of the dual network
cables were no securely plugged in.

Good luck.


Quote:
> I have been running SQL server 7 SP2 on the same machine as my IIS
> server until a few days ago and now it is on a separate machine on the
> network.  The performance is much worse, but I thought SQL was designed
> to be run on it's own machine.  I had been connecting using OLEDB and
> changing that to ODBC seemed to speed it up a little, but performance
> is still much slower than it should be.

> I am wondering if there are any settings or things I should check to
> make this setup work properly.

> Thanks,
> Bryan Whitaker

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Fri, 04 Apr 2003 03:00:00 GMT
 SQL on separate machine very slow

Somewhat worse could be expected, but you would
have to define *much* in quantifiable units.

When benchmarking data access technologies such
as ADO, ODBC and OLE DB it is necessary to use
multiple machines to simulate real world scenarios.
Running tests on a single box produces results that
differ significantly from a muti-machine environment,
and often lead to inaccurate blanket statements
about technique 'x' always being faster than 'y'.

--
Michael D. Long
http://extremedna.homestead.com


Quote:
> I have been running SQL server 7 SP2 on the same machine as my IIS
> server until a few days ago and now it is on a separate machine on the
> network.  The performance is much worse, but I thought SQL was designed
> to be run on it's own machine.  I had been connecting using OLEDB and
> changing that to ODBC seemed to speed it up a little, but performance
> is still much slower than it should be.

> I am wondering if there are any settings or things I should check to
> make this setup work properly.

> Thanks,
> Bryan Whitaker

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 09 Apr 2003 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. sql server and win2k on separate machines

2. Can't run IIS and SQL Server on Separate Machines with Trusted Connection

3. separate machines for IIS and SQL 7.0

4. SQL server 2000 and IIS 5 server in separate machine

5. Windows Authentication with IIS on separate machines

6. 6.5 To 7.0 upgrade on separate machines

7. Views and indexes on tables held on a separate server/machine

8. duplicating master database between 2 separate machines ??

9. HELP!- slow VB/SQL app on Win95 machines!

10. slow VB/SQL app on Win95 machines

11. slow VB/SQL app on Win95 machines

12. slow VB/SQL app on Win95 machines


 
Powered by phpBB® Forum Software