Resource Governor

• lucassouzace

  SSC Eights!

  Points: 877

  More actions

  January 9, 2009 at 12:56 pm

  #199856

  What´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?

  And this is statements:

  ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION= dbo.rgclassifier1);

  GO

  for

  ALTER DATABASE Adventureworks WITH (STATE=ON)

  Thanks!!!

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 9, 2009 at 1:10 pm

  #924533

  lucassouzace (1/9/2009)

  ---

  What´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?

  SUser_Sname returns the user's login name. App_name returns the application that initiated the connection to SQL. In terms of the resource governor, one lets you limit resource based on who's logged in, the other lets you limit resources based on what they used to connect (a 3rd part app, Management Studio, SQLCMD, etc)

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• lucassouzace

  SSC Eights!

  Points: 877

  More actions

  January 9, 2009 at 5:30 pm

  #924711

  Good, thanks, could where make friends in sql server? because i'm brazilian understand? lately has study sql server 2008 and i haven't friends... but good for you my help, thanks!