Opinions for best setup

We have a web server which needs instant results from our SQL Server.
We also have a lot of reports that are run at various times of the day
that hit against a few multi-million record tables and it bogs the SQL
server down. This in turn slows the response of the web server.
Can I setup two SQL Servers with replication or clustering or something
and have the web server hit one SQL server and the reports hit the
other server? Would the reports still bog down the web requests in
this setup (if it's possible)?
Other suggestions are welcome.
Thanks,
CYou can do this a number of ways depending on how up to date the reports
need to be. If you can live with data for the reports that is not real time
you can use log shipping or snapshot replication from the main SQL Server to
another server for the reporting. If it needs to be near real time then you
can use transactional replication. You can find more details on each in
BooksOnLine.
Andrew J. Kelly SQL MVP
"The Cornjerker" <addoty@.gmail.com> wrote in message
news:1131376846.542603.182480@.g44g2000cwa.googlegroups.com...
> We have a web server which needs instant results from our SQL Server.
> We also have a lot of reports that are run at various times of the day
> that hit against a few multi-million record tables and it bogs the SQL
> server down. This in turn slows the response of the web server.
>
> Can I setup two SQL Servers with replication or clustering or something
> and have the web server hit one SQL server and the reports hit the
> other server? Would the reports still bog down the web requests in
> this setup (if it's possible)?
>
> Other suggestions are welcome.
>
> Thanks,
> C
>