Re: SQL Server extremely slow

On Mar 9, 4:27 pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal...@xxxxxxx>
wrote:
"Niranjan" <nhi...@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
pleaseNOOSpamKal...@xxxxxxx

Thanks Albert for the response.

To answer your question...
We had "remote" users accessing the Access backend prior to the
upgrade to SQL. The speed was slightly slower then compared to our
"local" users. But now they are much more worse - there is hardly any
comparison.
I will read the article you sent me. But if you have any thoughts in
light of this new info, please dont hesitate to post them.
.

Relevant Pages

  • Re: setting up a remote location (another netbios domain, maybe)...
    ... across wan sites.... ... inside network neighborhood, ... IMHO 6 machines are few machines to justify a DC at remote location, ... overloading the wan link. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Backing up database on a network machine
    ... You cant see the network drives. ... You Should start SQL server using Domain user who got access to remote ... Now you can execute the Backup script with UNC path ...
    (microsoft.public.sqlserver.msde)
  • 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 ... If you moved some users from you LAN to a WAN, then sql server should be ...
    (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)