audiocool (5/22/2015)
GilaMonster (5/22/2015)
audiocool (5/22/2015)
is the following service require to turn onSQL Server Analysis Service ?
Are you planning to use it's features? Are you planning to build cubes, do data mining and the like on this server?
If so, then yes (though you probably would be better off using a different server). If not, then no.
I'm not sure what is the build cubes and data mining..
Our SQL server basically used for data exchange purposes (application <-> database)
Then SSAS is probably unnecessary.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning