Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 10832
5
votes
Resource governor classifier functions only run during the Login process. Impersonation via EXECUTE AS does not trigger the classifier function. EXECUTE AS is how SQL Server Agent runs jobs in the …
answered Aug 29 '17 by Max Vernon
1
vote
It seems reasonable to assume, per the documentation and indeed the names of the parameters themselves, that MIN_IOPS_PER_VOLUME and MAX_IOPS_PER_VOLUME control the maximum quantity of I/Os per second …
answered Jun 6 by Max Vernon
5
votes
This MSDN page states the memory settings only affect query memory: Resource Governor Resource Pool MIN_MEMORY_PERCENT and MAX_MEMORY_PERCENT These settings are the minimum and maximum amoun …
answered Aug 4 '15 by Max Vernon
1
vote
A "volume" is either a drive letter, or a raw partition in SQL Server. For a resource pool configured for X maximum IOps per volume where a query uses tempdb, splitting that tempdb across multiple vo …
answered Nov 7 '17 by Max Vernon