Resource Isolation of Multiple SQL Instances

Hello,
I would like to know (without experimentation) if by using two instances of
SQL Server I can isolate a first database which requires high repeatability
in query update times from another much larger second database which may
consume both more CPU and memory resources.
Assume: (let me know also if this cannot be done)
(a) that the server has dual processors each SQL instance is assigned to its
own CPU.
(b) that I have allocated separate memory to each instance.
(I have read that the overall performance for a single instance is better
than multiple instances on the same server. This fact may be irrelavent if
I can live with a degraded overall performance but guarantee that the
instances are adequately isolated and queries remain repeatable on the first
database.)
Thanks in advance,
Ted HannahTed,
I think you've got the hang of it.
One thing to consider is that the DBMS relies on the OS. So, when the DBMS
has a lot to do, then the OS will place a heavier load as well. And, in your
scenario, you only have one OS. This means that your "OLTP" database will
still be somewhat affected by your "reporting" database (I'm guessing where
regarding OLTP and reporting). I don't think I've ever seen any tests on how
much this "bleeding" one can expect, but I'd thought I at least mention it.
My guess is that it won't be that much - main resource usage would be inside
each SQL Server.
--
Tibor Karaszi
"Ted Hannah" <tedhannah@.hotmail.com> wrote in message
news:eGVF6eyoDHA.2404@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I would like to know (without experimentation) if by using two instances
of
> SQL Server I can isolate a first database which requires high
repeatability
> in query update times from another much larger second database which may
> consume both more CPU and memory resources.
> Assume: (let me know also if this cannot be done)
> (a) that the server has dual processors each SQL instance is assigned to
its
> own CPU.
> (b) that I have allocated separate memory to each instance.
> (I have read that the overall performance for a single instance is better
> than multiple instances on the same server. This fact may be irrelavent
if
> I can live with a degraded overall performance but guarantee that the
> instances are adequately isolated and queries remain repeatable on the
first
> database.)
>
> Thanks in advance,
> Ted Hannah
>|||Thanks - I would be very interested if anyone has measured this with some
real test. It would save some time. Speculation, unfortunately, won't be
good enough.
TED
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:_22qb.32395$mU6.93437@.newsb.telia.net...
> Ted,
> I think you've got the hang of it.
> One thing to consider is that the DBMS relies on the OS. So, when the DBMS
> has a lot to do, then the OS will place a heavier load as well. And, in
your
> scenario, you only have one OS. This means that your "OLTP" database will
> still be somewhat affected by your "reporting" database (I'm guessing
where
> regarding OLTP and reporting). I don't think I've ever seen any tests on
how
> much this "bleeding" one can expect, but I'd thought I at least mention
it.
> My guess is that it won't be that much - main resource usage would be
inside
> each SQL Server.
> --
> Tibor Karaszi
>
> "Ted Hannah" <tedhannah@.hotmail.com> wrote in message
> news:eGVF6eyoDHA.2404@.TK2MSFTNGP12.phx.gbl...
> > Hello,
> >
> > I would like to know (without experimentation) if by using two instances
> of
> > SQL Server I can isolate a first database which requires high
> repeatability
> > in query update times from another much larger second database which may
> > consume both more CPU and memory resources.
> > Assume: (let me know also if this cannot be done)
> > (a) that the server has dual processors each SQL instance is assigned to
> its
> > own CPU.
> > (b) that I have allocated separate memory to each instance.
> >
> > (I have read that the overall performance for a single instance is
better
> > than multiple instances on the same server. This fact may be irrelavent
> if
> > I can live with a degraded overall performance but guarantee that the
> > instances are adequately isolated and queries remain repeatable on the
> first
> > database.)
> >
> >
> > Thanks in advance,
> > Ted Hannah
> >
> >
>|||IO contention will continue to be a problem unless the databases are on
different PCI Busses, Controllers,and disks.
There are not any internal OS bottlenecks that I have seen that would
prevent you from successfully isolating workloads like this, but in a large
hetergeneous environment, it makes sense to keep the DSS and OLAP stuff on
different machines than OLTP. If you're looking at one server for two apps
and can seperate the IO channels, memory, and CPU affinity, then I think you
won't have any issues.
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Ted Hannah" <tedhannah@.hotmail.com> wrote in message
news:u6IQbu#oDHA.2424@.TK2MSFTNGP10.phx.gbl...
> Thanks - I would be very interested if anyone has measured this with some
> real test. It would save some time. Speculation, unfortunately, won't be
> good enough.
> TED
> "Tibor Karaszi"
<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:_22qb.32395$mU6.93437@.newsb.telia.net...
> > Ted,
> >
> > I think you've got the hang of it.
> > One thing to consider is that the DBMS relies on the OS. So, when the
DBMS
> > has a lot to do, then the OS will place a heavier load as well. And, in
> your
> > scenario, you only have one OS. This means that your "OLTP" database
will
> > still be somewhat affected by your "reporting" database (I'm guessing
> where
> > regarding OLTP and reporting). I don't think I've ever seen any tests on
> how
> > much this "bleeding" one can expect, but I'd thought I at least mention
> it.
> > My guess is that it won't be that much - main resource usage would be
> inside
> > each SQL Server.
> >
> > --
> > Tibor Karaszi
> >
> >
> > "Ted Hannah" <tedhannah@.hotmail.com> wrote in message
> > news:eGVF6eyoDHA.2404@.TK2MSFTNGP12.phx.gbl...
> > > Hello,
> > >
> > > I would like to know (without experimentation) if by using two
instances
> > of
> > > SQL Server I can isolate a first database which requires high
> > repeatability
> > > in query update times from another much larger second database which
may
> > > consume both more CPU and memory resources.
> > > Assume: (let me know also if this cannot be done)
> > > (a) that the server has dual processors each SQL instance is assigned
to
> > its
> > > own CPU.
> > > (b) that I have allocated separate memory to each instance.
> > >
> > > (I have read that the overall performance for a single instance is
> better
> > > than multiple instances on the same server. This fact may be
irrelavent
> > if
> > > I can live with a degraded overall performance but guarantee that the
> > > instances are adequately isolated and queries remain repeatable on the
> > first
> > > database.)
> > >
> > >
> > > Thanks in advance,
> > > Ted Hannah
> > >
> > >
> >
> >
>

Req: how to deploy a SQL Client Alias to multiple clients

Hi there,
I'm looking for a quick way to setup/deploy an SQL alias on multiple
clients?
Due to an hw upgrade, we are moving our cluster to a new server, and we need
to setup on multiple clients a new SQL Client Alias and an ODBC System DSN.
I found that Sql Client Alias configuration are stored in a registry key,
but I don't know if exporting the hive from the first client and importing
in the remaining other will be ok
Thanks in advance
---
Silvio Accomando
Torre Informatica Srl
---Use regedit to expot the registry key and then use regedit to apply it to
the client.
Rand
This posting is provided "as is" with no warranties and confers no rights.

ReportViewer.SizeToReportContent - has anyone got an example?

I have an aspx 2.0 page using the ReportViewer control on SRS2005.
The report I am showing has drillthroughs to multiple other reports,
some of which fit on the screen and some are wider than the screen.
I would like to dynamically size the control so it matches the
interactive size of the report currently being displayed by drill
through. That way scroll bars would appear on the outside of the web
browser only when required.
I cant figure out how to do this.
I have tried setting ReportViewer1.SizeToReportContent = true; in both
ReportViewer_Drillthrough and Page_Load events but to no avail.
Has anyone got an example of this working?
Thanks,
Renato
To be clear this is what I have in the aspx:
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
Width="98%" Height="600px"
OnDrillthrough = "ReportViewer1_Drillthrough">
</rsweb:ReportViewer>
In the cs:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ReportViewer1.PromptAreaCollapsed = true;
ReportViewer1.ShowBackButton = true;
ReportViewer1.HyperlinkTarget = "_self";
ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
Systm.Uri oReportServer = new
System.Uri("http://wrypgpdbs04/ReportServer/");
ReportViewer1.ServerReport.ReportServerUrl = oReportServer;
ReportViewer1.ServerReport.ReportPath = "/PGP/Sales/DailySales/DailySalesNavigation";
ReportViewer1.SizeToReportContent = true;
}
}
protected void ReportViewer1_Drillthrough(object sender,
Microsoft.Reporting.WebForms.DrillthroughEventArgs e)
{
ReportViewer1.SizeToReportContent = true;
}Hi, RBot
I would recommend removing the width and height property from the
declaration of the ReportViewer control, to see if that CSS style for
the control is not overriding the SizeToReportContent property. It
would seem that even though you set the property to true, you're
constraining the control in the browser by using those 2 style tags.
Hope that works.
Thiago
On Nov 22, 9:38 pm, "RBot" <renato_b...@.iprimus.com.au> wrote:
> I have an aspx 2.0 page using the ReportViewer control on SRS2005.
> The report I am showing has drillthroughs to multiple other reports,
> some of which fit on the screen and some are wider than the screen.
> I would like to dynamically size the control so it matches the
> interactive size of the report currently being displayed by drill
> through. That way scroll bars would appear on the outside of the web
> browser only when required.
> I cant figure out how to do this.
> I have tried setting ReportViewer1.SizeToReportContent = true; in both
> ReportViewer_Drillthrough and Page_Load events but to no avail.
> Has anyone got an example of this working?
> Thanks,
> Renato
> To be clear this is what I have in the aspx:
> <rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
> Width="98%" Height="600px"
> OnDrillthrough = "ReportViewer1_Drillthrough">
> </rsweb:ReportViewer>
> In the cs:
> protected void Page_Load(object sender, EventArgs e)
> {
> if (!Page.IsPostBack)
> {
> ReportViewer1.PromptAreaCollapsed = true;
> ReportViewer1.ShowBackButton = true;
> ReportViewer1.HyperlinkTarget = "_self";
> ReportViewer1.ProcessingMode => Microsoft.Reporting.WebForms.ProcessingMode.Remote;
> Systm.Uri oReportServer = new
> System.Uri("http://wrypgpdbs04/ReportServer/");
> ReportViewer1.ServerReport.ReportServerUrl = oReportServer;
> ReportViewer1.ServerReport.ReportPath => "/PGP/Sales/DailySales/DailySalesNavigation";
> ReportViewer1.SizeToReportContent = true;
> }
> }protected void ReportViewer1_Drillthrough(object sender,
> Microsoft.Reporting.WebForms.DrillthroughEventArgs e)
> {
> ReportViewer1.SizeToReportContent = true;
>
> }- Hide quoted text -- Show quoted text -|||Thanks Thiago,
I tried this but still get the scrollbars around a iframe-like area.
The report viewer now seems to inherit the width from its containing
div element, which in turn gets it from a shared stylesheet. I can set
the width of the div, but this is static, not responsive to the size of
the report.
I dont know what style to use to reset the width back to "vanilla".
tafs7 wrote:
> Hi, RBot
> I would recommend removing the width and height property from the
> declaration of the ReportViewer control, to see if that CSS style for
> the control is not overriding the SizeToReportContent property. It
> would seem that even though you set the property to true, you're
> constraining the control in the browser by using those 2 style tags.
> Hope that works.
> Thiago
>
> On Nov 22, 9:38 pm, "RBot" <renato_b...@.iprimus.com.au> wrote:
> > I have an aspx 2.0 page using the ReportViewer control on SRS2005.
> >
> > The report I am showing has drillthroughs to multiple other reports,
> > some of which fit on the screen and some are wider than the screen.
> > I would like to dynamically size the control so it matches the
> > interactive size of the report currently being displayed by drill
> > through. That way scroll bars would appear on the outside of the web
> > browser only when required.
> > I cant figure out how to do this.
> >
> > I have tried setting ReportViewer1.SizeToReportContent = true; in both
> > ReportViewer_Drillthrough and Page_Load events but to no avail.
> >
> > Has anyone got an example of this working?
> >
> > Thanks,
> > Renato
> >
> > To be clear this is what I have in the aspx:
> > <rsweb:ReportViewer ID="ReportViewer1" runat="server" Enabled="true"
> > Width="98%" Height="600px"
> > OnDrillthrough = "ReportViewer1_Drillthrough">
> > </rsweb:ReportViewer>
> > In the cs:
> > protected void Page_Load(object sender, EventArgs e)
> > {
> > if (!Page.IsPostBack)
> > {
> > ReportViewer1.PromptAreaCollapsed = true;
> > ReportViewer1.ShowBackButton = true;
> > ReportViewer1.HyperlinkTarget = "_self";
> > ReportViewer1.ProcessingMode => > Microsoft.Reporting.WebForms.ProcessingMode.Remote;
> > Systm.Uri oReportServer = new
> > System.Uri("http://wrypgpdbs04/ReportServer/");
> > ReportViewer1.ServerReport.ReportServerUrl = oReportServer;
> > ReportViewer1.ServerReport.ReportPath => > "/PGP/Sales/DailySales/DailySalesNavigation";
> > ReportViewer1.SizeToReportContent = true;
> > }
> >
> > }protected void ReportViewer1_Drillthrough(object sender,
> > Microsoft.Reporting.WebForms.DrillthroughEventArgs e)
> > {
> > ReportViewer1.SizeToReportContent = true;
> >
> >
> >
> > }- Hide quoted text -- Show quoted text -|||Just for the record I have sorted my issues with the ReportViewer web
control.
In the report definitions I need to ensure that the Report dimensions
are larger than the Page dimensions plus margins.
Once this is done the scrollbars dont appear for the ReportViewer
control.
Strangely this is never a problem when viewing reports directly on the
report server via http.
Renato