Re: Transition from Stand-ALone SQL Server to Cluster

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

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 01/23/05 

Date: Sun, 23 Jan 2005 22:25:49 +0100

Hi

What about separating the application from the DB? Running an application
server and DB on the same machine does not help performance as both
processes contend for the same resources.

Turning your infrastructure into true multi-tier might help. If your
application has to run on the DB server, you have a bad application and slap
your vendor.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"dark_15" <dark15@discussions.microsoft.com> wrote in message
news:4B604AFF-9459-4C61-BD9D-0E6A797E19AC@microsoft.com...
> We do need more space. A LOT more space, which was the reason for
possibly
> purchasing the SAN kit. And I was thinking that a seperate server will
help
> minimize any conflicts between the two databases.
>
> Our current server has a huge pagefile (plus a severe performance drop)
and
> very little physical memory (only a few megabytes) available when both
> programs are run simultaneously. When only the first database and app is
> run, we have plenty of physical memory (about 1 GB free) and the pagefile
use
> drops dramatically. So then I concluded that the second database/app is
the
> culprit for drop in performance and we need a heftier server for that
> database/app.
>
>
> Thanks for the help!
>
> And BBQ ribs are good... ;-)

Relevant Pages

  • Re: Problem with big data transfer
    ... Mike Epprecht, Microsoft SQL Server MVP ... MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.clients)
  • Re: Transition from Stand-ALone SQL Server to Cluster
    ... And I was thinking that a seperate server will help ... Our current server has a huge pagefile (plus a severe performance drop) and ... we have plenty of physical memory and the pagefile use ... So then I concluded that the second database/app is the ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to make a select to another database using sp_addlinkedserver?
    ... Mike Epprecht, Microsoft SQL Server MVP ... Zurich, Switzerland ... MVP Program: http://www.microsoft.com/mvp ...
    (microsoft.public.sqlserver.connect)
  • Re: Save as in SQL Server(Backup - Restore)
    ... "Dan Guzman" wrote in message ... > SQL Server MVP ... I take it you already know about the RESTORE command ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: SP accessing other db
    ... regarding the cross-database chaining server option. ... Now the database name is hard-coded. ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.security)