Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila
"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila
"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Load Balancing

Hi,
I need a solution to perform load balancing on my OLTP database, for example
between two servers.
Any help would be greatly appreciated,
Leila"Leila" <Leilas@.hotpop.com> wrote in message
news:O9er3Ei1EHA.3540@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I need a solution to perform load balancing on my OLTP database, for
> example
> between two servers.
> Any help would be greatly appreciated,
> Leila
>
SQL Server does not do load balancing automatically.
You should look at partitioning your data and using partitioned views to
build a pseudo-load balanced set of database tables.
Check out Partitioned Data in the BOL.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

List of RS Scheduler APIs or RS APIs

I know there are a lot of functionality that perform using the RS APIs. I
found a few APIs in a book, but what I want to know is where can I find the
entire list of RS APIs. I would like to instruct the RS Scheduler to run a
report once programmatically. Is there an API to do this?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_ref_soapapi_service_ak_79mc.asp
--
| Thread-Topic: List of RS Scheduler APIs or RS APIs
| thread-index: AcWpuEec7kvS1x9uTXuokHk0gH3pvQ==| X-WBNR-Posting-Host: 12.13.183.98
| From: "=?Utf-8?B?cmljaGFyZA==?=" <richard@.discussions.microsoft.com>
| Subject: List of RS Scheduler APIs or RS APIs
| Date: Thu, 25 Aug 2005 14:02:19 -0700
| Lines: 4
| Message-ID: <75F0139F-AE96-4D30-B04F-248D8AB9C941@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51153
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I know there are a lot of functionality that perform using the RS APIs.
I
| found a few APIs in a book, but what I want to know is where can I find
the
| entire list of RS APIs. I would like to instruct the RS Scheduler to run
a
| report once programmatically. Is there an API to do this?
||||Brad,
Thank you so much, this is what I have been looking for!!!
""Brad Syputa - MS"" wrote:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
> rsp_ref_soapapi_service_ak_79mc.asp
> --
> | Thread-Topic: List of RS Scheduler APIs or RS APIs
> | thread-index: AcWpuEec7kvS1x9uTXuokHk0gH3pvQ==> | X-WBNR-Posting-Host: 12.13.183.98
> | From: "=?Utf-8?B?cmljaGFyZA==?=" <richard@.discussions.microsoft.com>
> | Subject: List of RS Scheduler APIs or RS APIs
> | Date: Thu, 25 Aug 2005 14:02:19 -0700
> | Lines: 4
> | Message-ID: <75F0139F-AE96-4D30-B04F-248D8AB9C941@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:51153
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I know there are a lot of functionality that perform using the RS APIs.
> I
> | found a few APIs in a book, but what I want to know is where can I find
> the
> | entire list of RS APIs. I would like to instruct the RS Scheduler to run
> a
> | report once programmatically. Is there an API to do this?
> |
>