Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resource Governor Expand / Collapse
Author
Message
Posted Friday, January 9, 2009 12:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 1:10 PM
Points: 109, Visits: 79
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!!!
Post #633798
Posted Friday, January 9, 2009 1:10 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:46 PM
Points: 42,462, Visits: 35,525
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 2008, MVP
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

Post #633816
Posted Friday, January 9, 2009 5:30 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 1:10 PM
Points: 109, Visits: 79
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!
Post #634015
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse