Separating Users for each Application

• bion81

  Newbie

  Points: 9

  More actions

  April 30, 2012 at 3:12 am

  #255089

  Hi,

  Is there any advantage in creating separate database user for each application (Windows Service, Windows Desktop) that connects to the database?

  We trying to figure out if this can help as we are on the process of overhauling our services performance and notice that one of the service is having way too many processing compared to the other so we are thinking of creating separating user for each if that helps.

  If we have exclusive database user for each of our application, would it be possible to monitor which database user having higher usage?

  Please let me know your thoughts. Thanks in advance.

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  May 7, 2012 at 2:43 am

  #1483999

  Having separate users can help you to track and restrict their usage or activities.If you are using SQL 2008R2, resource governor can help you to manage resources usage for every user. See this http://www.bradmcgehee.com/2010/01/introduction-to-the-sql-server-2008-resource-governor/

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)