Viewing 15 posts - 1 through 15 (of 15 total)
I thought in 2008 R2 you could use the command RESTORE DATABASE db WITH NORECOVERY, and the database would flip back to a recovering state. Is that not the...
June 13, 2013 at 11:57 am
Thank you. Do you have any thoughts on why we would be seeing higher writelogs waits just before the signal waits get high, even though there is little to...
February 22, 2013 at 8:26 am
I could not get it to work through using the GUI. It would still prompt that a snapshot was needed. However, I was able to script it. ...
February 18, 2013 at 10:26 am
Thank you. I will try that.
February 14, 2013 at 9:02 am
You are correct in that if I remove the article from the publication and add it back once renamed, a snapshot of only that table will be taken. I...
February 8, 2013 at 1:58 pm
I figured it out. There is a legacy dev user on the untrusted domain with the same un and pw. I created the prod user on the untrusted...
May 8, 2012 at 10:36 am
It is a one way trust. I have read this article. This does not explain why the dev account works.
May 2, 2012 at 2:07 pm
The two service accounts are on the same domain. The user I am signed in as is on another domain, but this user is a sysadmin.
Note: If...
May 2, 2012 at 12:26 pm
We just doubled the number of CPUs, going from two Quad-Cores to two 8-Cores, and the queries haven't changed.
If parallelism is the problem, is it best to set the MAXDOP...
October 21, 2011 at 2:42 pm
Wait typeWait time (s)% waiting
CXPACKET49125222.81
SQLTRACE_BUFFER_FLUSH30631514.22
BROKER_TASK_STOP1947059.04
SOS_SCHEDULER_YIELD1783828.28
LATCH_EX1666517.74
PAGEIOLATCH_SH1644227.63
WRITELOG1412016.56
BROKER_RECEIVE_WAITFOR1181395.49
BACKUPIO998744.64
BACKUPBUFFER985254.57
October 21, 2011 at 2:12 pm
The exact version is 9.00.4340.00.
During the peak of the problem, we are seeing 95% of the waits are of type "Memory/CPU". Followed by Writelog, PageLatch_SH, CXPacket, Latch_EX, ...
This is...
October 21, 2011 at 2:08 pm
My knowledge of wait types is limited. Are CXPacket waits the only way to see problems with parallelism? Is Ignite possibly bundling up different wait types under "Memory/CPU"...
October 21, 2011 at 1:31 pm
I am showing the available memory as 7.5GB right now. We reset the Max Memory about 36 hours ago.
October 21, 2011 at 1:23 pm
I am not seeing an abnormally high number of CXPacket waits.
October 21, 2011 at 1:22 pm
Viewing 15 posts - 1 through 15 (of 15 total)