Viewing 15 posts - 31 through 45 (of 55 total)
Ok, after some testing, it looks like if you leave those 3 textboxes empty, it uses the account that the SQL Service is started by. Can anyone confirm? ...
November 2, 2012 at 8:39 am
Lee Crain (10/31/2012)
This page from Paul Randal's blog may assist you:http://www.sqlskills.com/blogs/paul/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
Cool article, thanks for posting it!
One of the main servers I deal with has CXPACKET waits of about 60%....
October 31, 2012 at 2:00 pm
On a side note, how can I determine which accounts have connect permissions to the endpoint?
October 31, 2012 at 11:20 am
Perry Whittle (10/31/2012)Early on in the wizard, you will be prompted to connect and this account should have permissions to create and manage users and grant permissions.
Later, the wizard...
October 31, 2012 at 11:13 am
Does that query work through sqlplus?
October 30, 2012 at 2:40 pm
Between 0, 1, and 5, I would say 0 will write the fastest and 5 will read the fastest.
October 30, 2012 at 2:34 pm
Thanks all. I did get the article. It looks like a reboot is required after setting the interface so I will have to wait and test during the...
October 25, 2012 at 2:39 pm
Thanks Jo, I have 11.2.0 installed. TOT_DATE is actually a number. Do you have a link to that Oracle support file? I don't have an account with...
October 23, 2012 at 3:00 pm
Good reads, thanks for the information.
So do you guys think this will be used more effectively in future versions of SQL?
October 12, 2012 at 9:09 am
Perry Whittle (10/4/2012)
"it's late and you're rebooting the SQL Server but it's taking forever to shutdown and restart, why shouldn't you hold the power button for 4...
October 5, 2012 at 12:37 pm
I'm curious as well, LOL! I installed the 64 bit first, so maybe I only needed the 32 bit client for it to work. I do know for...
October 4, 2012 at 2:08 pm
Thanks for the links guys! Wow, what a zoo. I finally got it to work, but it was a chore. I had to install both the 32...
October 4, 2012 at 10:45 am
Just a quick update. This happened again and I tried to restart the endpoint and that worked. Thanks!
October 3, 2012 at 11:32 am
What other jobs do you have scheduled? Has that job even ran yet?
Some of my infrequently running jobs won't show up in history either because even at...
October 2, 2012 at 11:12 am
saidapurs (9/25/2012)
Ya i have same setup & already i faced this issue. First your restart your witness server or make it up then restart primary...
September 25, 2012 at 8:39 am
Viewing 15 posts - 31 through 45 (of 55 total)