How to check database server is OLAP or OLTP (2024)

Question

_{Thursday, November 15, 2012 6:56 AM}

Hi All,

I want to check database server is OLAP or OLTP.

Anyone have any idea regarding this.

Thanks in advance.

All replies (1)

_{Friday, November 16, 2012 2:19 AM ✅Answered}

Hi Anuj,

OLAP/OLTP isn’t a database type distinction. It refers to how the DB is used.

OLTP – OnLine Transaction Processing. So if the DB is constantly getting small requests from a time-critical transaction processing system, then it’s more and OLTP database.

OLAP – OnLine Analytical Processing. Refer more to the ‘data warehouse’ type systems where the bulk of the activity is large reports, aggregations or similar type queries.

Also in brief, when you use SQL Server Management Studio to connect to SQL Server, if you choose ‘Analysis Services’ as server type then it’s OLAP, if you choose ‘Database Engine’ then it’s OLTP. For more details, please refer to this similar thread.

Ray Chen

TechNet Community Support