Viewing 15 posts - 16 through 30 (of 38 total)
Min server Memory (MB) - 30720
Max Server Memory (MB) - 102400
Perfmon shows SQL Server:memory Manager:Total Server Memory (KB) at 104,857,600 ( or 102400 MB)
October 11, 2010 at 2:09 pm
Did you find an answer to this, I am having a similar problem?
By any chance do your applications resources hang with a resource conflict when failing over?
March 23, 2010 at 8:12 am
I read through the posts and I can't agree more with what I read.
I find myself using the same answer to many questions as a DBA...IT DEPENDS
That seems to be...
March 17, 2010 at 6:11 am
Ok...I am going to answer my own post
I worked with MS on this all day and this caused quite a mess.
First...
I am not quite sure how this mess started but...
March 16, 2010 at 2:27 pm
Jose...thank you, this is what I expected but I just wanted to make sure.
I could not find any documentation that explained that a security patch was cumulative.
This patch falls between...
October 19, 2009 at 3:23 pm
I have taken the cheap way out.
I have added the domain admin user directly to SQL Server as a 'Windows Athentication' login with sysadmin priveledges. This is what I...
June 12, 2009 at 7:39 am
Steve Jones - Editor (6/11/2009)
I assume the domain is correct, and that you can log on locally to the VM.
YES
Can you log on with NT Auth to (local)?
Never had to...
June 11, 2009 at 2:28 pm
Here is an example....
2009-06-11 16:09:04.08 Logon Error: 18456, Severity: 14, State: 11.
2009-06-11 16:09:04.08 Logon Login failed for user...
June 11, 2009 at 2:14 pm
Thank you very much Gail.
I appreciate your help.
I will have to devise another solution.
May 20, 2009 at 5:40 am
Thank you for the response Gail.
Yes, I found that it will allow you to detach a read-only (STANDBY) database. Kind of strange that you would not be able to...
May 19, 2009 at 6:13 pm
Thank you for the response but I can not afford data loss.
Also, I do not think that this would leave the DB in STANDBY mode which would be my end...
May 19, 2009 at 2:35 pm
thank you Gail...you were spot on correct.
Parameter sniffing was the problem.
I re-wrote the procedures and we have not seen the problem since.
March 20, 2009 at 2:05 pm
I actually worked with MS to answer this question.
This article should help:
March 20, 2009 at 1:59 pm
I have uploaded my sample code.
disclaimer...i take no credit for this code, I simply have the joy of debugging it 😀
This is a snippet of the original procedure, but I...
March 11, 2009 at 4:07 pm
I'm fairly confident.
@AbsTab is created as a table variable just above the INSERT.
'absence' is a hard table, if we were not hitting the proper table here due to ownership we...
March 11, 2009 at 3:42 pm
Viewing 15 posts - 16 through 30 (of 38 total)