Production Vs Development

Hi,
I've just come into a new organisation and my unit's role is mostly
reporting on mostly OLAP type data (although our "warehouse" is pretty much
useless, and so we work off periodic snapshots of the OLTP data, which seems
to be tolerable performance-wise).
I'm having a bit of trouble coming to grips with their idea of
"Development", "Test", and "Production" environments.
First off, there is no such thing as "test", just dev and prod.
Next, the IT Department that manages the what they call "production" is
unrelated to my business unit. They are apparently very unresponsive and can
routinely take six months to effect any requested change to the "production"
reporting database objects. We have read-only access to the production
server/database.
To work around this, my unit has lapsed into the habit of running their
reports off the dev server (which they have control over). When I've pointed
out to them respectfully, that they appear to be doing production work on a
dev server, I come up against a brick wall.
"No." They say. "If we're not reporting off the production server, it's not
production reporting." But then they go on to publish these reports as
representative of the state of the business.
Now I would have though that any environment you use to produce outputs that
you regard as being a part of your business are defacto "production", but I'm
getting no traction with such a novel concept here.
It strikes me though, that Microsoft, given the price differential between
their development and production licensing would have a fairly water-tight
differentiation between dev and prod. What is MS's idea of the difference,
and where can I find a version of it that is written in words that grade
threes could cope with?
Cheers
GPOWhat you have is a problem in the leadership (or rather lack of it) of your
organization. If you want the kind of change you've described, a document
from Microsoft isn't going to change anything.
If you can get a server, load an Express version on it and declare it a
production instance. Then move the reporting to it as you can. Lead by
example.
"GPO" <GPO@.discussions.microsoft.com> wrote in message
news:2FC64B51-5540-4FF0-81DF-7E690ACD3645@.microsoft.com...
> Hi,
> I've just come into a new organisation and my unit's role is mostly
> reporting on mostly OLAP type data (although our "warehouse" is pretty
> much
> useless, and so we work off periodic snapshots of the OLTP data, which
> seems
> to be tolerable performance-wise).
> I'm having a bit of trouble coming to grips with their idea of
> "Development", "Test", and "Production" environments.
> First off, there is no such thing as "test", just dev and prod.
> Next, the IT Department that manages the what they call "production" is
> unrelated to my business unit. They are apparently very unresponsive and
> can
> routinely take six months to effect any requested change to the
> "production"
> reporting database objects. We have read-only access to the production
> server/database.
> To work around this, my unit has lapsed into the habit of running their
> reports off the dev server (which they have control over). When I've
> pointed
> out to them respectfully, that they appear to be doing production work on
> a
> dev server, I come up against a brick wall.
> "No." They say. "If we're not reporting off the production server, it's
> not
> production reporting." But then they go on to publish these reports as
> representative of the state of the business.
> Now I would have though that any environment you use to produce outputs
> that
> you regard as being a part of your business are defacto "production", but
> I'm
> getting no traction with such a novel concept here.
> It strikes me though, that Microsoft, given the price differential between
> their development and production licensing would have a fairly water-tight
> differentiation between dev and prod. What is MS's idea of the difference,
> and where can I find a version of it that is written in words that grade
> threes could cope with?
> Cheers
> GPO
>|||I cling to the hope that some basic guidelines from MS will help. I don't
think management is dishonest; merely incompetent. Question is "Where can I
find such guidelines - and written in a way that even my management could
understand?"
The other thing is that SQL Express might not be appropriate anyway. I
thought Express was not intended for an enterprise sized operation, and the
4GB limit would kill us if nothing else.
Regards
GPO
"Jay" wrote:
> What you have is a problem in the leadership (or rather lack of it) of your
> organization. If you want the kind of change you've described, a document
> from Microsoft isn't going to change anything.
> If you can get a server, load an Express version on it and declare it a
> production instance. Then move the reporting to it as you can. Lead by
> example.
> "GPO" <GPO@.discussions.microsoft.com> wrote in message
> news:2FC64B51-5540-4FF0-81DF-7E690ACD3645@.microsoft.com...
> > Hi,
> >
> > I've just come into a new organisation and my unit's role is mostly
> > reporting on mostly OLAP type data (although our "warehouse" is pretty
> > much
> > useless, and so we work off periodic snapshots of the OLTP data, which
> > seems
> > to be tolerable performance-wise).
> >
> > I'm having a bit of trouble coming to grips with their idea of
> > "Development", "Test", and "Production" environments.
> >
> > First off, there is no such thing as "test", just dev and prod.
> > Next, the IT Department that manages the what they call "production" is
> > unrelated to my business unit. They are apparently very unresponsive and
> > can
> > routinely take six months to effect any requested change to the
> > "production"
> > reporting database objects. We have read-only access to the production
> > server/database.
> >
> > To work around this, my unit has lapsed into the habit of running their
> > reports off the dev server (which they have control over). When I've
> > pointed
> > out to them respectfully, that they appear to be doing production work on
> > a
> > dev server, I come up against a brick wall.
> >
> > "No." They say. "If we're not reporting off the production server, it's
> > not
> > production reporting." But then they go on to publish these reports as
> > representative of the state of the business.
> >
> > Now I would have though that any environment you use to produce outputs
> > that
> > you regard as being a part of your business are defacto "production", but
> > I'm
> > getting no traction with such a novel concept here.
> >
> > It strikes me though, that Microsoft, given the price differential between
> > their development and production licensing would have a fairly water-tight
> > differentiation between dev and prod. What is MS's idea of the difference,
> > and where can I find a version of it that is written in words that grade
> > threes could cope with?
> >
> > Cheers
> >
> > GPO
> >
>
>|||MS might do a lot of things but one thing they don't do is dictate the
opeartional policies of your company.
That is a role of the Senior Management team of your company.
You talk about 'my unit'. Are you the Manager of 'my unit'? If you are then
simply issue a written instruction to all members of 'my unit' setting out
how things shall work and require that they acknowledge, in writing, that
they have read and understood the instruction. After that, if anyone
disregards the instruction then it becomes a disciplinary matter.
Is the Senior Management of the company aware of the 'unreponsive'ness of
the production IT team? If not then make them aware of it. If I were on the
Senior Management team and that sort of information came to my attention I
would be doing some very serious backside kicking.
"GPO" <GPO@.discussions.microsoft.com> wrote in message
news:7A2C1D04-3FEA-4A06-9C9F-70FEC67659F9@.microsoft.com...
>I cling to the hope that some basic guidelines from MS will help. I don't
> think management is dishonest; merely incompetent. Question is "Where can
> I
> find such guidelines - and written in a way that even my management could
> understand?"
> The other thing is that SQL Express might not be appropriate anyway. I
> thought Express was not intended for an enterprise sized operation, and
> the
> 4GB limit would kill us if nothing else.
> Regards
> GPO
> "Jay" wrote:
>> What you have is a problem in the leadership (or rather lack of it) of
>> your
>> organization. If you want the kind of change you've described, a document
>> from Microsoft isn't going to change anything.
>> If you can get a server, load an Express version on it and declare it a
>> production instance. Then move the reporting to it as you can. Lead by
>> example.
>> "GPO" <GPO@.discussions.microsoft.com> wrote in message
>> news:2FC64B51-5540-4FF0-81DF-7E690ACD3645@.microsoft.com...
>> > Hi,
>> >
>> > I've just come into a new organisation and my unit's role is mostly
>> > reporting on mostly OLAP type data (although our "warehouse" is pretty
>> > much
>> > useless, and so we work off periodic snapshots of the OLTP data, which
>> > seems
>> > to be tolerable performance-wise).
>> >
>> > I'm having a bit of trouble coming to grips with their idea of
>> > "Development", "Test", and "Production" environments.
>> >
>> > First off, there is no such thing as "test", just dev and prod.
>> > Next, the IT Department that manages the what they call "production" is
>> > unrelated to my business unit. They are apparently very unresponsive
>> > and
>> > can
>> > routinely take six months to effect any requested change to the
>> > "production"
>> > reporting database objects. We have read-only access to the production
>> > server/database.
>> >
>> > To work around this, my unit has lapsed into the habit of running their
>> > reports off the dev server (which they have control over). When I've
>> > pointed
>> > out to them respectfully, that they appear to be doing production work
>> > on
>> > a
>> > dev server, I come up against a brick wall.
>> >
>> > "No." They say. "If we're not reporting off the production server, it's
>> > not
>> > production reporting." But then they go on to publish these reports as
>> > representative of the state of the business.
>> >
>> > Now I would have though that any environment you use to produce outputs
>> > that
>> > you regard as being a part of your business are defacto "production",
>> > but
>> > I'm
>> > getting no traction with such a novel concept here.
>> >
>> > It strikes me though, that Microsoft, given the price differential
>> > between
>> > their development and production licensing would have a fairly
>> > water-tight
>> > differentiation between dev and prod. What is MS's idea of the
>> > difference,
>> > and where can I find a version of it that is written in words that
>> > grade
>> > threes could cope with?
>> >
>> > Cheers
>> >
>> > GPO
>> >
>>|||"...MS might do a lot of things but one thing they don't do is dictate the
opeartional policies of your company..."
Yes but surely they'd take an interest in whether people were purchasing
developer software (cheap cheap cheap) and then using it in a production
capacity. My question is how do they make this judgement?
Sadly it's not "my unit" in the sense that I manage it. I don't. I say "my
unit" because it's the unit I work for.
"...Is the Senior Management of the company aware of the 'unreponsive'ness
..." Well it's a large government department. Unresponsiveness is culturally
ingrained.
"Stephany Young" wrote:
> MS might do a lot of things but one thing they don't do is dictate the
> opeartional policies of your company.
> That is a role of the Senior Management team of your company.
> You talk about 'my unit'. Are you the Manager of 'my unit'? If you are then
> simply issue a written instruction to all members of 'my unit' setting out
> how things shall work and require that they acknowledge, in writing, that
> they have read and understood the instruction. After that, if anyone
> disregards the instruction then it becomes a disciplinary matter.
> Is the Senior Management of the company aware of the 'unreponsive'ness of
> the production IT team? If not then make them aware of it. If I were on the
> Senior Management team and that sort of information came to my attention I
> would be doing some very serious backside kicking.
>
> "GPO" <GPO@.discussions.microsoft.com> wrote in message
> news:7A2C1D04-3FEA-4A06-9C9F-70FEC67659F9@.microsoft.com...
> >I cling to the hope that some basic guidelines from MS will help. I don't
> > think management is dishonest; merely incompetent. Question is "Where can
> > I
> > find such guidelines - and written in a way that even my management could
> > understand?"
> >
> > The other thing is that SQL Express might not be appropriate anyway. I
> > thought Express was not intended for an enterprise sized operation, and
> > the
> > 4GB limit would kill us if nothing else.
> >
> > Regards
> >
> > GPO
> >
> > "Jay" wrote:
> >
> >> What you have is a problem in the leadership (or rather lack of it) of
> >> your
> >> organization. If you want the kind of change you've described, a document
> >> from Microsoft isn't going to change anything.
> >>
> >> If you can get a server, load an Express version on it and declare it a
> >> production instance. Then move the reporting to it as you can. Lead by
> >> example.
> >>
> >> "GPO" <GPO@.discussions.microsoft.com> wrote in message
> >> news:2FC64B51-5540-4FF0-81DF-7E690ACD3645@.microsoft.com...
> >> > Hi,
> >> >
> >> > I've just come into a new organisation and my unit's role is mostly
> >> > reporting on mostly OLAP type data (although our "warehouse" is pretty
> >> > much
> >> > useless, and so we work off periodic snapshots of the OLTP data, which
> >> > seems
> >> > to be tolerable performance-wise).
> >> >
> >> > I'm having a bit of trouble coming to grips with their idea of
> >> > "Development", "Test", and "Production" environments.
> >> >
> >> > First off, there is no such thing as "test", just dev and prod.
> >> > Next, the IT Department that manages the what they call "production" is
> >> > unrelated to my business unit. They are apparently very unresponsive
> >> > and
> >> > can
> >> > routinely take six months to effect any requested change to the
> >> > "production"
> >> > reporting database objects. We have read-only access to the production
> >> > server/database.
> >> >
> >> > To work around this, my unit has lapsed into the habit of running their
> >> > reports off the dev server (which they have control over). When I've
> >> > pointed
> >> > out to them respectfully, that they appear to be doing production work
> >> > on
> >> > a
> >> > dev server, I come up against a brick wall.
> >> >
> >> > "No." They say. "If we're not reporting off the production server, it's
> >> > not
> >> > production reporting." But then they go on to publish these reports as
> >> > representative of the state of the business.
> >> >
> >> > Now I would have though that any environment you use to produce outputs
> >> > that
> >> > you regard as being a part of your business are defacto "production",
> >> > but
> >> > I'm
> >> > getting no traction with such a novel concept here.
> >> >
> >> > It strikes me though, that Microsoft, given the price differential
> >> > between
> >> > their development and production licensing would have a fairly
> >> > water-tight
> >> > differentiation between dev and prod. What is MS's idea of the
> >> > difference,
> >> > and where can I find a version of it that is written in words that
> >> > grade
> >> > threes could cope with?
> >> >
> >> > Cheers
> >> >
> >> > GPO
> >> >
> >>
> >>
> >>
>

Production Report against OLAP database

We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated."Atul Mehta" <amehta@.oaktreecap.com> schrieb im Newsbeitrag
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.

---

Atul, you don't necessarily need another Reporting Tool. You need to decide
where you want to build your -> Data Warehouse or -> Data Mart in.
Regards,
Joerg|||If you're looking for cheap and easy, office web components (pivot tables),
or cheap and tedious: ASP web pages and PTS. You might want to see if MSFT
Reporting Services is a potential solution for you.
Another option is to build a star schema reporting database, which will be
useful for building cubes as well, but may eliminate the need.
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.
>
>
>

---

Processing OLAP Cube causes OLAP and SQL to shut down

Here's a situation I ran in recently, and I'm trying to discover root cause.
I should mention this was occuring on a active/active two-node cluster w/ 6
instances of SQL running on it. The OLAP service in question was tied to th
e
SQL Server service as part of the same cluster group.
I had a cube in OLAP I was attempting to process, but each time I tried the
OLAP service and the SQL Server Service that OLAP was using as a data source
would shut down and fail over to another cluster node. This would
continually happen each time we would try to process the cube - it would fai
l
over back and forth to the two nodes on the cluster.
Finally when we manually took the cluster group down and brought it back up,
everything stabilized. Not sure why this smoothed things out as the SQL
Server instance and the OLAP service had been on the correct node before, bu
t
now that we had moved the instance manually, everything was fine.
My only guess as to root cause was contention for resources. Does anybody
else have any ideas? Again, the problem I'm trying to understand is why
processing a cube will cause a SQL Server and OLAP instance to shut down.
Thanks in advance.Yes! Resource contention. If you are trying to run 6 instances of SQL
Server and at least 1 Analysis Services server on only a two node cluster,
you most assuradely have resource contention and it is called MEMORY, which,
too, is most assuradely used during the building of the cube.
How much memory are you running on those two nodes? What is the MAX SERVER
MEMORY configuration set to on each of the instances? What is the setting
for the source of the OLAP cube? Anything short of about 512 MB to 1 GB for
each instances, plus about 1 GB for the Analysis Services, is under capacity
for any real use production system.
Do you have 6 to 12 or so GB on EACH node?
Sincerely,
Anthony Thomas
"TX_KniveS" <TX_KniveS@.discussions.microsoft.com> wrote in message
news:9C541BA2-E1B4-46C8-8F1D-3D1D145A622C@.microsoft.com...
Here's a situation I ran in recently, and I'm trying to discover root cause.
I should mention this was occuring on a active/active two-node cluster w/ 6
instances of SQL running on it. The OLAP service in question was tied to
the
SQL Server service as part of the same cluster group.
I had a cube in OLAP I was attempting to process, but each time I tried the
OLAP service and the SQL Server Service that OLAP was using as a data source
would shut down and fail over to another cluster node. This would
continually happen each time we would try to process the cube - it would
fail
over back and forth to the two nodes on the cluster.
Finally when we manually took the cluster group down and brought it back up,
everything stabilized. Not sure why this smoothed things out as the SQL
Server instance and the OLAP service had been on the correct node before,
but
now that we had moved the instance manually, everything was fine.
My only guess as to root cause was contention for resources. Does anybody
else have any ideas? Again, the problem I'm trying to understand is why
processing a cube will cause a SQL Server and OLAP instance to shut down.
Thanks in advance.

Processing OLAP Cube causes OLAP and SQL to shut down

Here's a situation I ran in recently, and I'm trying to discover root cause.
I should mention this was occuring on a active/active two-node cluster w/ 6
instances of SQL running on it. The OLAP service in question was tied to the
SQL Server service as part of the same cluster group.
I had a cube in OLAP I was attempting to process, but each time I tried the
OLAP service and the SQL Server Service that OLAP was using as a data source
would shut down and fail over to another cluster node. This would
continually happen each time we would try to process the cube - it would fail
over back and forth to the two nodes on the cluster.
Finally when we manually took the cluster group down and brought it back up,
everything stabilized. Not sure why this smoothed things out as the SQL
Server instance and the OLAP service had been on the correct node before, but
now that we had moved the instance manually, everything was fine.
My only guess as to root cause was contention for resources. Does anybody
else have any ideas? Again, the problem I'm trying to understand is why
processing a cube will cause a SQL Server and OLAP instance to shut down.
Thanks in advance.Yes! Resource contention. If you are trying to run 6 instances of SQL
Server and at least 1 Analysis Services server on only a two node cluster,
you most assuradely have resource contention and it is called MEMORY, which,
too, is most assuradely used during the building of the cube.
How much memory are you running on those two nodes? What is the MAX SERVER
MEMORY configuration set to on each of the instances? What is the setting
for the source of the OLAP cube? Anything short of about 512 MB to 1 GB for
each instances, plus about 1 GB for the Analysis Services, is under capacity
for any real use production system.
Do you have 6 to 12 or so GB on EACH node?
Sincerely,
Anthony Thomas
"TX_KniveS" <TX_KniveS@.discussions.microsoft.com> wrote in message
news:9C541BA2-E1B4-46C8-8F1D-3D1D145A622C@.microsoft.com...
Here's a situation I ran in recently, and I'm trying to discover root cause.
I should mention this was occuring on a active/active two-node cluster w/ 6
instances of SQL running on it. The OLAP service in question was tied to
the
SQL Server service as part of the same cluster group.
I had a cube in OLAP I was attempting to process, but each time I tried the
OLAP service and the SQL Server Service that OLAP was using as a data source
would shut down and fail over to another cluster node. This would
continually happen each time we would try to process the cube - it would
fail
over back and forth to the two nodes on the cluster.
Finally when we manually took the cluster group down and brought it back up,
everything stabilized. Not sure why this smoothed things out as the SQL
Server instance and the OLAP service had been on the correct node before,
but
now that we had moved the instance manually, everything was fine.
My only guess as to root cause was contention for resources. Does anybody
else have any ideas? Again, the problem I'm trying to understand is why
processing a cube will cause a SQL Server and OLAP instance to shut down.
Thanks in advance.