September 3, 2008 at 8:33 pm
Hi,
Is there a way to find out database is OLAP or OLTP. By the way I am using SQL 2005 server. Thanks
September 3, 2008 at 10:03 pm
duplicate post. http://www.sqlservercentral.com/Forums/Topic563534-146-1.aspx
if SQL Server hosts it, it's OLTP. if Analysis Server hosts it, it's OLAP.
---------------------------------------
elsasoft.org
September 3, 2008 at 10:09 pm
Thanks for the help. Further to that, how can I find out which server (SQL or Analysis) one is hosted my server. This may sound silly (any friendly DBA can help me locally, but it is not the case here for me), but if you can please give little bit of more information, it is much apprecaited. Thanks
September 4, 2008 at 3:07 am
I'm guessing it's how you would access using Management Studio. When you start MSand you are required to enter you credentials and which server you wish to connect to there is an option for 'Server Type'. The default option is database engine, but other options include Analysis Services. If you use the Analysis Services as a Server type then it's OLAP, if you use the 'Database Engine' then its OLTP.
If I'm wrong in this assumption please let me know...:D
September 4, 2008 at 5:49 am
Take a look at the services running on the server. Analysis Services, the OLAP engine, is completely different than SQL Server. That will till you which you have. However, you might have both. So, if it's a pure OLAP database, you can't open it from Management Studio using the Server Type of "Database Engine." Instead you have to use "Analysis services."
It's possible though, maybe, you're confusing terminology? Do you simply mean is it possible to differentiate between an OLTP database and a reporting database? Because the thing is, OLAP is completely different than Relational and when we're talkiing about OLTP, we're talking Relational. However, we're also talking Relational when we talk about star schema's, data warehouses, datamarts, etc.
"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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply