RE: SQL 2000 on SBS 2003 - can it be used without interfering

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Eric Cárdenas [MSFT] (ecardena_at_online.microsoft.com)
Date: 12/22/04


Date: Wed, 22 Dec 2004 00:35:19 GMT


>
> I just would like to know if perhaps there is any problem/performance
issue I
> should be aware of/or to configure if I use sql that comes with SBS 2003
> premium for our company intranet. I have not yet installed ISA (due to
> nervousness about configuring it). It seems that when I use it other
users
> on our LAN slow down... Will I be overtaxing the server if I use SQL? We
have
> 1 GB of memory and plenty of hard drive space. I thought that since SQL
is
> much better at concurrent users, that I would build the intranet with it
as
> the database instead of Access. But, when testing, I have other domain
users
> complaining that their computers are slow. Is this possible.. Am I
missing
> some configuration to make it perform optimally?
>
> Thanks for your assistance with this query.
--------------------
A well-written application will make sure that most processing is done on
the server side and only a small resultset is returned to the client. This
will ensure that network traffic is not impacted.

You will need to review how your application is written to abide by these.

--
Eric Cárdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.


Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)