database features

Question

database features

starttreck2016

Ten Centuries

Points: 1215
More actions
October 24, 2016 at 7:08 am

#314746

is it always better to add database features like analysis services and integration tools and reporting services
when installing sql server instance, and it wont complicate and cause issues on the databases or the instance

Viewing 15 posts - 1 through 15 (of 21 total)

You must be logged in to reply to this topic. Login to reply

BrainDonor SSCoach Points: 19256 More actions · Answer 1

sqlserverDBA2016 (10/24/2016)
is it always better to add database features like analysis services and integration tools and reporting services
when installing sql server instance, and it wont complicate and cause issues on the databases or the instance

Install the aspects of SQL Server that you need - you can add features later, if required. If you have no need for analysis services, reporting services or SSIS then don't bother - it just increases the amount of resources, monitoring and maintenance required for no gain.

However, on a personal dev system I install everything so I can play with whatever pieces I feel the urge to, without having to go back and install additional parts.

Steve Hall
Linkedin
Blog Site

Phil Parkin SSC Guru Points: 246993 More actions · Answer 2

BrainDonor (10/24/2016)
sqlserverDBA2016 (10/24/2016)
is it always better to add database features like analysis services and integration tools and reporting services
when installing sql server instance, and it wont complicate and cause issues on the databases or the instance
Install the aspects of SQL Server that you need - you can add features later, if required. If you have no need for analysis services, reporting services or SSIS then don't bother - it just increases the amount of resources, monitoring and maintenance required for no gain.
However, on a personal dev system I install everything so I can play with whatever pieces I feel the urge to, without having to go back and install additional parts.

Except for SSAS, where you have to decide between tabular and multidimensional ... I'd like to play with tabular, but I can't. I guess I could create a separate instance, but what a hassle.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

starttreck2016 Ten Centuries Points: 1215 More actions · Answer 3

Is it easy to add them later, it isn't more complicated

Jeff Moden SSC Guru Points: 1004441 More actions · Answer 4

BrainDonor (10/24/2016)
sqlserverDBA2016 (10/24/2016)
is it always better to add database features like analysis services and integration tools and reporting services
when installing sql server instance, and it wont complicate and cause issues on the databases or the instance
Install the aspects of SQL Server that you need - you can add features later, if required. If you have no need for analysis services, reporting services or SSIS then don't bother - it just increases the amount of resources, monitoring and maintenance required for no gain.
However, on a personal dev system I install everything so I can play with whatever pieces I feel the urge to, without having to go back and install additional parts.

In high contrast to that, I install everything and simply turn off services.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

starttreck2016 Ten Centuries Points: 1215 More actions · Answer 5

Is adding the features later same as when installing SQL server

And it's not more xomplicated

Phil Parkin SSC Guru Points: 246993 More actions · Answer 6

sqlserverDBA2016 (10/24/2016)
Is adding the features later same as when installing SQL server
And it's not more xomplicated

I think that Jeff's point of view is that it's safer to reconfigure a (working) production server's services than to install additional software on it.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

starttreck2016 Ten Centuries Points: 1215 More actions · Answer 7

So u agree that it's better to install it when installing SQL server

Phil Parkin SSC Guru Points: 246993 More actions · Answer 8

sqlserverDBA2016 (10/24/2016)
So u agree that it's better to install it when installing SQL server

If it's a development machine, I wouldn't worry about it one way or the other, but for a production server, yes.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Jeff Moden SSC Guru Points: 1004441 More actions · Answer 9

Phil Parkin (10/24/2016)
sqlserverDBA2016 (10/24/2016)
Is adding the features later same as when installing SQL server
And it's not more xomplicated
I think that Jeff's point of view is that it's safer to reconfigure a (working) production server's services than to install additional software on it.

Correct. Easier, as well. Just right click on the service and enable it. No need to go through a feature install. Doesn't take many resources at all when disabled.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

starttreck2016 Ten Centuries Points: 1215 More actions · Answer 10

Thanks mate

Just can I confirm, the ssas and ssrs and ssis can they be disabled from services after being installed

Phil Parkin SSC Guru Points: 246993 More actions · Answer 11

sqlserverDBA2016 (10/25/2016)
Thanks mate
Just can I confirm, the ssas and ssrs and ssis can they be disabled from services after being installed

Confirmed. Though I tend to use SQL Server Configuration Manager for such things.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

starttreck2016 Ten Centuries Points: 1215 More actions · Answer 12

starttreck2016

Ten Centuries

Points: 1215

October 25, 2016 at 5:45 am

#1908563

And can u please tell me how to disable them

Phil Parkin SSC Guru Points: 246993 More actions · Answer 13

sqlserverDBA2016 (10/25/2016)
And can u please tell me how to disable them

Right-click the service you want to disable, select Properties and then, on the General tab, set Startup Type to 'Disabled'. The service won't start again until this is changed.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

starttreck2016 Ten Centuries Points: 1215 More actions · Answer 14

hey guys i was reading oi the microsoft installation guide and it said the following about installing database features:

In this step, you can choose what features to install. It is highly recommend NOT to choose all the features on a production server if you don't need them. Choose only the features that you need or might need. Conversely you might want to select all using a development server in order to give you more flexibility in your development environment. Once you choose to use another feature you will be able to add it in production later on.

its a bit confusing now , cos i wanna install the ssas and ssis and ssrs but because im doing straight on the new server and not enough time is provided for testing, on the other hand i dont wanna reinstall them later on a running production server.

The other thing i wanna check , is if i wanna disable them how would i do that , is it right click services and disable