Sql server 2012-How do users interact on a daily basis?
I've been searching Google, Youtube daily for help with this question. In a business environment, how do users outside of database admins use the database? I always see how to fix problems with SQL moving slow due to too many users, but I haven't been able to find the answer as to why they are using it in the first place. Any help would be appreciated.
It depends on the specific needs/scenario. Typically, users don't directly access the database but do so through an application (often, an internet or intranet web application). In those cases, you might only have 1 account connecting directly to the database because that is the account the application is using. But you might have 10,000 users accessing data through that single system account. Online stores are a great example of this. A company might have thousands or even millions of customers, but they aren't going to have independent database accounts for each one. The users will connect via a web farm, and the web farm servers then connect to the database via a system account.