anyone use a 3rd party product to load balance SQL Server?

I'm working on a project needing a high-end large mission critical database
solution. The data is in 1 database. So SQL 2000 doesn't support load
balancing, and neither will 2005. That sucks. Oracle supposedly does load
balancing and I can't understand why even SQL Server 2005 won't do it. So
either I go with an 8+ CPU SQL Server or consider a 3rd party load balancer
that will somehow (?) make it work so that multiple SQL brains can balance
the load of 1 single database that is presumably shared on 1 set of disks.
I'm finding very little information on load balancing SQL Server when
searching the net. Is there a product like Legato, for example, (I haven't
tried it) that will somehow give me load balancing with SQL Server?HK wrote:
> I'm working on a project needing a high-end large mission critical
> database solution. The data is in 1 database. So SQL 2000 doesn't
> support load balancing, and neither will 2005. That sucks. Oracle
> supposedly does load balancing and I can't understand why even SQL
> Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> consider a 3rd party load balancer that will somehow (?) make it work
> so that multiple SQL brains can balance the load of 1 single database
> that is presumably shared on 1 set of disks.
> I'm finding very little information on load balancing SQL Server when
> searching the net. Is there a product like Legato, for example, (I
> haven't tried it) that will somehow give me load balancing with SQL
> Server?
You may want to take a look at Federated Database Servers on SQL Server
2000/2005 if that architecture will work for you.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||"David Gugick" <david.gugick-nospam@.quest.com> wrote in message
news:uzLN8u5wFHA.3180@.TK2MSFTNGP14.phx.gbl...
> HK wrote:
> > I'm working on a project needing a high-end large mission critical
> > database solution. The data is in 1 database. So SQL 2000 doesn't
> > support load balancing, and neither will 2005. That sucks. Oracle
> > supposedly does load balancing and I can't understand why even SQL
> > Server 2005 won't do it. So either I go with an 8+ CPU SQL Server or
> > consider a 3rd party load balancer that will somehow (?) make it work
> > so that multiple SQL brains can balance the load of 1 single database
> > that is presumably shared on 1 set of disks.
> >
> > I'm finding very little information on load balancing SQL Server when
> > searching the net. Is there a product like Legato, for example, (I
> > haven't tried it) that will somehow give me load balancing with SQL
> > Server?
> You may want to take a look at Federated Database Servers on SQL Server
> 2000/2005 if that architecture will work for you.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
Creating the partitioned views sounds very challenging for an already-in-use
DB that needs to be cut over in the middle of the night. Plus ongoing
maintenance. Maybe I'm missing the boat, but that's why I'd want to stay
away from federated databases.

Any third-party freebies to administer MSDE?

Are there any third party freebies available to administer MSDE? I'm looking
to replace Interbase with MSDE, but I'll need some sort of Query Analyzer /
Admin interface to replace IBConsole which is free with Interbase. Is
anything like this available?
Thanks for your help,
Joe Geretz
This link may help.
http://www.microsoft.com/sql/msde/partners/default.asp
Jim
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:u91ZuEDGEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Are there any third party freebies available to administer MSDE? I'm
looking
> to replace Interbase with MSDE, but I'll need some sort of Query Analyzer
/
> Admin interface to replace IBConsole which is free with Interbase. Is
> anything like this available?
> Thanks for your help,
> Joe Geretz
>
|||http://www.aspfaq.com/2442
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Joseph Geretz" <jgeretz@.nospam.com> wrote in message
news:u91ZuEDGEHA.3856@.TK2MSFTNGP12.phx.gbl...
> Are there any third party freebies available to administer MSDE? I'm
> looking
> to replace Interbase with MSDE, but I'll need some sort of Query Analyzer
> /
> Admin interface to replace IBConsole which is free with Interbase. Is
> anything like this available?
> Thanks for your help,
> Joe Geretz
>
|||Joseph,

> Are there any third party freebies available to administer MSDE?
There aren't only 3rd party tools, have a look at MS Web Administrator:
http://www.microsoft.com/downloads/d...displaylang=en
The only disadvantage I can see is the poor performance.
I have also tested DbaMgr (http://www.asql.biz/DbaMgr.shtm) and the free
version of myLittleAdmin (http://www.mylittletools.net/scripts/en/mla_sql/).
For having a quick look at your databases, myLittleAdmin is very good.
Bye,
mm

Any 3rd party tools for integrating VSS w/ query analyzer or similar?

Are there any 3rd party tools that allow VSS to be directly intergrated with
Query Analyzer? Or are there replacements for Query Analyzer that have VSS
built in?
We found http://www.mssqlXpress.com , but it likely has more bells and
whistles than we need and/or want to pay for. We just need/want QA with VSS
built in ...
Thanks in advance!
MarkOne thing you can do is add VSS to the external tools in Query analyzer
passing command line parameters...
SS.exe I think is VSS executable...For instance to check out the current
file..
Command: ss.exe
Arguments; checkout $(Filename)$(FileExt) -C-
Initial Directory: $(FileDir)
Ken Henderson covers some of this in his new book 'The Guru's Guide to SQL
Server Architecture and Internals'...
It's a good book , I recommend it.!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark" <mfield@.idonotlikespam.cce.umn.edu> wrote in message
news:eaeFIaxlDHA.2272@.tk2msftngp13.phx.gbl...
> Are there any 3rd party tools that allow VSS to be directly intergrated
with
> Query Analyzer? Or are there replacements for Query Analyzer that have
VSS
> built in?
> We found http://www.mssqlXpress.com , but it likely has more bells and
> whistles than we need and/or want to pay for. We just need/want QA with
VSS
> built in ...
> Thanks in advance!
> Mark
>