Viewing 4 posts - 1 through 4 (of 4 total)
for new databases, you can create a server side DDL trigger that tracks CREATE_DATABASE event and in there just execute 'create user' for your DB,. more info :
November 14, 2013 at 10:05 am
Thank you. That suggestion was extremely helpful. I reduced the AppPool min memory to 40% and DBCC works like a charm now. I'll see if i can leave it at...
November 14, 2013 at 9:16 am
i think i confused you. i did not set a min memory for DBCC pool. here are my pool settings for DBCC and APP pools:
CREATE RESOURCE POOL [DBCCMaint]
WITH (min_cpu_percent=0,
...
November 13, 2013 at 2:21 pm
Thanks. I tried that as well. I created a seperate pool for it and only made 10% of Memory Available for DBCC. yet same result ?Anything i am doing wrong...
November 13, 2013 at 12:34 pm
Viewing 4 posts - 1 through 4 (of 4 total)