SQL MP Classes: DB vs DB Engine

Dashboard Server
, , ,
1

Hello,

In all the SQL mps, there are the two following Classes:

DB
DB Engine

Can someone please clarify what is the difference between them (if exist…)?
The MP guide isn’t so clear about it…

Thanks,

2

Does these chart help?

https://technet.microsoft.com/en-us/library/dd279730.aspx

http://mpwiki.viacode.com/default.aspx?g=posts&t=207475

http://mpwiki.viacode.com/default.aspx?g=posts&t=207478

SQL Server 2012 DB Engine
Hosted
An installation of Microsoft SQL Server 2012 Database Engine. The database engine hosts databases and other SQL Server components.

SQL Server 2012 DB
Hosted
Microsoft SQL Server 2012 database

But if I´m reading your question right. DB is the database itself. And DB Engine is the SQL server engine?

sql_mp.png
sql_mp.png931×747 70.4 KB

1 Like
3

Hello jannep,

Thanks for the quick answer, very much appreciated.

The chart is also documented in the MP guide, but it’s very crowded and not so understandable.

I’m not familiar with this area of Windows SQL Server,
But as far as i know, DB Enging is the core service/componet in every SQL DB.

So basically DB and DB Engine are the same, am i wrong here?
I can’t tell the difference between those two…

4

@dgallay thanks for making this subject clear for me

5

Login required - can you add to the answer?

6

Which one required login?

7

DB Engine is the SQL Instance (for example, MSSQL or named instance of the SQL service) – what you connect to in SQL Studio. DB are the actual databases hosted on the DB Engine.