Re: SQL Server extremely slow

"Niranjan" <nhiras@xxxxxxxxx> wrote in message news:0da278a5-a08a-4f3e-bcc3-


Or if you think its not the "network" can you please explain why.
I really appreciate your responses.....

Well, the speed of the network is very important. You not 100% clear here if
the performance issue did not exist before when those users outside of the
building hit the back end direct, or in fact the SAME TIME you went to sql
server is the SAME TIME you allowed those "remote" type of users to grab
data?

I would be VERY VERY surprised if those remote users had good performance
before sql server was adopted.

I explain how/why/what you can do to resolve users performance on a wan
here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

If you moved some users from you LAN to a WAN, then sql server should be
able to get you decent performance with not a whole lot of changes.

so, are thsoe new users on a wan? Take a read of the above article...it
should help...



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx


.

Relevant Pages

  • Re: Access should be made to run on a Wide Area Network
    ... >destroyed our LAN and we were forced to move everything to another state. ... >Our network now operates on a WAN. ... - Use MSDE or SQL Express to migrate your data to a SQL server (with ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Server extremely slow
    ... the speed of the network is very important. ... I would be VERY VERY surprised if those remote users had good performance ... before sql server was adopted. ... I explain how/why/what you can do to resolve users performance on a wan ...
    (comp.databases.ms-access)
  • NEW SBS 2003 Purchase
    ... I am the admin of a small network. ... users over our WAN for a total of 39 users. ... that utilizes MS SQL server and all need access to e-mail. ... this machine will need to be my PDC. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: NEW SBS 2003 Purchase
    ... > I am the admin of a small network. ... > users over our WAN for a total of 39 users. ... > that utilizes MS SQL server and all need access to e-mail. ... this machine will need to be my PDC. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Sooooooooo Slooooooow
    ... Is there a real benefit for the OP when using SQL Server as a backend ... over a slow Wan ?? ... in cases where your app simply MUST pull a lot of data (certain ... internet and it worked pretty well. ...
    (comp.databases.ms-access)